No Privileges to create databases in mysql.

i'm having trouble restoring one of my databases:

Error at the line 12: CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Query: CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL: Access denied for user 'forums4f_solid'@'localhost' to database 'information_schema'


after checking phpmyadmin, it says that i have no priveleges to create a new database(screenshot)

And looking at the sql dump file on line 12, it's trying to create a database .. something which i dont have permission to do.

how would i configure mysql so that it has permission to create databases?

 

 

 

 

Top