打开配置文件添加如下内容:skip-grant-tables
vi /etc/my.cnf
skip-grant-tables
例如:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-grant-tables
登陆mysql修改密码:
mysql>use mysql;
mysql>update user set password=password("mysql") where user='root';
mysql>update user set authentication_string=password("mysql") where user='root';
mysql> flush privileges;
退出数据库重启即可。
No Leanote account ? Sign up now.