首先停止MySQL进程
[root@localhost ~]# /etc/init.d/mysqld stop
Shutting down MySQL. [确定]
使用--skip-grant-tables
参数启动MySQL,忽略授权登陆验证,如下
[root@localhost ~]# /usr/local/mysql/bin/mysqld_safe --skip-grant-tables --user=mysql &
[root@localhost ~]# mysql #这里直接使用mysql登录,然后再使用上面的方法修改用户密码
[root@localhost ~]# /usr/local/mysql/bin/mysqladmin shutdown -uroot -p # 使用mysqladmin关闭mysqld进程
Enter password:
[root@localhost ~]# service mysqld start # 再次重新登录
killall mysqld
或者
/user/local/mysql/bin/mysqladmin -uroot -p shutdown -S /usr/local/mysql/data/3306/mysql.sock
/usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/data/3306/my.cnf --skip-grant-table &
mysql -S /usr/local/mysql/data/3306/mysql.sock # 无密码登录MySQL
mysql> update mysql.user set password=password('aaaaaa') where user='root' and host="localhost";
mysql> flush privileges;
[root@localhost ~]# mysqladmin shutdown -S /usr/local/mysql/data/3306/mysql.sock -uroot -p
[root@localhost ~]# /usr/local/mysql/data/3306/mysqld start
Starting MySQL...
mysql -S /data/3306/mysql.sock -uroot -p
内容来源于网络,如有侵权,请联系作者删除!