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

When we use MySQL, we often need to change the password of root users for different reasons. This blog mainly introduces several ways to change the password of root users. Before setting the root password: SET PASSWORD command: mysql-u rootmysql > SET PASSWORD FOR 'root'@'localhost' = PASSWORD (' password you want to set'); mysqladmin command: mysqladmin-u root password "password you want to set" UPDATE directly edit the user table: mysql-u rootmysql > USE mysql;mysql > UPDATE user SET Password = PASSWORD ('password you want to set') WHERE user = 'root';mysql > FLUSH PRIVILEGES' After setting root: mysqladmin method: mysqladmin-u root password oldpass "new password you want to set" set root password, but forget: mysqld_safe-- skip-grant-tables&mysql-u root mysqlmysql > UPDATE user SET password = PASSWORD ("new password you want to set") WHERE user = 'root'; mysql > FLUSH PRIVILEGES

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.