Database connection issues after tables have been created

[kenk2003]

Hi everyone,

I searched for this error in the wiki and the forums and turned up nothing. Perhaps I overlooked something - I think not.

Anyhow, here is my setup:

PHP 5.2.3
CMS 1.0.6
MySQL 5.0.41
Linux box

1. The first page of the installation ( /cmsmadesimple-1.0.6/install/index.php ) says everything is fine and everything has the green dot next to it. I click "Continue".

2. The second page asks me for admin stuff. I enter this in and hit "Continue".

3. I enter in the database credentials. All seems okay (as I also checked all this through the command line prompt). I hit "Continue". I then see this:

Creating additional_users table...[done]
Adding admin_bookmarks table...[done]
Creating adminlog table...[done]
Adding admin_recent_pages table...[done]
Creating content table...[done]
Creating content_props table...[done]
Adding crossref table...[done]
Creating css table...[done]
Creating css_assoc table...[done]
Creating event_handlers table...[done]
....

And the tables do exist in the database. Perfect.

4. I then am asked about "CMS Document root (as seen from the webserver)", "Path to the Document root", and "Query string" which have the correct values (I just left the defaults there). I think click "Continue".

5. I then see this error (in red):

"Could not connect to the database. Verify that username and password are correct, and that the user has access to the given database."

and

"Install additional modules" button. Upon clicking that, I get a "Database Connection failed" error.

I am confused as the installation does actually connect to the database and create the tables but then fails after this step?

Any ideas? config.php is an empty file but has the correct rw (read-write) permissions.

Thank you

[kenk2003]

Found the problem. MySQL account password had a " (quote) in it.

Everything installed fine once I reset the password to one without a quote.