mysql5.5忘记root密码_忘记Mysql的root用户密码处理方法(以mysql 5.5.33为例)

1.修改mysql服务器的脚本

~]#vi /etc/rc.d/init.d/mysqld

#找到$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/d

ev/null 2>&1 & wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?此行后，添加--skip-grant --skip-networking

修改后的如下所示

$bindir/mysqld_safe --datadir="$datadir" --skip-grant --skip-networking --pid-file="$mysqld_pid_file_path" $other_args >/d

ev/null 2>&1 &

wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?

2.将mysql服务重新启动

~]#service mysqld restart

3.更新或修改mysql的root用户密码

~]#mysql>USER mysql

~]#mysql>UPDATE user SET password=PASSWORD('mypasshao') WHERE user='root';

4.重新把mysql服务器的启动服务脚本删除--skip-grant和--skip-networking

~]#vi /etc/rc.d/init.d/mysqld

#找到如下此段

$bindir/mysqld_safe --datadir="$datadir" --skip-grant --skip-networking --pid-file="$mysqld_pid_file_path" $other_args >/d

ev/null 2>&1 &

wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?

#把--skip-grant和--skip-networking删除

5.再次重启mysql服务

~]#service mysqld restart