Hi,
I'm trying to move an existing Wordpress site to Nethosted.
Nameservers: updated. (these are with fasthosts for cosic.org.uk)
Moving files: all but complete.
MySQL database: I'm doing something stupid.
I can download the old SQL database. I have wp-sql.zip
old db_name: cosicwp
old username: cosicwp
old pass: (I know this)
I create a new SQL database and user via nethosted cPanel:
new db_name: cosiclab_cosicwp
new user: cosiclab_cosicwp
new pass: (I know this)
I give the new user full privileges from cosiclab_cosicwp
I hit the phpmyadmin button in cPanel and attempt to import the old SQL database. I'm greeted with:
"Error
SQL query:
--
-- Database: `cosicwp`
--
CREATE DATABASE `cosicwp` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said: Documentation
#1044 - Access denied for user 'cosiclab'@'localhost' to database 'cosicwp'"
I don't recall this happening last time I moved a Wordpress to nethosted:
I seem to recall hitting import and that being that, aside from a wordpress configuration file issue.
I don't have an option to change the user logged in via phpmyadmin to "cosicwp" so assume cosiclab must be the equivalent of root for me, yet it can't write to this database.
Where am I going wrong please?