MYSQL :: Mysql -s -u Root Bmd

Root May Only Connect From Localhost; Locked Me Out Of Root
looking at this:

http://dev.mysql.com/tech-resources/articles/securing_mysql_windows.html

First thing I did was change my root account username to another one for security. Worked fine, logged out of MySQL administrator and logged back in with new user.

Then I did:

DELETE FROM user WHERE user = '(mynewrootusername)' AND host = '%';

Which apparently only allows root login from localhost. After doing that command, I can no longer login to mysql administrator. Error 1045, access denied from...etc.

When I login to the mysql cmd prompt the window just closes immedietly.

My windows host file is correct.

View Replies !

Slow MySQL
mySQL has been running very slowly and I am getting errors. First I did 2 things I raised the ServerLimit number (apache) to allow for more connections, I also raised the max conncetions in my.cnf. I do not know if this took effect? That should have worked. But basically in phpmyadmin i get this error frequently. I am getting more traffic so I think it is that.

MySQL said: Documentation
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

View Replies !

Why Does MySQL So Slow
I just changed to use MySQL few days ago but it was a bad idea. My server now is running very slowly with the database. I'm using Perl5 and DBD::Mysql in my script. The system is Linux9, Apache2.

I looked at these mysql pid and saw a lot of activities (about 400) while there are more 100 users online at this moment and lots of running under a the same pid number.

View Replies !

MySQL Slow
I had downloaded a few years back mySQL v3.51 installed but never used it. Now I wanted to convert some B-TREE databases to mySQL and did some testing via ODBC to insert 70,000 records: My results:

MS ACCESS: ~60,000 msecs
MYSQL v3.51 ~18,000 msecs

Impressed with the speed, I went ahead and got the latest MySQL v5.1. Uninstalled the older version, I had nothing there to preserve, so I did a simple new install with MySQL v5.1. I noticed the size of the files and BINEXE increasted by 1,000,000%. Ok, Bulky. Not a problem.

I reran the same ODBC test, and now I got:

MYSQL v5.1: ~450,000 msecs or 7.5 freaking MINUTES!

What the hell happen? Nothing was done. I'm knew to MYSQL. I just installed it with all the defaults. I did choose "developer's machine" for the "optimizer wizard"

I can't redistribute MYSQL v3.51 and force it down people's throats! I have to use what they are using already, if already installed. Not even my current system takes 1 minute to add 70,000 records. Why 7.5 minutes? All it is simple inserts/free statements.

View Replies !

MySQL Slow Log
I have the long query time set to 15 yet MySQL is still showing results with a query time of 0 in the slow query log.

It says enter time in "seconds" in the MySQL Administrator but did it mean in milliseconds??

View Replies !

MySQL Slow In Windows NT4
I am running the Apache web server, MySQL v4, and PHP on an NT4 server.
Apache runs great, but the auction software I am using (Web2035 Auction
software written in PHP) is very, very slow.

Sometimes it takes 20-30 seconds to bring up an auction page from the items
table which has less than 200 records in it.

Can anyone can give me some pointers on where to start looking? (I don't
know if the bottleneck is with MySQL or PHP or what I might need to look at
to enhance the performance of either package.)

View Replies !

Slow Mysql Select *,
I have a sql table with more then 20,000 rows in a table called summary and when I run "select * from summary" it returns a exucutions time of 0.5 seconds in php which is kinda slow if you ask me, now I know that the * type for select isnt the fastest way to fetch data but its the most convenient for me.

View Replies !

MySQL Slow Starting Up
I am using a Windows 2003 Web Edition Server running IIS and MySQL 4.1. I had to restart the server the other day and it took MySQL almost 2 hours to come back up. I was watching it on my task manager and it went up to approximately 60,000k in 10k increments before I was able to access MySQL.

My CPU usage was hovering around 3% all this time. Everything else came up on the server just fine. This happens every time I have to restart my server. The reason I have to restart my server most of the time, is because MySQL locks up on me.

Is there any settings I can change that would help me here? Any help would be greatly appreciated.

