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?