Installing MODx Evolution 1.0.3: Database connection failed!

I read all the topics on this matter, and none of them seems could help me.

New to Modx, trying to install evolution 1.0.3 on my x64 Windows 7 laptop with xampp

Details about system:
# Apache/2.2.12 (Win32) DAV/2 mod_ssl/2.2.12 OpenSSL/0.9.8k mod_autoindex_color PHP/5.3.0 mod_perl/2.0.4 Perl/v5.10.0
# MySQL client version: 5.1.37

I have even created database manually, checked MySQL permissions, but always got passed testing and on step 3 got this error:

Creating connection to the database: Database connection failed!

What am I doing wrong? must be something that I have missed.

I am really exited to finally got onto this great system!

here are the screenshots:

Small update
when attempting to solve problem, I tried installing revolution version which gives me similar "Database connection..." problem.
However problem disappears when I removed database table prefix!!! And revolution installs without further problems!

Now I tried that on evolution install but without luck! Still the same...:(

But now I can play with new version until this issue is solved

You often need to create an empty database yourself in PhpMyAdmin (and a user with full rights) before running the install. Note that the username and password on the page you’ve shown are the credentials you’ve set for the database user, *not* the MODx administrator.

The initial connection page appears to have been successful; the first step connects to the MySql engine and gets a list of possible charset connections. The second step connects to the database and provides a choice of default collations for the tables. These were both successful, according to these screenshots.

The question is, why then does it fail when it tries to connect again to run the insert for creating the tables? Is it returning a misleading error message? Maybe the _ is offending the server’s configuration for some reason? What would happen if you used a prefix without an _?

Thank you all for trying to help

I tried to use prefix without _, and even use empty prefix, but without luck

Tried to use different charset or collation but same problem

Even if I change mysql user makes no difference, and all users have all privileges with grant option

I run out of ideas

If a Revo install was successful, but an Evo wasn’t, what’s the difference? Evo just uses a simple

built from the same data from the same form that the initial check uses. The only thing I can think of is some kind of socket locking from the initial connection? The initial check and if necessary creation of the database doesn’t appear to close the connection, so maybe something is getting hung up on the initial connection.

Any resolution to this? I'm experiencing the same problem. The client is using iPowerWeb for a host.

Hello,

This is an older post so let's start fresh shall we?

What version of MODX are you trying to install, what is the database version, and did you try removing the table prefix as noted above?

I've bonked a number of installs by not using the proper DB user.

It's gotta have "db-name_username" in the user field during install. It'll connect without the db-name, but it won't validate the db. Also, you've gotta back all the way out and re-do the connection. It won't work if you just modify the fields on the db connection page.

Assuming that you're installing Revo that is.