Having trouble with mySQL on install

[mahtiyar]

Hey guys,
First time intaller here, and when I try to install it gives me this error when I click"Let's Go!"

MySQL error was : Access denied for user: 'XXXX@localhost' (Using password: YES)

Any commonplace mistakes that everyone makes? Seems as though it's at least TRYING to connect, it sees the DB I think. Am I supposed to put my username as username_ or just username.

Sorry for such a newbie question..

[Joachim Müller]

the mySQL connection data you have to enter on the install page can't be made up, you will have to "know" them (or find out about them), asking your webhost. Are you sure you actually have a mySQL database?

GauGau

[mahtiyar]

Who said I made those up? ... Yes , I'm sure I have SQL... and I THOUGHT those were the right values, I just thought there may be some mistakes people commonly make when entering them

[Joachim Müller]

ok, please review the mySQL settings you entered by editing the file your_coppermine_folder/include/config.inc.php (the file only exists on your server, as it was created during install).
If you decide to post them here, make sure to replace your password by asterisks (***).

GauGau

[jono659]

Having the exact same problem, not new to php or mysql, it's on my own dedicated server and has all the requirements, my user and db names are correct as is the pass. Is there anything else that could be causing this error.


JonO

[Joachim Müller]

same thing applies to you: please post details on your server, the contents of the file config.inc.php etc.
A link might help as well.

GauGau

[Joachim Müller]

Please don't send data by PM unless asked. Instead, post your data here, replacing the password with asterisks. Did you make sure the mySQL user has the permissions to create tables?

GauGau

[smackey]

z
Hi, I'm new to the list, but I'm having the same problem.   I have a server on our internal home network (hopefully to be on the net later after it's set up).  I've done the following:

- freshly installed Fedora Core 2, updated it with Yum.
- installed webmin, setup mysql to start at boot, added myself as a mysql user
- installed coppermine as per the directions

and I get:

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user: 'sean@localhost' (Using password: YES)

After this, I did the following:

- used the chown command on all of the files and subfiles in the coppermine directory
- added a database in mysql for coppermine

and I still get that error.  There is nothing in the mysql log (/var/log/mysqld.log).

Any suggestions would be great.

TIA,
sean

[smackey]

I was able to fix my own problem.  Using mysqlaccess I was able to determine that my account in mysql didn't have the privileges that it needed (mysqlaccess <username> mysql).  This listed the account with no privileges.  Using the mysql documentation ( http://dev.mysql.com/doc/mysql/en/Adding_users.html) I was able to recreate my account with all privileges (I also first deleted the account that I had created with Webmin).  After following the first step of section 5.5.2 I had an account that listed correctly with mysqlaccess.  Things then worked as expected on the Coppermine config page. 

sean