MySQL connection problem

Author Message

Olivier Ligny

Monday 07 November 2005 12:43:51 am

Hello,

I have a computer with Wamp installed, but stopped.
During the ezPublish installation process, there is a problem with MySQL :

<i><b>Installing MySQL: Service successfully installed.
Installing MySQL return: 0
Starting MySQL:
Le service MySQL a démarré (</i>Mysql started sucessfully<i>).
Starting MySQL return: 0
Creating databases: ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
Creating databases return: 1</b></i>

First I didn't see that problem (it's only in the install.log file). So I did continue the installation, and I started the configuration steps, I configured the SMTP server ... And then it said me : "The database would not accept the connection, please review your settings and try again."

I saw that the MySQL server wasn't started. So I try to enter "net start mysql" on my command-line, and I got again the following error :
<i><b>Le service MySQL démarre.
Le service MySQL n'a pas pu être lancé.
Une erreur système s'est produite.
L'erreur système 1067 s'est produite.
Le processus s'est arrêté inopinément.</b></i>
So, what is this "system error 1067" ?

I successfully launched my other MySQL server (which came with Wamp). But even then, ezPublish didn't see it, I got the same error ("The database would not accept ...") !!!

I'm tired :-(
Does someone have an idea ?

Thanks a lot :)
Olivier (excuse my bad english !)

Ł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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.