云計算服務(wù)
服務(wù)器租用
DDOS 防護
虛擬主機
域名服務(wù)
基礎(chǔ)設(shè)施
關(guān)于我們
香港服務(wù)器MySQL修改密碼報錯：ERROR 1290 (HY000) The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
修改MySQL數(shù)據(jù)庫密碼報1290 錯誤 如下：
alter user ‘root’@‘localhost’ identified by ‘root’;
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
需要刷新下配置
flush privileges;
Query OK, 0 rows affected (0.00 sec)
然后就可以修改密碼了
set password for root@localhost=password('root');
Query OK, 0 rows affected, 1 warning (0.00 sec)
修改密碼后重啟mysql
systemctl restart mysqld
.png)
.png)
