HI, i am trying to import database in to my new host. And this is what i am getting: SQL query: -- -- Database: `mydatabasename` -- CREATE DATABASE `mydatabasename` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; MySQL said: #1044 - Access denied for user 'webmaste'@'localhost' to database 'mydatabasename' I went throw this guide, step by step! http://www.webdesignerwall.com/tutorials/exporting-and-importing-wordpress/ Only didn't do 2. Find & Replace All Local URLs, coz simply there are no http://localhost:8888 in it. Any ideas? The google is full with this particular error but there isn't any good fix for it. :/ , and why would i be getting such a error? I am trying to move data from godaddy to my new server host i am renting. If this makes any difference. Cheers V.
Sounds like you didnt create a MySQL user or did not add that user to the database. Check out this tutorial.
I noticed before when i was trying to import database, my new DB user i made on the new host didnt have a ALL PRIVILAGES ticked, so i was hoping that was an error, but just tried again, no changes still getting the same error. Id there anything else i could of forgot or missed? And no the webmaste is my CP log in , the new DP user i created is different. Hmm a bit confusing, but i know there must be a solution for this error. Any more help would be highly appreciated. Thanks V.
Right, i think i know what my problem is but cant figure out how solve it. In my opinion i simply cannot log in in myphpadmin with the new DB user i created. Coz when i press from that Database menu MyphpAdmin icon, it automatically transfers me to the DB acces area, where i can pick my new dtabase i created and import the database from my desktop, BUT the error i am getting says webmaste access DENIED, and webmaste is my ,mydomein.com/cp los in ! So this would mean that i am simply not logged in as the new user i created with all PRIVILEGES ADDED. I also tried to log out from http://mydomein.com:2082/3rdparty/phpMyAdmin/index.php , so i can try and log in with the new db user i created but, it won't let me. So i got couple questions: How can i log in with the new user i just created directly to the database? And How can i make sure or add all DB PRIVILEGES to my main webmaste log in acc? if i could give an acces to this my main acc, i should be able to import DB how i tried before, without getting the message '' webmaste acces to mydatabseiamtryingtoimport DENIED'' Cheers V.
Hello, Have you checked whats the MYSQL version on your old host and new host..at times thats the one which causes such issue.
First you need to log into the database using PhpMyAdmin at your new server. Remove the sql query you listed in your first post because it is related to creating a new database where as you are already logged into the new database. Now proceed with import. If you are not able to import the data and need further help, PM me.
I should be able to import the new database, if i figure out how can i log in with the user i need to phpmyadmin, but i am just way too confused atm, will talk to one of my mates 2morrow and see if that helps. Thanks for Help Though! I doubt this would be the problem, since i simply cant log in with the user i need to db to try import then!