Can't Connect to LocalHost Mysql Server

Question

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.

I tried both terminal and GUI programs, in ubuntu. I mean no matter what i do, even if it to change the password i will always get the "access denied" — user984211
– user984211, Commented Oct 7, 2011 at 15:25

Rob Williams · Accepted Answer · 2011-10-07 15:25:29Z

3

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

answered Oct 7, 2011 at 15:25

Rob Williams

1,46812 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user984211 Over a year ago

I tried that many times, there is a password and i remember it, with or without -p it will give the error 1040, accessed denied..

Rob Williams Over a year ago

Scratch that, error 1040 is not a password error. It's a too-many-connections error: rackerhacker.com/2008/06/24/…

user984211 Over a year ago

Resetting the system password? No i haven't done that, i'll try now, though i can see why would that be a problem.

user984211 Over a year ago

Oh, sry i meant error 1045! "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) "

Collectives™ on Stack Overflow

Can't Connect to LocalHost Mysql Server

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related