mariovaldez.net
http://www.mariovaldez.net/webapps/forums/

But problems....
http://www.mariovaldez.net/webapps/forums/viewtopic.php?f=12&t=175
Page 1 of 1

Author:  Great [ 07 Jan 2005, 08:42 ]
Post subject:  But problems....

On the face of it, this looks like a fantastic product. Its just a pity that I cant test it!

I know that my host does not allow remote connections to my database, so following your documentation, I decided to try the SSH tunneling approach. I confirm that I am able to connect via SSH with no problems.

However, when trying to connect to the database, I get the following error message:

SQL error : Localhost.localdomain is not allowed to connect to this mysql server

Thanks for any help that you can provide

Author:  mvaldez [ 09 Jan 2005, 03:17 ]
Post subject:  localhost.localdomain...

Great:

> ...I decided to try the SSH tunneling approach.
> I confirm that I am able to connect via SSH with
> no problems. However, when trying to connect
> to the database, I get the following error message:
> SQL error : Localhost.localdomain is not allowed
> to connect to this mysql server

Hi. It seems MySQL thinks your connection is being made from localhost.localdomain and not from localhost. This usually means that in /etc/hosts there is an entry from 127.0.0.1 to localhost.localdomain. (I've heard RedHat has something like that in some version, but I don't know for sure).

If this is your server (or a colocated server under your control), just add an entry for your MySQL user allowing to connect from localhost.localdomain. If this is not your server (or it is not under your control), ask the administrator.



Regards,

Mario A. Valdez-Ramirez.

Page 1 of 1 All times are UTC - 7 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/