How to set user password in mysql

MySQL is a very commonly used open source database management system for storing and managing data. If you use MySQL, setting user passwords is also an important task when setting user permissions. Let's take a look at how to set user passwords in MySQL.

1. Login to MySQL

Before using MySQL, you need to log in to the MySQL server. You can use the following command:

mysql -u root -p

This command allows you to log in to MySQL using the root user. After entering this command, you will be prompted for the root user password. After entering the correct password, you will successfully log in to MySQL.

2. Create User

In MySQL, if you want to set a user password, you first need to create the user. You can use the following command to create a user named user:

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

In the above command, 'user'@'localhost' means creating the user user locally, and 'password' is the password of the user. You can also replace localhost with the specified hostname so you can create users on different machines.

3. Authorization

Once you create a user, you need to authorize the user so that the user can access the specified database. You can use the following command to authorize the user user:

GRANT ALL PRIVILEGES ON database_name.* TO 'user'@'localhost';

In the above command, 'database_name' represents the name of the database you want the user user to access. * represents all tables, you can also specify specific table names. This command will grant the user user all permissions on the specified database.

4. Refresh permissions

After authorization is completed, you need to refresh MySQL permissions to make it effective. You can use the following command to refresh permissions:

FLUSH PRIVILEGES;

This command will cause MySQL to refresh the local authorization status and refresh the latest authorization changes into memory.

5. Change password

If you want to change the user password, you can use the following command:

SET PASSWORD FOR 'user'@'localhost' = PASSWORD('new_password');

In the above command, 'new_password' is The new password you want to set.

Summary

When using MySQL, setting a user password is a very important task. You can follow the above steps to create users, authorize, refresh permissions and change passwords. With these simple steps, you can keep your data safe.

The above is the detailed content of How to set user password in mysql. For more information, please follow other related articles on the PHP Chinese website!