Shulou(Shulou.com)06/01 Report--

Editor to share with you how to check the initial password in mysql, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The initial password for mysql can be viewed in the log. The specific method is to log in to mysql; first and then execute the [grep 'temporary password' / var/log/mysqld.log] statement.

How to view the initial password:

Start mysql

Systemctl start mysqld

View mysql status

Systemctl status mysqld

Log into the database

Mysql-u root-p

When mysql is started, the initial password is written to the log

View it with the following command

Grep 'temporary password' / var/log/mysqld.log

These are all the contents of how to view the initial password in mysql. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.