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

How to change the password of mysql, in view of this problem, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

The default password of mysql is empty, and the password can be reset. The setting method is: 1. Log in to the database with root username and password; 2. Use "UPDATE user SET password=PASSWORD (" password ") WHERE..." Statement to change the password.

The operating environment of this paper: Windows7 system, mysql5.5, Dell G3.

What is the password for mysql?

There are no sa users in mysql, there are root users, and sa users are unique to sqlserver. The password for root is blank by default, but can be reset after installation. The settings are as follows:

1. If the user name and password are not set during the installation process, you can log in to the database with the root user name and password.

2. User name: root password is empty.

3. If the login is successful, the following information will be displayed.

4. After entering, you can execute select * from mysql.user; to query the user information of mysql, and you can see that the password is encrypted.

5. Type "mysqld_safe-- skip-grant-tablesmysql-u root mysql" under the console, and click withdraw.

6. After that, enter "UPDATE user SET password=PASSWORD (" password ") WHERE user='root';" (password is the new password, you can change it to any password you want).

This is the answer to the question about how to change the password of mysql. I hope the above content can be of some help to you. If you still have a lot of doubts to solve, you can follow the industry information channel to learn more about it.

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.