Switching servers.. db name problem
So I switched or am trying to switch from yahoo servers to google and when I export and run the script I run into this problem"
SQL query:
--
-- Database: `mysql`
--
CREATE DATABASE `mysql` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said:
#1044 - Access denied for user 'ersio@'%' to database 'mysql'
How Do I get around this? I understnad it's because I don't have the db name "mysql" but is there a way to get it to that?
Re: Switching servers.. db name problem
First you create a database.
Then you create a database user.
Finally, you allow the database user access to the database.
All the above should be doable within your Hosting Control Panel. If not or you have problems then contacting your Hoster is the fastest and best way to resolve any problems.
Re: Switching servers.. db name problem
To my understanding, each db name had to be unique for google...
So when I did yahoo, I named the db mysql and it has all my setup files etc on them...
so i don't know how to transfer over correctly if the db name isnt the same
Re: Switching servers.. db name problem
Re: Switching servers.. db name problem
Now I'm getting this
You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration.
Re: Switching servers.. db name problem
On a side note, I'm swtiching from yahoo to godaddy servers
and well my db names are store and mysql and I can't have those on godaddy so I'm not sure if thats the problem?
Re: Switching servers.. db name problem
Quote:
Originally Posted by
ersio
On a side note, I'm swtiching from yahoo to godaddy servers
You're going from BAD (yahoo) to WORSE (godaddy).
GoDaddy is a completely inappropriate host for eCommerce...
Re: Switching servers.. db name problem
What would be a good hosting site? I'm just trying to get to a more stable server that is easy to navigate for me...
I left yahoo because you cant use .htaccess
I'm very uneducated in this... my business is making food lol
Re: Switching servers.. db name problem
Re: Switching servers.. db name problem
I'll get into that, but right now, I need to get my godaddy hosting up...
to much downtime