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

The following together to understand how to modify the MYSQL database root password, I believe that we will benefit a lot after reading, the text is not much in the essence, hope that how to modify the MYSQL database root password this short content is what you want.

The windows version first stops the MYSQL service and opens the cmd command window, then enter the cd / d installation directory mysqld-- skip-grant-table to open a cmd command window, and then enter the cd / d installation directory mysql-uroot-p and enter use mysqlupdate mysql.user set password=password ('enter the password you want to change') where user='root';flush privileges When quit restarts the MYSQL service, you can enter it with a new password. Linux version first stops the MYSQL service mysqld_safe-- skip-grant-table & / / starts mysql-uroot-p without checking permissions, and then press use mysqlupdate mysql.user set password=password ('enter the password you want to change') where user='root';flush privileges;quit to restart the MYSQL service with the new password.

After reading this article on how to change the root password in MYSQL database, many readers will want to know more about it. For more industry information, you can follow our industry information section.

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.