[Eleanna]

Hi,
downloaded this today, unzipped and uploaded 1789 files to the server. Created database with user and password as per usual, and then go to install. It opens the install page no problem, I give it the details, and am absolutely certain it is getting the right details, but I get an error. It tells me that access to the database vor user...@.... is denied. The problem seems to be that your username is wrong. Double checked the whole lot, the details given are correct.
Uninstalled the whole lot, re-installed, gave it exactly the same details, now it tells me that the password is wrong. Uninstalled again, reinstalled, and it tells me the username is wrong.

Here are the details used

host: mysql1001.mochahost.com
db: [Removed]
user: [Removed]
password: [Removed]

This is doing my head in. I've tried both versions of the db name and user, with and without prefix. Doesn't make the slightest difference. The details are 100% certain correct. Anybody any ideas?

[Steven]

Does your MySQL user have all of the privileges in Step 5?

http://www.commentics.org/wiki/doku.php?...e_database

[Eleanna]

Does your MySQL user have all of the privileges in Step 5?

http://www.commentics.org/wiki/doku.php?...e_database

Hi Steven,

yes, all the privileges have been given. It simply alternates between telling me the username is wrong and the password is wrong. I'm in the process of installing this yet again to see if I can figure out what is going wrong. But it's been a long day...

[Eleanna]

Does your MySQL user have all of the privileges in Step 5?

http://www.commentics.org/wiki/doku.php?...e_database

Hi Steven,

yes, all the privileges have been given. It simply alternates between telling me the username is wrong and the password is wrong. I'm in the process of installing this yet again to see if I can figure out what is going wrong. But it's been a long day...

Right, did the whole gig over again, same story, "This error appears to be because your password is wrong". Went to check on includes/db/details.php and the file does not exist???

[Steven]

Okay. That file is automatically created by the installer after entering your database details, so it's normal for it not to exist to begin with. Try creating the file manually with the following content inside (making sure to enter your details).

PHP Code:

<?php

$cmtx_mysql_database = '';

$cmtx_mysql_username = '';

$cmtx_mysql_password = '';

$cmtx_mysql_host = 'localhost';

$cmtx_mysql_port = '';

$cmtx_mysql_table_prefix = '';

?>

[Eleanna]

Okay. That file is automatically created by the installer after entering your database details, so it's normal for it not to exist to begin with. Try creating the file manually with the following content inside (making sure to enter your details).

PHP Code:

<?php

$cmtx_mysql_database = '';

$cmtx_mysql_username = '';

$cmtx_mysql_password = '';

$cmtx_mysql_host = 'localhost';

$cmtx_mysql_port = '';

$cmtx_mysql_table_prefix = '';

?>

[Steven]

Sure, you can submit a ticket at the URL below and I'll take a look tomorrow.
http://www.commentics.org/support/index.php?a=add

[monster_man]

Hi,

I am having the exact same problem as Eleanna, can you remember what the solution to this was?
Thanks.

[Steven]

Hi,

The problem was that they were entering a dash in the database name when the actual database name had an underscore.

Can you open /upload/includes/db/failure.php and after this line:

PHP Code:

<?php 

function cmtx_db_error_connect($errno, $error) { //display a database connection error to admin 

[monster_man]

Thanks! Works perfectly now, all installed and ready to set up, thanks again!