CODEWITHSUNDEEP
mysql
user984211
user984211

Reputation: 37

Can't Connect to LocalHost Mysql Server

I recently installed mysql server and client, but I can't connect to the server. I get this message:

Access denied for user 'root'@'localhost' (using password: YES/NO)

Whatever I do i will always get the same message.

I tried commenting bind-address but still the same thing.

Upvotes: 2

Views: 689

Answers (1)

Rob Williams
Rob Williams

Reputation: 1470

If you set up a password for the root user during installation, then start the mysql client with the -p option, mysql -u root -p, and it should prompt you for a password.

If there's no password set, leave the -p off and it should log right in.

If you've somehow forgotten what the root password is, you can fix it by following these instructions... http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Upvotes: 3

Related Questions