Joined: 06 Mar 2003, 03:21 Posts: 447 Location: Monterrey, NL, Mexico
|
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.
|
|