Navicat cannot proceed because system tables
蓝鹰 | MYSQL | 2013-05-20
Navicat的官方网站上找到了一段信息:
Please try to update your system table and to see if it solves your problem. mysql_upgrade is stored in the “bin” folder under the MySQL server installation path.
解决方法:
mysql_upgrade -u root -p123
重启服务.
[阅读全文]
Navicat Please use mysql_upgrade to fix this error
蓝鹰 | MYSQL | 2013-05-20
MySQL执行脚本发生如下错误时:
ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50045, now running 50514. Please use mysql_upgrade to fix this error.
Database changed
ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50045, now r... [阅读全文]
WIN2003 MySQL数据库-忘记Mysql的root密码的处理办法
蓝鹰 | MYSQL | 2013-03-22
Windows:
1.用系统管理员登陆操作系统。
2.在管理工具,服务管理中,找到Mysql服务,停止MySQL的服务。
3.在开始–运行中输入cmd确定,就可以进入DOS窗口,然后进入MySQL的安装目录,比如我的安装目录是 E:\Program Files\MySQL\MySQL Server 5.0\bin
输入 e:回车,
输入cd “E:\Program Files\MySQL\MySQL Server 5.0\bin”
注意双引号也要... [阅读全文]