How to deal with password without prompt after mysql5.7 startup
This article mainly introduces how to deal with passwords without hints after mysql5.7 startup, the contents of the articles are carefully selected and edited by the author, with a certain pertinence, and is of great significance to everyone's reference, the following is to understand with the author how to deal with passwords without hints after mysql5.7 startup.
[root@localhost mysql] # / usr/bin/mysql_secure_installation
Securing the MySQL server deployment.
Enter password for user root:
When mysql initializes, let you enter the password, but when you install it, there is no password prompt. You have to find it yourself.
[root@localhost mysql] # grep-ri temporary *
Binary file data/ibdata1 matches
Binary file data/ib_logfile0 matches
Binary file data/mysql/help_topic.ibd matches
Binary file data/mysql/help_keyword.ibd matches
Binary file data/mysql/proc.MYD matches
Error/mysql-error.log:2017-12-09T17:12:20.686911Z 1 [Note] A temporary password is generated for root@localhost: 2hW&3542fUvx
The filter data file is already in the log file.
After reading the above about how to deal with passwords after mysql5.7 startup, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to pay attention to our industry information column.