mysql set password linux

MySQL is a popular open source relational database management system that can run on different operating systems, including Linux. In Linux systems, the installation and configuration of MySQL is relatively simple, but in order to protect the security of the database, it is recommended to set a password for MySQL.

In this article, we will introduce how to set a password for MySQL in Linux.

1. Installing MySQL

First, we need to install MySQL in Linux. You can execute the following command in the terminal to install:

sudo apt update
sudo apt install mysql-server

2. Start MySQL

After the installation is complete, you need to start the MySQL service. You can use the following command to start the MySQL service:

sudo systemctl start mysql

If you want MySQL to start automatically when the system starts, you can use the following command to enable the MySQL service:

sudo systemctl enable mysql

3. Set the root user password

By default, in MySQL, the root user has no password. In order to protect the security of the database, it is recommended to set a password for the root user.

You can use the following command to log in to MySQL:

mysql -u root

After successful login, you need to execute the following command to set the root user password:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';

Change your_password Replace with the password you want to set. After the setting is completed, use the following command to exit MySQL:

exit;

4. Test connection

In order to confirm that the password is set successfully, we can use the following command to log in to MySQL again:

mysql -u root -p

Enter the password you set after the prompt. If the login is successful, the password is set successfully.

5. Password settings for other users

In addition to the root user, you can set passwords for other users. In MySQL, the commands to add, modify and delete users are as follows:

Add a user: CREATE USER 'username'@'localhost' IDENTIFIED BY 'your_password';

Modify user password: ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password';

Delete user: DROP USER 'username'@'localhost';

Replace username and your_password with the username and password you want to set.

6. Summary

Setting a password for MySQL is a basic database security measure that is very simple in Linux. It only takes a few steps to complete, and once you're done setting it up, your database will be more secure.

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