Web Hosting Talk







View Full Version : Mysql error with php script


Atif Munir
08-17-2002, 02:24 AM
Hi,
I am on Plesk2.0
I am running a php script which takes the backup of a remote database of Mysql. The script is fine as I have tested it on some other machine.On one of my servers it is giving the following errors.
<b>Warning</b>: Access denied for user: 'alid@15.25.23.4(Using password: YES) in <b>/home/gom/gm-Auto/automails/include/code/defs.php</b> on line <b>12</b><br />


Although I have defined some other IP address in the script but Its still taking its own ip for taking backup.
Thanks in advance.
Atif

bitserve
08-17-2002, 01:21 PM
So you're saying that it's trying to connect to a MySQL server on a different IP than you were expecting? Is that the problem you're trying to resolve, or are you trying to get it to authenticate on the server that it is actually trying?

That message simply means that the user and password you're using can't authenticate to that MySQL server at that IP.

DOCS (http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Privilege_system)

2host.com
08-17-2002, 02:03 PM
Originally posted by Atif Munir
Hi,
I am on Plesk2.0
I am running a php script which takes the backup of a remote database of Mysql. The script is fine as I have tested it on some other machine.On one of my servers it is giving the following errors.
<b>Warning</b>: Access denied for user: 'alid@15.25.23.4(Using password: YES) in <b>/home/gom/gm-Auto/automails/include/code/defs.php</b> on line <b>12</b><br />


Although I have defined some other IP address in the script but Its still taking its own ip for taking backup.
Thanks in advance.
Atif

Try "localhost" if it's running on that specific system. Otherwise try the proper qualified domain name of the host you're connecting to.

Atif Munir
08-18-2002, 11:42 PM
Hi,
Yes I am trying to connect to a MySQL server on a different IP.

Atif