Checking database:Could not connect to the mysql server. What now?

Quote from: splittingred at Feb 15, 2010, 11:37 AM

We at the very least need your PHP/MySQL versions, as well as if you have the pdo_mysql extension installed.

And if you’re on a shared host that’s running MySQL 4.1.22, you need to tell them to upgrade MySQL. That’s absurd to be running that ancient a MySQL version on a shared server on their part.

Duly noted. For now, I will continue to work with MovableType 5. If that doesn’t work out, I’ll revisit MODx and restart the troubleshooting.

Smittie

Same problem here :

lighttpd/1.4.13
PHP Version 5.2.0-8
MySQL: 5.0.32

max_execution_time 120
max_input_time 60
memory_limit 128M

Using Firefox & Google Chrome

Error.
I can pass this step, but after "Connecting to mysql server: Success!" the button "→ Create or test selection of your database." does not work.

It does nothing. No error message. Error log show no errors.

Quote from: XaTriX at Feb 17, 2010, 10:30 PM

lighttpd/1.4.13
PHP Version 5.2.0-8
MySQL: 5.0.32

We know for a fact that this horrible 5.2.0-8 release of PHP folks are using for some reason does NOT work. There are PDO-related bugs in this version which simply breaks important functionality required by Revolution. Upgrade your PHP configuration or I recommend using Evolution releases in that environment.

Same problem here (Firefox), i created a new DB named "modx" in utf8_general_ci

* Mac OS 10.6.2 (Snow Leopard)
* MySQL host info: Localhost via UNIX socket
* MySQL 5.1.43
* UTF-8 Unicode (utf8)
* Apache/2.2.13 (Unix) mod_ssl/2.2.13 OpenSSL/0.9.8l DAV/2 PHP/5.3.0
* mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $
* PHP Extension mysql


my login/pass are good, i successfully installed Expression Engine

I was having a similar problem on an initial test on my local development server–I remember leaving the "Database host" field blank in the Revolution setup screen and both tests passed and it continued to install.

Edited to include:
PHP: 5.2.11
MySQL: 5.0.75

S O L V E D

To Everyone who has the same problems ... (sometimes it pays off to spend a great amount of time on "Bing"... I found this link to the modx forum http://modxcms.com/forums/index.php?topic=45167.0 with the magic line to edit the php.ini file. It did solve the problem instantly.

SO MY HUGE THANK YOU TO ROB!

Thank you, Rob, you brought my one week mysql odyssey to an end!

I am getting the same error that others are reporting.
I have an account with Bluehost.com and everything should it seems be ok, but it is not.

I am on the Connection Information page.

Connecting to mysql server: Success!

But the next check it does not pass.

Checking database:Could not connect to the mysql server.

I have pasted into the php.ini file: pdo_mysql.default_socket=/tmp/mysql.sock
and uploaded the file to the modx folder. No change.

How am I to proceed?

Thanks.

Paal Joachim

Quote from: Paal_Joachim at Mar 09, 2010, 10:24 AM

I have pasted into the php.ini file: pdo_mysql.default_socket=/tmp/mysql.sock
and uploaded the file to the modx folder. No change.

This needs to be in the main php.ini for the server or in .htaccess (or .user.ini for 5.3+). Please see http://php.net/manual/en/configuration.php or contact your host for more information on where and how configuration settings can be set.

After adding pdo_mysql.default_socket=/tmp/mysql.sock to your php.ini, make sure to restart Apache, and also clear your browser cache and cookies.

Modx seems to be storing some error messages in the session, and these seem to persist, even after the source of the error has been fixed.