MySQL said: Access denied for user 'root'@'localhost' (using password: NO)"

1
votes

I am trying to create a database with Sequel Pro and it keeps coming up with an error "Unable to connect to host because access was denied.

Double-check your username and password and ensure that access from your current location is permitted.

MySQL said: Access denied for user 'root'@'localhost' (using password: NO)"

I have mySQL server running on my Mac. Not sure what I am doing wrong. Any help would be appreciated.

1
mysqlsequelpro
Are you logging in with a password in Sequel Pro? Looks like the password field is empty. If this is MAMP, use root as password also. - onik
Now MySQL Server won't start! - AltBrian
No I am not using MAMP. - AltBrian
You must have then set a root password during the MySQL server setup, use that when logging in. I'd need to know the install method to help any further. - onik
I have tried that and it says "MySQL said: Your password has expired. To log in you must change it using a client that supports expired passwords." - AltBrian

1 Answers

3
votes

Newer versions of MySQL use a temporary password after setup, and you can use mysqladmin to set it to something permanent.

mysqladmin -u root -p password