MYSQL Problems #1130 Cannot log in to the MySQL server

[Ben]

Howdy Folks,

So basically I'm having problems with MYSQL connection. I use WAMP Server as my source for everything but when I look on youtube videos they seem the be able to connect to there localhost fine and instantly have access and change there password within phpmyadmin. sadly I cant even get there. so if you have any ideas why please reply ASAP.

Error Message: #1130 Cannot log in to the MySQL server

Thanks.
Ben

[Spray]

This error means that the host you're attempting to use is not allowed to connect to the MySQL server. If you're attempting to use localhost and getting denied, you may need to create the user in the first place.

Try running the following command via a cmd prompt window:

mysqladmin -u root password 'my_new_password_here'

If that doesn't work, try using 127.0.0.1 to connect, rather than "localhost".

[Ben]

Tried both methods still no access:

CMD attempt:

mysqladmin: connect to server at 'localhost' failed
Error: 'Host 'localhost' is not allowed to connect to this MYSQL server'

127.0.0.1 didn't do anything what localhost has done.

[Spray]

Did attempting to use 127.0.0.1 result in the same type of error?

[Ben]

Yes exactly the same Error

#1130 Cannot log in to the MySQL server

[Spray]

In order to correct this, you would need to launch mysqld with the -skip-grant-tables to bypass privilege checks, then update the users table manually. If this is a new installation, though, I'd strongly consider just re-installing. MySQL should be allowing root @ localhost by default.

[Ben]

How would I launch mysqld with the skip grant powers?

Thanks.

[Spray]

Via the cmd prompt, you would run:

mysqld --skip-grant-tables --skip-networking

The "--skip-networking" is added to ensure remote connections aren't allowed, as the server will be insecure without grant tables.