Jump to content

Archived

This topic is now archived and is closed to further replies.

Bee

MYSQL V5.0

Recommended Posts

Hi,

I used to have MYSQL v3.23 installed and it used to work fine with my php. I then updated to a new version MYSQL 5.0 and PHP 5.1.2; however, php pages don't connect to MYSQL server anymore.

I am using IIS and windows xp professional!


Any help will be much appreciated.
Thanks
Bee

Share this post


Link to post
Share on other sites
MySQL 5.0 uses a new PASSWORD() function to encode its user passwords. If you can get any access at all, try:

SET PASSWORD FOR root@localhost=OLD_PASSWORD("yourPW")

Replace root@localhost with your username and remote host.

Share this post


Link to post
Share on other sites
[!--quoteo(post=344311:date=Feb 9 2006, 10:37 PM:name=wickning1)--][div class=\'quotetop\']QUOTE(wickning1 @ Feb 9 2006, 10:37 PM) [snapback]344311[/snapback][/div][div class=\'quotemain\'][!--quotec--]
MySQL 5.0 uses a new PASSWORD() function to encode its user passwords. If you can get any access at all, try:

SET PASSWORD FOR root@localhost=OLD_PASSWORD("yourPW")

Replace root@localhost with your username and remote host.
[/quote]

I don't know what's my username. During installation it only asked me for the root password to set. Can I just use 'root' as a username?

Should I write this command whenever I want to connect to the database?


Thanks
Bee

Share this post


Link to post
Share on other sites
wickning1 is referring to upgrading the privileges table, which is discussed [a href=\"http://dev.mysql.com/doc/refman/5.0/en/mysql-fix-privilege-tables.html\" target=\"_blank\"]here[/a]. You should also probably read the [a href=\"http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html\" target=\"_blank\"]upgrade refman page[/a], as there are many, many incompatible changes.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.