I'm trying to migrate a WordPress site I've designed on a local server (MAMP), to my cPanel on a remote server. I've followed the instructions I was given to the note, but when I tried to import the SQL file to my remote server using MyPHPAdmin, it came up with an error saying:
CREATE DATABASE 'information schema' DEFAULT CHARACTER SET utf8 COLLATE utf_general_ci;
My SQL said:
#1044 - Access denied for user 'x' @ 'localhost' to database 'information_schema'
If this makes sense to anyone, please help!
Thanks in advance,