Share » Forums » Install & configuration » MySQL connection problem

MySQL connection problem

MySQL connection problem

Monday 07 November 2005 12:43:51 am - 2 replies

Author Message

Ɓukasz Serwatka

Tuesday 08 November 2005 8:50:54 am

Olivier, for installation process try to enable DebugOutput, look in to settings/site.ini.append.php then locate [DebugSettings] and set DebugOutput=enabled

If you will see error like:

"Client does not support authentication protocol"

Then you will have to run SQL query

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
    -> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

or start mysqld with the --old-passwords option

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

Olivier Ligny

Wednesday 09 November 2005 6:39:06 am

Hello,

The problem was that the databases hadn't been created, because of the MySQL server which crashes at startup, I think. So I use my own MySQL server instead (which came with Wamp). And I added this line in the ezmysqldb.php file :

if ( $this->IsConnected && $db != null ) {
mysql_query("CREATE DATABASE IF NOT EXISTS $db", $connection);
$ret = mysql_select_db( $db, $connection );

Now, it works. (The ezpublish MySQL server still crashes).

Bye
Olivier

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

36 542 Users on board!

Forums menu