Access denied Errors in MySQL

[carl]

If you face any problem to connect MySQL server,you use folowing steps to correct the problem:

First please make sure that the server is running and if it is not running, you cannot connect to it.
For example, if you are trying to connect to the server and see a message such as one of those following, one cause might be that the server is not running:

shell> mysql
ERROR 2003: Can't connect to MySQL server on 'host_name' (111)
shell> mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)

[Christina]

The server is running, but you cannot connect because you might be trying to connect using a TCP/IP port, named pipe, or Unix socket file different from the one on which the server is listening. you can correct this problem by checking when you invoke a client program, specify a --port option to indicate the proper port number, or a --socket option to indicate the proper named pipe or Unix socket file. You can easily find out where the socket file is, by using this command:

shell> netstat -ln | grep mysql

[Mark Craig]

Here is what i am getting :(

C:\>mysql -uroot mysql
ERROR 1045: Access denied for user: 'root@127.0.0.1' (Using password: NO)

C:\mysql\bin>mysql -u root test
ERROR 1045: Access denied for user: 'root@127.0.0.1' (Using password: NO)

C:\mysql\bin>mysql -h localhost -u root test
ERROR 1045: Access denied for user: 'root@127.0.0.1' (Using password: NO)

[Rodricks]

Try by logging back in as root to the server and reissue the SQL statement again except with 'username@localhost'.

[Mark Craig]

That doesn't seem to work :(

[Sean]

Ok,

this is what i have searched, i am sure this will help :

You need to add the username with SQL as follows :

GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON winestores.* TO username@127.0.0.1 IDENTIFIED by 'password';

Rodricks is very near to a resolution though

[Ben.jones]

Access denied for user ''@'unknown' to database mysql

In this case, you will have to restart the server with the --skip-grant-tables option and edit your /etc/hosts file or \windows\hosts file to add an entry for your host.

[James]

iF you will get the following error, it means that you are using an wrong root password:

shell> mysqladmin -u root -pxxxx ver
Access denied for user 'root'@'localhost' (using password: YES)