Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to change the initial password of mysql 5.7. the editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

[root@qxy2 mysql] # service mysqld start

Redirecting to / bin/systemctl start mysqld.service

[root@qxy2 mysql] # grep 'temporary password' / var/log/mysqld.log

2016-05-04T13:46:01.727652Z 1 [Note] A temporary password is generated for root@localhost: _? Xwo >% do7S8

[root@qxy2 mysql] # mysql-u root-p

Enter password:

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 2

Server version: 5.7.12

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

Affiliates. Other names may be trademarks of their respective

Owners.

Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

Mysql > ALTER USER 'root'@'localhost' IDENTIFIED BY' Xy5686670@'

Query OK, 0 rows affected (0.00 sec)

Mysql >

This is the end of this article on "how to change the initial password in mysql 5.7". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.