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

Editor to share with you what the initial password in the mysql database is, 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 mysql initial password is empty, and the method to modify the initial password is as follows: 1, log in to the mysql account with the empty initial password; 2, modify the root password through "SETPASSWORD = PASSWORD ('123456');" and other statements.

This article operating environment: Windows7 system, Mysql5.7.14 version, Dell G3 computer.

The mysql initial password is empty.

There are three ways for MySQL to modify the initial password:

Method 1:

1. Log in to the mysql account with an empty initial password:

Mysql-uroot-p

2. Modify the root password:

SETPASSWORD = PASSWORD ('123456')

Method 2:

1. Log in to the mysql account with an empty initial password:

Mysql-uroot-p

2. Modify the root password:

Mysqladmin-u root password '123456'

Method 3:

1. Log in to the mysql account with an empty initial password:

Mysql-uroot-p

2. Modify the root password:

Mysql > update user set Password=password ("123456") where User='root';Query OK, 4 rows affected (0.01sec) Rows matched: 4 Changed: 4 Warnings: 0 mysql > flush privileges;Query OK, 0 rows affected (0.04 sec) mysql > select Host,User,password from user where user='root' +-- +-+-- + | Host | User | password | +- -+-+-- + | localhost | root | * 5626ED34B75C6C508BA2A3D0A4F6E4C58823138C | | localhost.localdomain | root | * 5626ED34B75C6C508BA2A3D0A4F6E4C58823138C | | 127.0.0.1 | root | * 5626ED34B75C6C508BA2A3D0A4F6E4C58823138C | |:: 1 | root | * 5626ED34B75C6C508BA2A3D0A4F6E4C58823138C | + -+-+-- + 4 rows in set (0.00 sec) and above are all the contents of the article "what is the initial password in the mysql database" 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.