One more thing to add. I am using the default my.ini file. We have almost 100 different databases on the server and have around 20000 tables within all of these databases combined. All of these tables are InnoDB tables.

View Replies !

MySQL Running Very Slow
I have the following INSERT SQL, which runs very slow (For 2 full days it had not done anything) on a 2 processor Compaq machine running Suse Linux. Code:

View Replies !

MySQL Is Slow, Trying To Optimize
It just seems that my system is slow, adding records, etc. I tried to optimize it, saw that there was a my-medium.ini file, read that is was for medium sized system. I replaced it with my.ini (yes I did make a backup, thankfully) and restarted mysql.

Pretty much it hangs. I tried to connect with QueryBrower, did a Select Count(*) and just froze. I admit that I didn't wait for ever, yes I know I Select Count(*) takes a long time but I gave up after waiting 3x as long as I normal did. Also the logs screen froze in administrator.

View Replies !

Slow Running MySQL?
I'm hoping someone may have an idea what could be causing the slow loading pages of my web-site. I'm not positive, but I'm relatively sure that it's related to a problem with MySQL database.

I purchased a program called Sam3 for broadcasting our radio signal over the internet. The software requires the use of MySql in order to set up web pages for our web site.

The problem is, that while everything works GREAT (requests can be made from the site, songs can be searched, the history of what we've played shows up) the pages load PAINFULLY slow. Other users of this software have had no such problems so I'm at a loss.

I know from testing that the PHP script for the web pages is fine, I have plenty of bandwith both upload and download available on my DSL line, and while the computer running MySQL is behind a router I have tried plugging the DSL line DIRECTLY into the host computer and it makes no difference.

For all appearances it seems the problem is that it takes MySQL forever to gather and provide the information needed for these pages. Does anyone have any idea what I should be looking at to solve this problem?

I do not know the MySQL program at all, so I get somewhat lost when people start throwing out technical terms, but this has been really frustrating because no one else seems to have the problem and everyone so far has just told me to check the things I've already checked.

View Replies !

MySQL Connection Sometimes Slow
I have been developing an application in Visual Basic that accesses a MySQL database either on the local machine, or a remote machine. Locally, database connections run smoothly. However, when I try to connect to the remote system (another computer on my local network) some databases take longer to connect than others (sometimes 10 - 20 seconds).

The application usses the myvbql.dll (sorry lost the link, found it through google) wrapper around the libmysql.dll file to perform database actions. The application seems to hang when it tries to actually make the connection to the datatbase. This is only happening on the remote database server, and does not happen on every connection to that server.

View Replies !

Slow Remote MySql
We have a local (client) machine that runs a php application on windows using apache, the database for this application is on a remote server, which the client machine connects to via the servers ip number and the server accepts the connection from the client via the designated ip address (skip-resolve-address is set in MySql server and no dns addresses are used, only ip).

However, the php application when dealing with the data from the MySql server is still pretty slow. We've tried query cache, but still slow.

When I say slow, I mean page response and reloads take about 5 or 6 seconds. Is this expected from a remote server and using apache as we do for this application? When using a local MySql server the speed is pretty much instantaneous, but we need the remote server!

Also, in testing the remote MySql server with a program such as SQLyog, response to requests are very quick and queries take no time.

How could we go about testing for where the bottleneck is? Could it be apache and php (and where do we start looking for the problem? Local MySql server is nice and fast)?

View Replies !

MySQL ODBC 3.51 Driver Very Slow!
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL
tables to a Microsoft Access 2003 database. I am finding that the data from
the MySQL tables takes a hell of a long time to load making any kind linkage
with my Access data virtually useless.

I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting
out on a server and the Access database is running locally.

View Replies !

MySQL Slow: Configuration To Blame/fix?
I have MySQL 5 running on a PC, and have grown used to the startling slowness of MySQL joins. The most recent disappointment is a straightforward self-join of a not-too-big (700K rows), indexed (on very-high-cardinality column FILE) table

create table temp2 as
select a.*, b.time as time2,
from temp1 a left join temp1 b
on a.file = b.file
and timestampdiff(HOUR,a.time,b.time) = 1;

that completed in 10 hours. (Indexing resulting table took 20 minutes). If this is not a problem with the programmer, or with MySQL, could it be a result of a mismanaged installation, one that could be fixed with a judicious re-configuration/choice of MySQL options?

View Replies !

Delay, Latency, Slow Mysql
I recently upgraded mysql from 3.23 to 4.0 and found that my websites using the mysql db had a 5 second delay, or latency. I searched for 2 days and found no answer to my latency problem until just a moment ago. I'd like to share the answer in case someone else finds this occurring to them as well.

I was using my real static ip in my website mysql address instead of 'localhost', localhost should have been used initially anyways. I am not real sure what my reasoning was when I initially chose to put in my static IP.

So, If you are like me and keep your stuff on your local machine, use 'localhost' instead of your static IP. At least it fixed my delay issues.

View Replies !

My MySQL Back-end Works Very Slow
I have installed my MySQL Server in a Window XP platform running in a Pentium4 machine. When I access the database on the machine, it is working in a normal speed. But when I access the database from a client machine (still running in windows platform), it runs very slow.

View Replies !

Mysql 5.0 - Using My.cnf - Unix / Slow-query-log
I installed mysql 5.0 and need to set up slow-query-log and other logging options.

Here is what I did. But I dont see it working yet.

1. cd /var/db/mysql
2. chown mysql slowquery.log
3. touch /usr/local/etc/my.cnf
4. chown mysql /usr/local/etc/my.cnf

vi my.cnf

[mysqld_safe]
-u mysql
--log-slow-queries=/var/db/mysql/slowquery.log

so now when I type:

mysqladmin shutdown
and than

mysqld_safe &
my sql restarts but the log files are not being used.
also - how do I know if my my.cnf is being used at all?

View Replies !

Remote MySQL Connection Slow
I have a website on a dedicated server that was running really slow, so I got another, much faster server and transferred the MySQL database to this server. However, now when I connect to the faster server's database using the slower server's PHP web pages, the overall page loads much slower than when the database was on the slower server.

Any ideas why this would be? Right now the host name is just an IP address. Does it need an actual resolved hostname to be fast? MySQL on the faster server is supposedly tweaked for fast service (my-huge.cnf).

View Replies !

Slow Performance After Falling Back To MySQL 3
Yesterday I have upgraded my linux box with a pair of Xeon 1G CPU and
reinstalled everything (it was a sinle Xeon 700). The default RH9
installation comes with MySQL 3.23.54. After the reinstallation I
found the machine was not as responsive as before. (It's not very
slow, but some lagging is noticed)

I was running Mysql-max 4.0.11 and the performance was ok, except the
slowness during the peak hours, which was regarded as normal. I would
like to know the differences between Mysql 3 and 4. Is the new version
making a significant jump in performance?

I also noticed the system eats up memory faster than before. With the
old setting the system never used up 60% of physical memory, even at
extremely high loading (30+). Now it easily used up 70% of memory.

Code:

View Replies !

Mysql Running Slow On Mandrake Linux 10.0 For AMD 64
I'm having a problem with a new machine running Mysql version 4.0.18
on the AMD64 version of Mandrake 10.0. The new machine has got 64bit
AMD processor and 2GB of RAM.

Nearly all queries(updates are especially slow) are running 20/30 or
more times slower than on an inferior(32 bit processor, 1.5GB RAM)
machine runnning Mysql 3.23.56 on mandrake 9.0.

As far as I can tell mysql is configured correctly for the power of
the machine. The my.cnf file looks like this: Code:

View Replies !

MySQL Slow To Connect To Remote Database
I was running a PHP/MySQL web site with the database on the local web server. I needed to move the database off the webserver (located in the firewall DMZ) and onto its own machine (behind the firewall on our private network)

Now when I run my web site it goes really slow. I ran mysql from the command line on the web server and connected through to the database machine behind the firewall using
webserver:/# mysql -h 192.168.1.7 -u www-data -p

After I enter the password, it takes around 5-7s before I see the mysql> prompt.

Is mysql trying to do reverse dns on the IP address and timing out? I added the machine details to /etc/hosts so it would be recognized but no improvement. Or do I have something wrong with my mysql configuration?

View Replies !

Slow Connect Linux To Windows MySql
I have a Linux box with the latest MySql and another box (Windows 2003 Server) with the latest Mysql.

From the unix prompt I do this:
mysql -uroot -pmypass -h windowsserver mydbname

this take about 4 seconds to connect

I do the exact same thing on a windows workstation and its connected instantly.

View Replies !

VER VERY VERY Slow MySQL Query HELP URGENTLY NEEDED
I have the following MySQL query, but it is VERY VERY slow and seems to be crashing the server. There are 300,000+ records in the 'tracker' table.

SELECT sites.*, SUM(if(tracker.type='view',1,0)) AS numberOfViews, SUM(if(tracker.type='click',1,0)) AS numberOfClicks, SUM(tracker.revenue) AS totalRevenue FROM sites LEFT JOIN tracker ON tracker.site_id = sites.id GROUP BY sites.id ORDER BY sites.domain_name

View Replies !

MySQL Timing Out? Really Slow Queries, Already Indexed.
For whatever reason, MySQL does not seem to be executing. So, I ran a few stat functions and here is what I got:

Uptime: 220372
Threads: 39
Questions: 18748899
Slow queries: 808
Opens: 28723
Flush tables: 1
Open tables: 4096
Queries per second avg: 85.078

The "open tables" worries me for a few reasons. First, because it is 4kb (exactly, since it is divisible by 1024, evenly). This makes me think that maybe I am hitting a ceiling.

Second, there are a few variables in MySQL that equal this, and maybe it's a cap on something. Here are the variables that equal 4096:
query_cache_min_res_unit = 4096
table_cache = 4096
transaction_prealloc_size = 4096

Do any of those have anything to do with this? Am I even close? Are any of those values from mysql_stat a big deal?

View Replies !

User Admin In Mysql-administrator Slow On Linux
We have a MySQL 5.0.16 server installed on a RedHat 8.0 machine.
mysql-administrator v1.0.22 is installed on RH Linux FC3 from the
mysql-administrator-1.0.22a-1.rh9.i386.rpm.

Everything seems to run fine except User Administration is *extremely*
slow. If I click on "User Administration" in the sidebar, it takes
about 2 minutes (seems like forever) before the window comes back with
the infomation. All the other functions seem to function fine.

Is it because I'm using mysql-administrator on a remote host? Do I need
to move and rebuild the server to a newer Linux version? mysqlcc
doesn't have this problem at all. (It's using the libraries from MySQL
4.1 that the databases were migrated to.)

