mysql error 1045

MySQL is a widely used open source relational database management system, but you may encounter 1045 errors during use. The main reason for this error is that the username or password used to connect to MySQL is invalid or wrong.

First, we need to check whether the MySQL service is running. If the MySQL service is not running, it cannot connect to the MySQL database, which will result in a 1045 error. We can check the status of the MySQL service with the following command:

sudo systemctl status mysql

If the service is not running, we can start the MySQL service with the following command:

sudo systemctl start mysql

Then we need to ensure that the user in the MySQL configuration file The name and password are correct. On Linux, the MySQL configuration file is usually called "my.cnf" or "mysql.cnf" and can be found in the "/etc/mysql/" folder.

Open the configuration file and look for the following line:

user=your_username
password=your_password

Make sure "your_username" and "your_password" match the correct username and password in the database. If you need to change the username and password, you can use the following command to change it:

mysql -u root -p

This will log in to the MySQL server using the root user. Next, we can use the following command to change the username and password:

ALTER USER 'username'@'localhost' IDENTIFIED BY 'new_password';

Please replace "username" with the username you want to change the password and "new_password" with the new password you want to set.

If you haven't created a MySQL user yet, you can create one using the following command:

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

This will create a user named "username" and set its password to "password".

Finally, if you frequently use the sudo command to run MySQL commands, this may result in a 1045 error. This is due to the sudo command changing the current logged in user to another user, which is root by default. The solution is to change the identity of the MySQL user using the following command:

mysql -u username -p

Please replace "username" with the username you use to connect to MySQL.

In short, the 1045 error is caused by an invalid MySQL username or password. We can check the status of the MySQL service, check the username and password in the configuration file, change the user's identity, and create or change the user. solve this problem.

The above is the detailed content of mysql error 1045. For more information, please follow other related articles on the PHP Chinese website!