摘要:
1 /etc/init.d/mysql stop 2 3 4 vim /etc/my.cnf添加 skip-grant-tables 5 mysql -u root 6 use mysql; 7 update user set password=PASSWORD("mynewpassword") where User='root'; 8 update user set plugin="mysq... 阅读全文
ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 5
摘要:
错误是由于你曾经升级过数据库,升级完后没有使用 mysql_upgrade升级数据结构造成的。 解决办法: mysql_upgrade -uroot -pxxxx 阅读全文