开发者

Import sql database, denies me access to mine?

开发者 https://www.devze.com 2023-03-13 07:42 出处:网络
I am trying to import an sql dump into wamp->mysql. It imports fine but when I try to see the tables it shows an empty set. Upon doing this I lose access to mysql and cannot login. It is strange becau

I am trying to import an sql dump into wamp->mysql. It imports fine but when I try to see the tables it shows an empty set. Upon doing this I lose access to mysql and cannot login. It is strange because I am able to import another database of the exact same model from a different server fine. I check the mysql log and I get this:

110616 14:27:24 [Note] Plugin 'FEDERATED' is disabled.
110616 14:27:24  InnoDB: Started; log sequence number 0 3049592450
110616 14:27:25 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. The   table is 开发者_开发技巧probably corrupted
110616 14:27:25 [ERROR] mysql.user has no `Event_priv` column at position 29
110616 14:27:25 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

If anyone can give me details on what is happening and a way to restore my access without having to reinstall wamp that would be great.


Well, I am truly an idiot. The other database "root" has a password and it overwrites mine. All I needed to do was create a general admin user with all rights access. It also creates a new database with a new name where it inputs all the data instead of using the one I had chosen for it.

0

精彩评论

暂无评论...
验证码 换一张
取 消