470,619 Members | 1,577 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,619 developers. It's quick & easy.

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

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...
Jul 20 '05 #1
3 1508
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.
Jul 20 '05 #2
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...
Jul 20 '05 #3
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...
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Bill Hernandez | last post: by
13 posts views Thread by wideangle | last post: by
4 posts views Thread by wzhao6898 | last post: by
5 posts views Thread by Carlo Tambuatco | last post: by
2 posts views Thread by xiuchuanli | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.