Linux中修改MySQL ROOT密码方法
时间:2022-03-14 03:28
使用mysqladmin
# ./mysqladmin -u root password ‘newpassword‘ # ./mysqladmin -u root -h host_name password ‘newpassword‘Usually mysqladmin‘s path is /usr/bin, host_name is your real host name, e.g. localhost.localdomain. password后面的引号不是必须的,不过如果密码包含空格或者一些特殊的符号,需要用引号。
利用mysql SET PASSWORD命令
# ./mysql -u root mysql> SET PASSWORD FOR ‘root‘@‘localhost‘ = PASSWORD(‘newpassword‘); mysql> SET PASSWORD FOR ‘root‘@‘host_name‘ = PASSWORD(‘newpassword‘);使用UPDATE语句更新user表重置ROOT密码
# ./mysql -u root mysql> UPDATE mysql.user SET Password = PASSWORD(‘newpassword‘) WHERE User = ‘root‘; mysql> FLUSH PRIVILEGES;