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

Question

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.

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

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, Feb 15 '18 at 18:25
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, Feb 15 '18 at 18:33
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, Feb 15 '18 at 18:40
Manage to reset it using this link https://stackoverflow.com/questions/33387879/mysql-password-expired-cant-connect . — AltBrian, Feb 15 '18 at 18:46

score 3 · Accepted Answer · answered Feb 15 '18 at 18:46

3

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

answered Feb 15 '18 at 18:46

onik

Thanks, this helped me discover that a randomly generated password I had set for MySQL with MAMP Pro had a character that wasn't getting escaped. While MySQL might have no password character restrictions, not all passwords can be typed right into Terminal. See also https://superuser.com/questions/1002803/mysql-password-restrictions – Sean Fahey Feb 07 '20 at 19:50

1 Answers1