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.
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
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
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;
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.
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.
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!