mmitchel

I have installed mysql 4.0.20 on a system running Fedora Core 1 . I installed from source code. Mysql starts fine and I can access it locally, creating db's, tables and inserting data.

The box sits behind a router and any attempt to access from a remote source fails. the router passes through http requests and port 3306 is open.

In the course of trying to figure this out, I began testing different connections from the local machine, using a php script. What I found was that a connection attempt using localhost

<?php
$link = mysql_connect('localhost','xxx','yyy') ;
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully' ;
mysql_close($link) ;
?>

works fine.

If I run the same php script using 127.0.0.1 to identify the host, the connection fails with the error message:

mysql_connect(): Access denied for user: 'xxx@localhost.localdomain' (Using password: YES)

The skip networking directive is de-activated in the my.cnf file. I have run the mysql command - grant all privileges on *.* to 'xxx@%' identified by 'yyy' ; and done a flush privileges afterwards.

I guess my questions boils down to - why does 127.0.0.1 not work to identify the host

Is there something else I need to do to allow remote access ???

Frustrated in Ottawa..

Administrator

Did you get this sorted out? I've experienced similar issues and had to define hosts in various ways before it worked. Don't know why.

mmitchel

No - I have not sorted this out yet. What kind of changes did you have to make to the hosts file to get it working.