Home > Database > Mysql Tutorial > body text

mysql set password linux

WBOY
Release: 2023-05-23 14:09:09
Original
2138 people have browsed it

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
Copy after login
  1. 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
Copy after login

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
Copy after login
  1. 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
Copy after login

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';
Copy after login

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

exit;
Copy after login
  1. 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
Copy after login

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

  1. 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.

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

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template