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

The following content mainly brings you a brief analysis of changing the password of mysql database, the knowledge mentioned here is slightly different from books, it is summed up by professional and technical personnel in the process of contact with users, and has a certain value of experience sharing, hoping to bring help to the majority of readers.

Mysql changes the database password:

Version 5.7 database will display the password in the installation log

Cat / var/log/mysqld.log | grep password

Prompt to change the password when logging in:

Mysql > show databases

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

A simple password cannot be set:

Mysql > alter user 'root'@'localhost' identified by' 123456'

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Mysql >

Change the database password settings, and simple passwords can also be used

Set global validate_password_policy=0

Set global validate_password_length=1

Set to a simple password:

Alter user 'root'@'localhost' identified by' 111111'

I forgot my password:

Modify the configuration file / etc/my.cnf to remove or disable the line skip-grant-tables.

Note: the old version of mysql database uses the parameter authentication_string, and the new version uses the parameter password.

Update user set authentication_string=password ('123456') where user='root'

Update user set password=password ('123456') where user='root'

Flush privileges;-refresh the system permissions table

It is wrong to log in to the Times with tools.

ERROR 1130: Host 192.168.3.100 is not allowed to connect to this MySQL server

Select Host,User from user where user='root'

Update user set host ='% 'where user =' root'

Flush privileges

Just log in again.

For the above brief analysis of changing the password of mysql database, if you have more information, you can continue to pay attention to the innovation of our industry. If you need professional answers, you can contact the pre-sales and after-sales on the official website. I hope this article can bring you some knowledge updates.

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.