Re: error connecting to db.

2006-01-16 Thread Ligaya Turmelle
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

RE: error connecting to db.

2006-01-16 Thread Logan, David (SST - Adelaide)
PROTECTED] Sent: Tuesday, 17 January 2006 2:55 PM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: RE: error connecting to db. Thanks for the link I am glad the site has added manuals for multiple versions. I think I have access and db privileges set properly. I can (in effect

RE: error connecting to db.

2006-01-16 Thread doug
Thanks for the link I am glad the site has added manuals for multiple versions. I think I have access and db privileges set properly. I can (in effect) login to the server from the host command line using: mysql -u $MySQLUser -p $MySQLPassword I showed the user table on the off chance that

RE: error connecting to db.

2006-01-16 Thread Logan, David (SST - Adelaide)
Hi Doug, It is probably failing because you changed the ip address. The security system in MySQL is based around where a user is coming from. There is good documentation that is available here http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html I've referred to the current manual for v