Uploading SQL db using PHPMyAdmin

[xtoor]

Hi all,

I am running a Joomla 1.5 website on a local webserver (using Wamp 2.1) and I'm trying to upload it onto my online database. I keep on getting the following error

#1044 - Access denied for user ' ######'@'%' to database '#########'

on PHPMyadmin when I try to upload my db to the webserver.

I've already added the Database Username, Database Password and set Host to Any on my database but it still gives the same error. Please help!!!

 

[Bloogle]

1. Your host should be localhost
2. the default user is root with no password

Enter the above and it should work

 

[SilverNodashi]

Hi all,

I am running a Joomla 1.5 website on a local webserver (using Wamp 2.1) and I'm trying to upload it onto my online database. I keep on getting the following error

#1044 - Access denied for user ' ######'@'%' to database '#########'

on PHPMyadmin when I try to upload my db to the webserver.

I've already added the Database Username, Database Password and set Host to Any on my database but it still gives the same error. Please help!!!

If your getting that error in phpMyAdmin, on your online webserver then you've got some incorrect permissions somewhere.

Is this your own (i.e. do you own, and have full root access) server or a shared server?
What control panel does the server run?

 

[xtoor]

Thanks for your responses. The issue has been sorted. I'm using Mweb's Uncapped hosting, I had to rename my local Joomla db, to be the same name as my remote db before importing it. Everything's sorted now.

Thanks again.