I'm trying to move my database to a new server by using Backup and Restore from MySQL Administrator. When I start the Restore I get this:
Error while executing this query:CREATE DATABASE /*!32312 IF NOT EXISTS*/ information_schema;
The server has returned this error message:Access denied for user 'root'@'localhost' to database 'information_schema'
I've tried from other utilities as well. I can make the Restore run by checking Ignore Errors, but I'm afraid it's incomplete.