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