View Replies !

Mysql -u Root?
If I type mysql -u root mysql, I have the message: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
If I type mysql -u root -p mysql, MySQL prompts me for the password.

Is that normal?
Shouldn't I provide my password in the command line?

View Replies !

MySQL Root
I installed MySQL in RedHat 9's usr/local. I found the the 'data' folder with two subfolders:'mysql' and 'test'. Both subfolders are empty.
I have 8 databases in total. There's no subfolders of each database! Where are they?
As for the age group calculation, I'm still working on it. I've decided to use temporary table

View Replies !

MySQL Root Directory
I am using flex for interface, java for intermediate code and mysql for DB. My website contains videos so instead of uploading them on db, i have instead put a path in db and stored videos on machine. the path is '/images' for images and '/video' for videos. Before I was using IIS server and when i used to put my index.html (along with .swf and .js) file and 'images' and 'video' folder in /inetpub/wwwroot folder, it used to work fine. now i am working with tomcat, and i have tried placing 'images' and 'video' folder everywhere but its not working. I am sure that database is connected because there is some info of videos stored directly in database that i get.

View Replies !

MySQL Root Account
My root privileges are all messed up and now I can't connect to the server using MySQL CC

[root] ERROR 1045: Access denied for user: 'root@somedomain.com' (Using password: YES)

