How to Fix MySQL Error 1044: Access Denied for User?

Resolving Error 1044 on MySQL: Access Denied for User

In MySQL, you may encounter the error "ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'db'" while attempting to execute queries. This error indicates a lack of proper user privileges.

Identifying User Privileges

To check the current user's privileges, execute the command:

SHOW GRANTS

If you see the following output:

+--------------------------------------+
| Grants for @localhost                |
+--------------------------------------+
| GRANT USAGE ON *.* TO ''@'localhost' |
+--------------------------------------+

It means you have only USAGE privileges on all databases, but no table-level privileges or the ability to create users.

Creating a New User

To create a new user with the necessary privileges, you will need to be logged in as a user with the CREATE USER privilege. Since you do not have a user with such privileges, you need to exit the MySQL command-line and log in as the root user:

mysql -u root -p

Enter the root password when prompted.

Create a New User with Privileges

Once you are logged in as root, execute the following command to create a new user called 'parsa':

CREATE USER 'parsa'@'localhost' IDENTIFIED BY 'parsa'

Granting Table-Level Privileges

Next, grant the newly created user the necessary table-level privileges. For example, to grant all privileges on the 'test' database:

GRANT ALL PRIVILEGES ON test.* TO 'parsa'@'localhost'

Exiting MySQL and Re-establishing Connection

After creating the new user and granting privileges, exit MySQL by typing:

exit

Re-establish a connection with the newly created user:

mysql -u parsa -p

The above is the detailed content of How to Fix MySQL Error 1044: Access Denied for User?. For more information, please follow other related articles on the PHP Chinese website!