Unable to import old database after reinstall (permission issue with information_schema)
I have recently re-installed my dev. computer.
So what I did was make an export in phpmyadmin into an .sql file and backedup all the site files. Something that normally should be enough?
Now my problem is that It will only partially import untill it runs into the information_schema database...
For some reason I can't get acces to it...
Is there a way I can get this import to work again?
The error I get:
CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
#104开发者_StackOverflow4 - Access denied for user 'root'@'localhost' to database 'information_schema'
I hope one of you guys can help me.
Grtz, Thomas
AFAIK information_schema
is a MySQL system DB, I guess that MySQL will only allow you to modify its contents, not its structure.
Then you should only try to import data into it, not issue a CREATE DATABASE information_schema
command.
BTW, is this DB information_schema
already existing on your system ?
Please open this link then you can get a solution:
- Click on MySQL® Database Wizard
- Create new DATABASE
- Create NEW USER AND PASSWORD
- Give ALL PRIVILEGES to current user
- Success END.
NOW CLICK ON phpMyAdmin then find your DATABASE.
Refer:how-to-quick-install-and-start-your-website-right-away-with-wordpress
精彩评论