$ mysql.server start
$ mysql -uroot -p
按enter键进入
$ use mysql;
更改密码:
$ update user set password=password(‘root’) where user=’root’;
如果提示ERROR 1054 (42S22): Unknown column ‘password’ in ‘field list’ 则执行
$update user set authentication_string=password(‘root’) where user=’root’;
刷新权限:
$ flush privileges;
$quit
重启
$ mysql.server restart
输入新的密码
$ mysql -uroot -p
=====================
提示Unknown column ‘password’ in ‘field list’ 后, 执行:
$ desc user;
Field | Type |
---|---|
authentication_string | text |
password_expired | enum(‘N’,’Y’) |
password_last_changed | timestamp |