MySQL issues
I am receiving this error when all my clients try to access their database via their web site.
Warning: mysql_connect() [function.mysql-connect]: Access denied for user: '[email protected]' (Using password: YES) in /home/hsphere/local/home/billyb00/natick.com/forums/sources/Drivers/mySQL.php on line 64
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/hsphere/local/home/billyb00/natick.com/forums/sources/Drivers/mySQL.php on line 67
ERROR: Cannot find database towntalk
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/hsphere/local/home/billyb00/natick.com/forums/sources/Drivers/mySQL.php on line 100
I moved these users site to my own server a month ago and they all worked. Now I am receiving these messages on all my customer's MySQL databases. Some OScommerce databases do not come up very well either.
The only thing I did recently was change my H-sphere control panel to use my domain name instead of the IP to access my control panel and add an SSL cert.
I don't thing the SLL cert did anything, but I'm not sure. I have a feeling that it may be the fact I changed from IP to name access for the control panel.
Anyone familiar with what the cause of this error is and how I can correct it?
I would appreciate it.
Thanks
Rob
Mark Hensler posted this at 08:01 — 16th July 2003.
He has: 4,048 posts
Joined: Aug 2000
Being a permission error, I would check your mysql users. If you went from IPs to domain names, you may have to change the 'host' value for all your users.
Mark Hensler
If there is no answer on Google, then there is no question.
usher posted this at 08:24 — 16th July 2003.
They have: 2 posts
Joined: Jul 2003
I'm new to MySQL, Where would I check this value?
Mark Hensler posted this at 03:25 — 17th July 2003.
He has: 4,048 posts
Joined: Aug 2000
Well, for the mysql authentication, there is a table called 'user'. Check the values for the 'Host' field.
If you have phpMyAdmin, there is a decent user management thingy for root users.
Mark Hensler
If there is no answer on Google, then there is no question.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.