Re: Connecting to remote MySQL servers

Hello Tyler, Saturday, December 09, 2000, 10:25:13 AM, you wrote: TL> Hello, TL> On my home network, I have one machine that runs MySQL. I want this to be TL> my database server. I have another box with PHP and Apache installed on TL> it. I created a file named test.php and attempted to make a connection to TL> the mysql server box: TL> $connection = mysql_connect("192.168.1.2","root","password"); TL> 192.168.1.2 is the IP of the MySQL server box. TL> when I do that, I get the following: TL> Warning: MySQL Connection Failed: Host 'VectraXU' is not allowed to connect TL> to this MySQL server in /usr/local/apache/htdocs/test.php on line 2. TL> So, my question is, how can I make the MySQL server allow connections from TL> the machine with the hostname: VectraXU? It is probably just a 'grant' issue. Working on the host machine you have privileges but on your workstation you don't. Check out 'grant' in the manual -- DSig David Tod Sigafoos mailto:dsig@teleport.com Using 'The Bat' 1.48 Beta/11 ````` ( O O ) _______oOOo__( )__oOOo_______