mysql error...

[Desception]

hi,

i have coppermine uploaded, files chmoded and everything set... but when i try and run the install.php i get this error once i click 'lets go':

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

MySQL error was : Access denied for user 'desception'@'localhost' (using password: YES)

someone please help...

[Joachim Müller]

well, are you absolutely sure that you entered the correct mySQL data? You can't make it up.

[Desception]

I am 100% POSITIVE I entered the data correctly, I checked 10 times... literally. and yes I created a mysql db in my cpanel, and created a user account/joined it to the db.

[Joachim Müller]

make sure that the db user has the needed privileges (mysql has permissions as well). Ask your webhost for support when not sure.

[Desception]

the user has ALL priveleges selected...

[Abbas Ali]

Create a test script (connect.php) with following code, upload it to your cpg root dir and execute it. Report the output you get.
Replace the host, dbuser etc... variables with your values.

Code Select Expand


<?php
$host = 'localhost';
$dbuser = 'test';
$dbpass = 'pass';
$dbname = 'cpgDbName';

// Connecting, selecting database
$link = mysql_connect($host, $dbuser, $dbpass)
    or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db($dbname) or die('Could not select database');

// Closing connection
mysql_close($link);
?>


[Desception]

this was the message i got:

Warning: mysql_connect(): Access denied for user 'desception'@'localhost' (using password: YES) in /home/desceit/public_html/gallery/connect.php on line 8
Could not connect: Access denied for user 'desception'@'localhost' (using password: YES)

[Abbas Ali]

This is the most simple script to connect to database and should work if all the values supplied are correct. I doubt that the user with which you are trying to connect to database do not have access to it. If you want i can take a look at it. PM me the cpanel and database details.

[Desception]

i think the problem is because im trying to use my db but my dns isnt fully propogated yet... i just changed the nameservers yesterday...

[Abbas Ali]

i think the problem is because im trying to use my db but my dns isnt fully propogated yet... i just changed the nameservers yesterday...

What does this mean? Do you have database on some other server and coppermine files on some other server?

If both are on same server then dns has nothing to do with it.

[Desception]

no... that means that i have changed the dns' of my domain name and they havent fully changed yet because it takes anywhere from 24 - 48 hours to properly change

[Abbas Ali]

Ya i know that it takes time to propogate. You misunderstood my question. Anyways you are giving Mysql host as 'localhost'...right? This will ensure that php will connect to mysl host locally and won't look for dns entries to resolve the host. Hence once again i repeat DNS has nothing to do with above problem (afaik).

[noraweb]

I am having the exact same problem, and I have ABSOLUTELY no idea what to do. I think it might be that the permissions aren't correct, but I don't really know how to change them.

[Joachim Müller]

If you have exactly the same issue, why don't you read the thread and do as suggested by Abbas Ali and run the test script. If it fails, ask your webhost for support. If you're self-hosted, review your mysql setup and mysql user permissions (review the whole idea of running your own webserver as well).