54738

Your privilege table structure seems to be older than this MySQL version!
Please run the mysql_upgrade command(mysql_fix_privilege_tables on older systems) that should be included in your MySQL server distribution to solve this problem!


昨天弄了个程序,先采集了一部分,然后睡觉前挂机采集一夜

早上起来发现挂机采集的内容入库的栏目错了

就把昨天备份的数据库直接覆盖MYSQL/DATA目录里面了

然后发现后台出错

进phpmyadmin,然后点“用户”,就出现这个错误

按照提示运行 mysql_upgrade 也出现错误:

D:\Mysql\bin>mysql_upgrade
mysql_upgrade: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using
password: NO) while connecting to the MySQL server
Upgrade process encountered error and will not continue.

百度谷歌了半天没找到解决办法。大佬们,help~