Could someone provide me with some suggestions on regaining my privileges?

View Replies !

How Do You Log In As Root User On A Mac In Mysql?
Basically I want to login as the root user and I simply can't.

I do this: mysql> -u root

and nothing happens

when i use the status command it shows that the user is: russjones@localhost

I do not have any problems on windows, but I'd like to use the mac.

Does this have anything to do with a bash profile?

View Replies !

Can't Start Mysql As Root
i made a mistake in adding password to the root account not i can't start it as root but can as user, the error is:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
the mistake was i wrote the root@localhost without single qoutes, i also tried with --skip-grant-tables and --no-defaults but the result is:
ysql: unknown option '--no-defaults'
ysql: unknown option '--skip-grant-tables'

View Replies !

MySQL Root Password
I am having some trouble setting up the mySQL root password. It's probably right under my nose, but I can't seem to find where to edit it.

View Replies !

Mysql Service And Root Password (-w W)
I have a few qeustions for some linux/mysql pros in here.
Background: I've just built MySQL on Mandrake Linux 9.1 from source.
I can get the mysql service running my:
shell> /usr/local/mysql/bin/mysqld_safe --user=mysql &
but I don't know how to keep it running, or how to make it start at
every bootup. How do I do that?
Also, I've made an alias to mysql:
alias=/usr/local/mysql/bin/mysql
but it won't span sessions, I think I need to export it, but I'm not
sure how to.
Also, via mysqladmin I set the root password to "password" which I
don't want to keep :) how do I got about changeing it now?

