Re: Connecting to remote MySQL servers

hi tyler, you have to set the right permissions in the mysql - user and mysql - db tables greetings andreas ----- Original Message ----- From: "Tyler Longren" <tyler.longren@midiowa.net> To: "PHP-General" <php-general@lists.php.net> Sent: Saturday, December 09, 2000 7:25 PM Subject: [PHP] Connecting to remote MySQL servers > Hello, > > On my home network, I have one machine that runs MySQL. I want this to be > my database server. I have another box with PHP and Apache installed on > it. I created a file named test.php and attempted to make a connection to > the mysql server box: > > $connection = mysql_connect("192.168.1.2","root","password"); > > 192.168.1.2 is the IP of the MySQL server box. > when I do that, I get the following: > Warning: MySQL Connection Failed: Host 'VectraXU' is not allowed to connect > to this MySQL server in /usr/local/apache/htdocs/test.php on line 2. > > So, my question is, how can I make the MySQL server allow connections from > the machine with the hostname: VectraXU? > > Thanks, > Tyler > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >