我想从I9O*Kez
---> SO123*
我执行这些
mysql -u root -pI9O*Kez
service mysql stop
mysqld_safe --skip-grant-tables &
mysql -uroot
use mysql;
delete from user where User='root';
CREATE USER 'root'@'%' IDENTIFIED BY 'SO123*';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'%';
我不断得到
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
我做这些完全错了吗?
仅更新root密码就不那么困难-对吗?