I know I probably should have installed via RPM, but I'm wanting to learn as much as I can about all of this.

View Replies !

Restore Root Access To Mysql
I'm another linux noob running redhat 9 and the included mysql.

I had it working using phpmyadmin to configure it until I follishly removed my
permisions for root trying to secure my server in phpmyadmin. Is there
anyway to get this back? I've tried the grant options but I can't even
logon to mysql as root@localhost. Thanks for any tips.
jedihermit@jedihermit.com

View Replies !

Reseting MySQL Root Passwd
I forgot the MySQl root password since I installed it. is there a way to reset it? It is running on Fedora Core 3 and I have Linux root access.

View Replies !

Root Password :: Cannot Login To Mysql
i am new to mysql.i have installed mysql software which is provided with Linux CD .i need to provide password to root.i updated the user table to give password to the root.after restarting the mysqld service , i couldnt enter into mysql .one error message is displaying

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

View Replies !

'mysql -h Localhost -u Root -p' Shortcut
A strange qustion, but i was wondering if there was a quick way to log into mysql in terminal on OS X without having to type mysql -h localhost -u root -p everytime. This is purely for time saving reasons, and I'm sure you might think 'why doesn't he just type it?' but I'm curious.

View Replies !

Problem Starting MySql From Root
I am in the process of creating a database which will serve as a backend for the registration of users' details and to handle account activation via the use of php scripts. I really need help with starting MySql. I have scoured various forums and followed instructions from the mysql.com, and other such tutorials.

I am creating the website using dreamweaver on a windows 2000 pc but I am planning to place it on the linux box where the apache web server will handle it (if you know what I mean). The linux server is where the php and Mysql are installed. Incidentally the php installation is located in the /etc directory - and it works.

I downloaded the Mysql binary file version 4.0.25 recently. Followed the installation instructions to the letter up to the change of ownership stuff. Code:

View Replies !

Cannot Connect To MySQL Via Root@localhost
I installed Apache2.0 and PHP5.0.5 and then MySQL 4.1. I used the MySQL Instance Wizard setup, chose port 3306 and then at the end of the setup it always said @Cannot apply security, Connection Error, Access denied to root@localhost, Please check if there is anyway firewall or so...@

I don't have any firewalls and I have tried all the other port numbers but still the same message. And because of this error I cann't connect to the mySQL database.

View Replies !

MAC OS X : 'mysql -u Root' : Command Not Found!
i know nothing about DB's but i want to learn.; after a few attempts i finally got mysql to run (' starting mysql dtabase server') and the next step i am told is to make a pswd. well, i typed 'mysql -u root' to connect to the server like the manual says to do and all i get is 'command not found'.

View Replies !

Installing Mysql As User, NOT Root
I've had to install mysql as a regular user, and not as root. Before it was so simple since I was root but now I am on someone else's server.

