PHP-Mysql Problem

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
dude81
Forum Regular
Posts: 509
Joined: Mon Aug 29, 2005 6:26 am
Location: Pearls City

PHP-Mysql Problem

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

what are the differences in configuration or version numbers between the servers?
User avatar
dude81
Forum Regular
Posts: 509
Joined: Mon Aug 29, 2005 6:26 am
Location: Pearls City

Post 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)
User avatar
dude81
Forum Regular
Posts: 509
Joined: Mon Aug 29, 2005 6:26 am
Location: Pearls City

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

4.1+ uses a different password system than 4.1- from what I remember...

Look into the OLD_PASSWORD() function..
User avatar
dude81
Forum Regular
Posts: 509
Joined: Mon Aug 29, 2005 6:26 am
Location: Pearls City

Post by dude81 »

Solved
Yes I got the problem, I saw 1(one) in password filed as l(el)
Post Reply