These forums are now archived.


Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
PostPosted: Sun May 10, 2015 11:54 pm 
Offline
NetHosted Customer

Joined: Thu Feb 23, 2012 4:17 pm
Posts: 9
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? :blink:


Top
 Profile  
Reply with quote  
PostPosted: Sun May 10, 2015 11:55 pm 
Offline
NetHosted Staff
User avatar

Joined: Mon Jan 06, 2014 10:56 am
Posts: 168
Hi,

Could you please open up a support ticket with your account information and upload the .sql file to the server and I'll be happy to take a look for you.

Regards,

Jack

_________________
| Jack Waplington
| Sales & Support Technician, NetHosted Ltd.
| Earn £30 every time you refer someone to us!
| Follow us on Twitter:
| Members, tell us what of NetHosted!


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 43 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: