Hi

I am looking for some help with PHP and mySQL on a RedHat 7.2 server. I have
the PHAkt 1.1.3 installed and running. I created a site, created a recordset
and that worked fine. I can connect to the DB just fine. I then uploaded
everything too the remote server. (Remote being the machine next to my
workstation.) I just set up the server the other day. I am running the
webbased "myphpadmin" and added a user named "www" with permission to do
what is needed an operate on that host.

Now, when I try and view the page, it returns the error:

Warning: Host '172.17.1.24' is not allowed to connect to this MySQL server
in /var/www/html/adodb/adodb-mysql.inc.php on line 85


Can anyone give me some help? I am new to PHP/mySQL and linux. I have been
working on ASP/MSSQL and Win for several years.

Thanks,

Brent

PS: My SQL is running on the same machine as the Apache webserver

The problem is that you haven't correctly created the user by the look of this. When you create your user, you can determine which hostname/s, IP Ranges etc can connect. It would seem that if you can connect to this server remotely, but not locally (ie: When you upload the pages to this server), that you haven't created the permissions correctly, and have denied access to all 'localhost' access....

Unfortunately, this is a common issue, when using a utility like MyPHPAdmin to control your user rights.

I would recommend a utility like mysqlfront (www.mysqlfront.de) that contains a real user management system, that changes all of the relevant entries in each of access table (there is more than one).



Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>