方法一:(有时失败)
MariaDB [(none)]> USE mysql; MariaDB [(mysql)]> UPDATE user SET password=PASSWORD('YourPasswordHere') WHERE User='root' AND Host = 'localhost'; MariaDB [(mysql)]> FLUSH PRIVILEGES;
解决mariadb 修改密码失败:ERROR 1348 (HY000): Column 'Password' is not updatable
方法二(推荐):
MariaDB [(none)]> USE mysql; MariaDB [(mysql)]> set password for 'root'@'localhost'=password('123456'); MariaDB [(mysql)]>flush privileges;
最新评论 0