I've been trying to transfer my website from a Godaddy.com "basic" hosting account to a Godaddy.com "deluxe" hosting account and I haven't been able to import the database from one account to the other. I keep on getting the error: MySQL said: Documentation #1044 - Access denied for user 'uwqa42qd'@'%' to database 'information_schema' First of all I never setup the database "information_schema" which is what baffles me. I tried contacting Godaddy.com and they send me a lame response with basic instructions on importing the database which I already know how to do. Both hosting accounts are from the same company and are on Linux Apache servers. What do you think is the problem here?
You shouldn't need to import it. It should still be there and working since GD hosts all the DBs on seperate servers. All you need to do is point your script to the server.
If you think about the error that your receiving - Access Denied for user, obviously something wrong with the config/login details.
That does and doesn't make sense. I'm trying to switch my website over from a basic account to a deluxe account so I can host all of my websites under the same account which is cheaper.
information_schema is a main internal mysql database that no one but the root user can edit, you shouldn't have to do anything with it. you wont be able to edit it anyways because it doesn't belong to you.
Nevermind, I figured it out. My old DB was MySQL 5.0 and I was trying to import the old DB to a new one that was version 4.1.