MySQL 4.1

Installation and configuration iussues

Moderators: macek, egami, gesf

User avatar
Alexej Kubarev
Site Admin
Site Admin
Posts: 2223
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län
Contact:

MySQL 4.1

Postby Alexej Kubarev » Thu Nov 04, 2004 2:07 pm

Hi guys!

As you already know, i hope, MySQL 4.1 is now cetificated a s a stable product release and may be used in a production enviroment.
This might be a good thing for most of us as 4.1 has several features that might be helpfull.

However there are several issues with PHP4 and MySQL 4.1

After installing and configuring the server you might get the following error message
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client


This is due to PHP4 using an old version of mysql library... MySQL 4.1 has a completely different authentication method, then 4.0

This might seem impossible to some of you to fix. But there IS a solution :D

And id like to share it with you, in case you still dont know about it.
The easiest way would be using mysql administrator. There you will have to go to server settings and set Use Old Password to checked.

Then you will have to re-assign all the passwords so that they will be saved the way you want to.

The harder way is through the query:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');


Alternatively, you can use this:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;


Finaly the third way:
Start mysqld with the --old-passwords option.
Assign an old-format password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query:

mysql> SELECT Host, User, Password FROM mysql.user
-> WHERE LENGTH(Password) > 16;


For each account record displayed by the query, use the Host and User values and assign a password using the OLD_PASSWORD() function and either SET PASSWORD or UPDATE, as described earlier.

I hope this will help those of you that are in need :)

User avatar
Redcircle
Moderator
Moderator
Posts: 830
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA
Contact:

Postby Redcircle » Sat Nov 06, 2004 10:17 am

Awesome info!

User avatar
Alexej Kubarev
Site Admin
Site Admin
Posts: 2223
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län
Contact:

Postby Alexej Kubarev » Sat Nov 06, 2004 1:01 pm

Hehe :D
Thanx :)

User avatar
Alexej Kubarev
Site Admin
Site Admin
Posts: 2223
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län
Contact:

Postby Alexej Kubarev » Mon Dec 27, 2004 3:17 am

Im sorry for the delay with this update.

PHP has a new extention that is designed to work with MySQL 4.1.3 and above.

As far as i can see this module is accessible only in PHP 5.
This module is called Improved MySQL Extention: mysqli

You can simply load that module and use it instead of mysql module. (most (not sure if not all) versions have mysql module built-in)

Note: you will have to use mysqli_query and similar instead of mysql_query.

I must say that the use of MySQL 4.1.8 is now recommended as it gives more sequrity and a faster database. Its easy to configure and absolutely no problems in managing with MySQL Administrator that is freely available from mysql.com for download.

As MySQL.com itself recommends all Windows XP users to use MySQL Administrator while Win98/NT/2000 to use WinMySQLAdmin utility.

More updates to come :)

ice_blizzard
New php-forum User
New php-forum User
Posts: 14
Joined: Thu Aug 04, 2005 12:48 am
Location: New City
Contact:

MYSQL ADmin

Postby ice_blizzard » Fri Aug 05, 2005 1:18 am

bout this MYSQL ADmin....what would be at the:

Stored Connection:________________(browse)
Server Host:_____________________ Port: 3306
Username:______________________
Password:_______________________

please help it prompts me to errors...
hehe...


Return to “MySQL Installation”

Who is online

Users browsing this forum: No registered users and 0 guests