Get the App
SLTechnology News&Howtos  ›  Database  › 

How to deal with password without prompt after mysql5.7 startup

Shulou Source: shulou.com Published: 2022-06-01 18:59:30 11月17日 Update

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.

Tags: Password hint processing file time author industry information content meaning data article log more friends column knowledge reader information or Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker MariaDB Microsoft Apple MySQL