Can't connect from PHP to MySQL after upgrade to 4.1.7?

[M Wells]

Hi All,

Last night I upgraded my MySQL install from 4.0.20 to 4.1.7. All
seemed to go well -- i stopped and removed the 4.0.20 service.
Installed 4.1.7. Then copied my MYD etc files from the data directory
of my 4.0.20 installation to the new installation and can now use the
mysql client to access the data in my dbs and tables.

However, for some reason, all of my PHP scripts have stopped working,
except, for some reason, PHPMyAdmin (presumably because it's using the
root user?). I've recreated the user I ordinarily use to get to my
databases and have given it global privelages, but still can't get it
to work.

Does anyone have any suggestions as to how I might fix this?

Much warmth,

Murray
http://www.planetthoughtful.org
Building a thoughtful planet,
one snide comment at a time...

[Bill Karwin]

M Wells wrote:

I've recreated the user I ordinarily use to get to my
databases and have given it global privelages, but still can't get it
to work.

Can you connect to the database in the mysql CLI, using this login?

If not, did you use the FLUSH PRIVILEGES command after creating the user
and granting privileges?

These are pretty basic questions, I'm just trying to rule out the easy
stuff... I frequently have to slap my forehead after making such a mistake!

Regards,
Bill K.

[M Wells]

On Sun, 07 Nov 2004 11:34:42 -0800, Bill Karwin <bi**@karwin.com>
wrote:

M Wells wrote:

I've recreated the user I ordinarily use to get to my
databases and have given it global privelages, but still can't get it
to work.

Can you connect to the database in the mysql CLI, using this login?

If not, did you use the FLUSH PRIVILEGES command after creating the user
and granting privileges?

These are pretty basic questions, I'm just trying to rule out the easy
stuff... I frequently have to slap my forehead after making such a mistake!

Hi Bill,

Yes, I can connect using the mysql CLI with the username and password,
and can 'USE' the database in question and select records from it.

I haven't tried FLUSH PRIVELEGES, but I can give that a try as well.

Any other suggestions / thoughts?

Thanks for your help...

Much warmth,

Murray
http://www.planetthoughtful.org
Building a thoughtful planet,
one snide comment at a time...

[M Wells]

On Sun, 07 Nov 2004 20:01:06 GMT, M Wells <pl**************@gmail.com>
wrote:

On Sun, 07 Nov 2004 11:34:42 -0800, Bill Karwin <bi**@karwin.com>
wrote:

M Wells wrote:

I've recreated the user I ordinarily use to get to my
databases and have given it global privelages, but still can't get it
to work.

Can you connect to the database in the mysql CLI, using this login?

If not, did you use the FLUSH PRIVILEGES command after creating the user
and granting privileges?

These are pretty basic questions, I'm just trying to rule out the easy
stuff... I frequently have to slap my forehead after making such a mistake!

Hi Bill,

Yes, I can connect using the mysql CLI with the username and password,
and can 'USE' the database in question and select records from it.

I haven't tried FLUSH PRIVELEGES, but I can give that a try as well.

Any other suggestions / thoughts?

Okay, after some Googling it turns out that I needed to change my
MySQL user passwords using the OLD_PASSWORD function.

I'm wondering why this was necessary for PHP version 4.3.6?

Still, it appears to now be back up and working.

Much warmth,

Murray
http://www.planetthoughtful.org
Building a thoughtful planet,
one snide comment at a time...