I downloaded a non-RPM Standard5.0.19 binary. I untarred it and blindy tried to start it and of course got a number of errors. I found that mysql 4.1.12 was already running.

I took a look at http://lists.mysql.org/mysql/42514 and decided to make some changes:

- uid
- TCP port
- socket file
- basedir
- datadir

In mysql.server (in support-files) I changed the basedir and datadir to (/apps/myaccount is my home acct) /apps/myaccount/base and /apps/myaccount/data, but as the above listed post mentioned, I also need to change 3 other things. I need to put everything into my home account, so how should I change the uid, the tcp port, and the socket file?

View Replies !

Even Root Cannot Connect To Database 'mysql'
The version of my mysql server is 3.23.58. Before hand, everything works fine. However, when I connect to the data server sit in host 'A' from host 'B' by jdbc. As mysql's user table denied the access from host 'B', I know when attribute 'host' in table 'user' is set to '%' will fix the problem, However, I set it graphically from phpmyadmin.

After setting, the direct result is I cannot connect to any databases in this server@A even from A the error msg is: ERROR 1044: Access denied for user: '@localhost' to database 'mysql'. By googling, I copied the 'user.frm', 'user.MYD', 'user.MYI' from another host to the corresponding path in host A and restart mysqld.

It doesn't work. Then, I tried 'mysql_install_db', gone in vain either. It cost me nearly 2 whole days . I have many important databases stored in this server, I am afraind the install of a new one will bring more problems. Any suggestions, or ideas?

View Replies !

Change MySQL Root Password
My current user/pswd for my localhost is root/"" (no password). I'm following the directions in the mysql command line window (im on windows and installed mysql via wamp) and can't get to change the darn thing.

View Replies !

NTFS Securities For MySQL Root
I have is, what is the tightest security I can setup for the MySQL directory? Is there much risk in leaving it open with the default "Everyone" having full control? I am not sure I understand why this is the default, but anyway...

I am running
Windows 2000 Adavanced Server SP4 (NTFS)
IIS 5.0

My application for MySQL is currently just forums (PHPBB2). It uses the MySQL database to store all data. In the future, I want to create dynamic webforms using PHP, and interface to the MySQL database from a webpage. How do I need to setup NTFS to have the tighest security possible on the web, while allowing me to preform these functions? Which directories in the MySQL root need read/write/modify access?

My current feeling is to remove "Everyone" from the MySQL root on down. Then add administrators with full control, and IUSR_server_name with read/write access. Do I need execute? Is write access even neccisarry? Am I correct in understanding that everything within IIS uses the IUSR_server_name account to access these resources?

View Replies !

Setting Mysql Root Password On Mac
Am having problems setting the root password for the mysql server on my computer. I'm using Mac OS X with apache, php 5 and mysql 4.1 installed. I've tried using the terminal utility but I've had an error message reading:

View Replies !

Setting Root Password For MySQL
I'm Using the "Build Your Own Database Driven Website Using PHP and MYSQL" by Kevin Yank. On pg. 22 where the arguments new password are in parentheses, I typed in new password instead of my own new password ( I know that was dumb!). Anyway, when I quit the Mysql and start over I get the error: cannot login to local host password not excepted. How do I restart so that I can create a root password for Mysql?

View Replies !

Mysql Root Password Problem
i m new to learning mysql and php.i m following Kevin yank's build your database driven website and i am following well but i m stuck on one problem that is when i star mysql or connect it and give him my login and password of root.it give me error which says
MySQL

View Replies !

Setting MySql Root Password
I feel a bit daft as I can't seem to get passed p21 of Database Driven Website by Kevin Yank. But I'm learning

Ive got the latest copy and and want to follow it through to see what i can learn (lots I'm sure)

Im on a mac osx and am trying to set the root password. He says to do this using terminal in the bin directory of my MySql installation.

Where is it? i know basics about getting round terminal i.e changing directories and stuff.

View Replies !

Mysql -s -u Root Bmd &lt; Db.dump2 Slow

Mysql -s -u Root Bmd < Db.dump2 Slow