Page 1 of 1

PHP-Mysql Problem

Posted: Mon Jan 23, 2006 12:12 am
by dude81
Hello,
I have made a backup server for my existing main server.
I have copied all files from there and created a similar database here.
I have file called for myconfiguration
where I give mysql host,mysql user, mysql password, mysql database
When I see the index page It displays

mysql_connect():Access denied for user 'root'@'192.168.1.XXX' in my config file
but I gave grantall permission to root@192.168.1.XXX.

Can Any one help in this regard

Thanx in Advance

Posted: Mon Jan 23, 2006 12:34 am
by feyd
what are the differences in configuration or version numbers between the servers?

Posted: Mon Jan 23, 2006 1:49 am
by dude81
One was 3.23.58 Original Server
Back Up server 4.1.16
But Im using original servers database on Original Server and Backup Servers database on Back Up server. So they must be independent. :?: (Am I right)

Posted: Mon Jan 23, 2006 1:53 am
by dude81
And in configuration I just change the host to different IP, that is all the configuration changes, and I doubt about grant persmissions, I gave the needed grant permsissions but problem seems to unresolved

Posted: Mon Jan 23, 2006 5:25 am
by feyd
4.1+ uses a different password system than 4.1- from what I remember...

Look into the OLD_PASSWORD() function..

Posted: Mon Jan 23, 2006 10:43 pm
by dude81
Solved
Yes I got the problem, I saw 1(one) in password filed as l(el)