The MySQL database is hosted on a different server. I am building a new webserver, not mysql server. -----Original Message----- From: Nathan Rixham [mailto:nrixham@xxxxxxxxx] Sent: Wednesday, September 10, 2008 5:14 PM To: php-general@xxxxxxxxxxxxx Subject: Re: New Server Install Robbert van Andel wrote: > Our MySql server is an established server that I can successfully connect to > from other web servers. When I run my php script I see no attempt made to > connect to the mysql server but do see the attempt and subsequent activity > when connecting via the command line. > > -----Original Message----- > From: Mark Bomgardner [mailto:mbomgardner@xxxxxxxxx] > Sent: Wednesday, September 10, 2008 2:46 PM > To: 'Robbert van Andel' > Subject: RE: New Server Install > > Ok, then a couple of things to check. Even though you can login through the > command line, when you set up MySQL is your host name the same as the host > you are trying to connect from. When you log in through the command line, > you may be logging in from the "localhost" whereas when you login from your > webpage, you are trying to login from your web server host name. This may > be something you want to check. > > > Log in to your mysql server from the command line, switch to the Mysql > datasbase and run SELECT * FROM user\G this will give you a readable print > of your users. > > markb > > -----Original Message----- > From: Robbert van Andel [mailto:robbert@xxxxxxxxx] > Sent: Wednesday, September 10, 2008 4:40 PM > To: mbomgardner@xxxxxxxxx > Subject: RE: New Server Install > > That didn't work :(. Thanks though. > > Robbert > > -----Original Message----- > From: Mark Bomgardner [mailto:mbomgardner@xxxxxxxxx] > Sent: Wednesday, September 10, 2008 2:19 PM > To: 'Robbert van Andel' > Subject: RE: New Server Install > > Robbert: > > I have had the same thing happen, but it gets fixed with a computer reboot. > Not sure why, but I have had this happen on a couple of boxes. > > markb > > -----Original Message----- > From: Robbert van Andel [mailto:robbert@xxxxxxxxx] > Sent: Wednesday, September 10, 2008 4:13 PM > To: php-general@xxxxxxxxxxxxx > Subject: New Server Install > > I am working on a new webserver running Fedora 9. I installed php-mysql and > php-mssql via yum. When I try to connect to our mysql server using php, I > get the following error: Can't connect to MySQL server on 'mysqlservername' > (13) > > > > Here's the weird part, I can connect to the mysql database server just fine > from the web server's command line so I'm pretty confident that it's not a > firewall issue. While trying to connect using PHP, I see no packets leaving > the webserver. > > > > Any thoughts? > > > > Thanks, > > Robbert > > > i hate to say such basics; but looks like you have the server defined in a config.php or the like as something similar to: $db['server'] = 'mysqlservername'; and it needs changed to local host.. have you tried just doing a very very basic mysql_connect() also check php.ini ; you may ahve the defaults set up in there incorrectly.. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
