Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

I'm pulling my hair out trying to decipher why every time I do a fresh install of mysql on OSX and import a database, the minute I restart the mysql instance I'm prompted with the message: Access denied for user 'root'@'localhost' (using password: YES). I've kept the password to defaulted root, and this is quit frustrating. I've tried my hardest to ensure no other instances of mysql are running. The Activity monitor reports no other instances of mysql, and when searching for pids no other instances appear. Does anyone know what is happening?

share|improve this question
Try mysql_upgrade command? dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html – J Moore Jul 27 at 2:42
This doesn't help at all. Upgraded after reinstalling mysql one more time (mind you I'm following these instructions for reinstall: link) and then importing the db, I was immediately kicked out of my connection again. I can't log in as ANY of the users I created. – TheGamingArt Jul 27 at 17:30

2 Answers

up vote 1 down vote accepted

This error can occur when you import SQL tables that contain the MySQL database itself, this database contains the underlying schema that MySQL itself uses, this can cause serious issues when attempting to get into the database. Make sure that your imported SQL dump only includes the database you wish to import and nothing more.

share|improve this answer
I'm not an SQL guru unfortunately, would you mind giving me a little insight on how I should approach this? – TheGamingArt Jul 27 at 17:31
I believe I am just importing 3 databases out of an SQL dump. I didn't realize this would cause conflict. I'm not sure how to specify a specific database out of the dump (event though I believe I want all three). I don't specify a db when attempting to connect to mysql. Currently, I'm using Sequel Pro to import the databases view the import option. – TheGamingArt Jul 27 at 19:37
Make sure that your SQL dump itself does not contain any other databases besides the ones you want, restoring that SQL dump to a specific database will 'install' it to all of them. – Matthew Salsamendi Jul 27 at 20:55
This isn't 'my' sql dump. This is one provided by the client. I want to avoid asking for a corrected dump at all costs. Is there a way I can specify the databases to import from the dump? I'm not 'restoring' per say, I'm importing. I've done this by either terminal appending via "<" and I've done this via the import option within Sequel Pro. – TheGamingArt Jul 27 at 22:51
Right now I'm going to try executing the commands here: link to see if this works. – TheGamingArt Jul 28 at 0:26
show 5 more comments
up vote 0 down vote

This error could occur in the following cases 1. Using an incorrect password. Since you mentioned that you have defaulted the password to root check if you have the CAPS lock on 2. It could occur if you have an incorrect password specified in an option file. Try logging in using mysqladmin --no-defaults -u root -p pass 3. You might have to grant access to root. Stop MySQL - /etc/init.d/mysql stop Start MYSQL skippping grants - /usr/sbin/mysqld --skip-grant-tables --skip-networking & Login - mysql -u root Flush privileges - FLUSH PRIVILEGES; Update Password - SET PASSWORD FOR root@'localhost' = PASSWORD('password'); UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';

share|improve this answer
In essence, I've already done these steps before.... only a few times did they kind of work but the issue still lies that EVERY time I import this db I will be kicked out of ALL of my accounts. So I don't believe this is the solution for my problem since it only 'sometimes' works and I have 0 access to any of my accounts what-so-ever. – TheGamingArt Jul 27 at 17:33

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.