How to check mysql password

MySQL is a common relational database. Many developers or system administrators who need to use MySQL set a complex root password for MySQL during installation, but after a while they forget this password. In this case, we need to know how to view the MySQL password.

1. View the password through the my.cnf file

In MySQL, you can view the MySQL password through the my.cnf file. Before viewing, make sure the current user has permission to read the my.cnf file.

my.cnf file is generally in the /etc or /usr/local/mysql/ directory. You can use the following command to search:

$ locate my.cnf

After opening the file, search for the [mysqld] field, generally In this case, the MySQL password is stored in this section, as follows:

[mysqld]
datadir=/var/db/mysql
socket=/var/run/mysql/mysql.sock
user=mysql
max_connections=300
secure-file-priv=
innodb_file_per_table=1
default_password_lifetime=0
mysqlx-bind-address=127.0.0.1
mysqlx-socket=/var/run/mysqld/mysqlx.sock
skip-ssl
bind-address=0.0.0.0
#以下为MySQL密码处
#Password for root@localhost:
#禁用ONLY_FULL_GROUP_BY
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

As you can see, the password is generally marked with a comment (#Password for root@localhost:), and the password is given below the comment.

2. Check the password through the command line

Checking the password through the terminal command line is a relatively simple method. The following is how to view the MySQL password on the command line:

$ sudo cat /etc/mysql/debian.cnf

This command will print out the following:

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = pbkdf2_example_password
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = pbkdf2_example_password
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr

The password of the mysql user is usually stored in the /etc/mysql/debian.cnf file , as shown above. The password is stored under the [client] section with the key password.

3. View the password through the MySQL command line client

In some cases, the MySQL administrator needs to connect directly to the MySQL server in order to verify the current root before changing the password Is the password correct? You can use the following command to connect to the MySQL server and view the password:

$ sudo mysql -u root -p

After executing this command, the system will prompt the user to enter the password. After entering the correct root password, you can successfully connect to the MySQL server.

The above are three ways to obtain the MySQL password. You can choose the appropriate method according to your needs. Of course, in actual work, you should pay more attention to protecting the MySQL password to avoid security issues caused by password leakage.

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