remove the @ - it surpresses the errors. set your error_reporting to E_ALL and find out the DB error message with mysql_error.

error_reporting(E_ALL);
$SvrConn = mysql_connect($MySQLServer, $MySQLUser, $MySQLPassword);
if(!$SvrConn)
{
  echo 'Failure to connect!  Error message returned: '.mysql_error();
}

[EMAIL PROTECTED] wrote:
I have a php application that connects with MySQL using:

  $SvrConn = @mysql_connect($MySQLServer, $MySQLUser, $MySQLPassword)

where:  $MySQLServer='127.0.0.1'
        $MySQLUser='dbuser'
        MySQLPassword='dbpasswd'

and I can login using the above values. However connect fails:

mysql> select host,user from user;
+-----------+---------+
| host      | user    |
+-----------+---------+
| localhost | dbuser  |
+-----------+---------+

The application worked until I changed the IP of the host. Where else might I
look? There is no cnf file.

thanks for any help.


_____
Douglas Denault
http://www.safeport.com
[EMAIL PROTECTED]
Voice: 301-469-8766
  Fax: 301-469-0601


--

life is a game... so have fun.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to