Multi-hosts problems . . .

noris

Anyone has info how to configure PHP and MySQL on two different machine? Change in configuration files?? PHP 4 is installed on RH Linux 8.0 along with Apache 2. MySQL is installed on another RH Linux 8.0. I have been getting the error - Host <PHP ip address> is not allowed to connect to this MySQL server

The mysql manual suggests that this error can be fixed by using the command-line tool mysql (on the server host!) to add
a row to the user, db, or host table for the user/hostname combination from which you are trying to connect and then execute mysqladmin flush-privileges. But how exactly this can be done??

Appreciate any help.😕

John_Canyon

You need to make sure the IP address of your other machine has permission to access the SQL server.

What you need to do is create a user with the host of your other machine, and set the permissions for that user. Once this is done you should be able to access MySQL on that box.

Cheers.

P.S. If you have a utility such as webmin, or phpMyAdmin this can be done very simply. Just go into "priveleges" and add new user.

noris

Thanks for your reply. I tried to set up a user using phpmyadmin. I would assume Host will be the ip address of the machine that trying to access the MySql server. What then should be put in Global privileges, Grand and Action??

User Host Password Global privileges Grant Action

Thanks again for your help.

noris

John_Canyon

For Global Priveledges Check All.