DB Initialization with MySQL 4.1.7

Saturday 16 April 2005 6:24:03 am - 3 replies

3 replies

Author	Message
Łukasz Serwatka	Monday 18 April 2005 12:49:23 am You can make simple test: Create file "test.php" with <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ?> Access via URL localhost/test.php to see the results. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Matteo Garzulino	Tuesday 19 April 2005 6:05:26 am Thanks Lukasz for your tip! Problem was caused by this MySQL error: "Client does not support authentication protocol requested by server; consider upgrading MySQL client". I solved the problem changing the user's password using this statement: mysql> SET PASSWORD FOR -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); Probably PHP 4.3.11 doesn't support new hashing algorithm used by MySQL 4.1 to manage the passwords. I think this problem doesn't exist on PHP 5.0. Anyway this problem and his solutions are well described in MySQL Documentation. I hope this will help anyone who could have the same nconvenience i had. Bye, Matteo.
Łukasz Serwatka	Tuesday 19 April 2005 6:08:51 am You`re welcome :) It is also good to enable debug output in site.ini if you will have problems with installation next time. [DebugSettings] DebugOutput=enabled Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog

Author

Message

Łukasz Serwatka

Monday 18 April 2005 12:49:23 am

You can make simple test:

Create file "test.php" with

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

Access via URL localhost/test.php to see the results.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Matteo Garzulino

Tuesday 19 April 2005 6:05:26 am

Thanks Lukasz for your tip!

Problem was caused by this MySQL error: "Client does not support authentication protocol requested by server; consider upgrading MySQL client".

I solved the problem changing the user's password using this statement:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Probably PHP 4.3.11 doesn't support new hashing algorithm used by MySQL 4.1 to manage the
passwords. I think this problem doesn't exist on PHP 5.0.

Anyway this problem and his solutions are well described in MySQL Documentation.

I hope this will help anyone who could have the same nconvenience i had.

Bye,

Matteo.

Łukasz Serwatka

Tuesday 19 April 2005 6:08:51 am

You`re welcome :)

It is also good to enable debug output in site.ini if you will have problems with installation next time.

[DebugSettings]
DebugOutput=enabled

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

You must be logged in to post messages in this topic!