jayson Posted November 8, 2006 Posted November 8, 2006 Ok here is the problem, I had a problem getting into my cpanel, had the password reset, now I want to update coppermine, and this is the error I get. I do not understand the error: Welcome to the Coppermine upgrade program • • • ERROR • • • The following errors were encountered and need to be corrected first: Could not create a mySQL connection, please check the SQL values in include/config.inc.php MySQL error was : Access denied for user 'jaysarah'@'localhost' (using password: YES) Can I get a little help.. Thanks Or should I open a trouble ticket... Quote
TCH-Thomas Posted November 8, 2006 Posted November 8, 2006 It sounds like the password entered in the database doesn´t match the one entered in include/config.inc.php. Quote
LISH-Josh Posted November 8, 2006 Posted November 8, 2006 (edited) Ok here is the problem, I had a problem getting into my cpanel, had the password reset, now I want to update coppermine, and this is the error I get. I do not understand the error:Welcome to the Coppermine upgrade program • • • ERROR • • • The following errors were encountered and need to be corrected first: Could not create a mySQL connection, please check the SQL values in include/config.inc.php MySQL error was : Access denied for user 'jaysarah'@'localhost' (using password: YES) Can I get a little help.. Thanks Or should I open a trouble ticket... Check the config file for coppermine (I believe it's in root dir of the installation). The config file will contain the SQL password. In cPanel under MySQL icon: - Delete the coppermine USER (I repeat, the USER - NOT THE DB). - Re-create the user with the same credentials from the coppermine config. - Add the user to the coppermine DB with all privs. Edited November 8, 2006 by JRKy Quote
jayson Posted November 8, 2006 Author Posted November 8, 2006 (edited) ok did the mysql stuff, logged into cpanel clicked on mysql entered user name of: jayjay (not true) entered password : tchrocks (not true) clicked on create user it create a user name of jaysarah_jayjay (jaysarah is the DB name(why the XXXXXXX_XXXXX)) clicked on ad user to DB went into the include/config.inc.php changed dbusrname to jayjay (first) changed DBpassword to tchrocks then entered in www.XXXXXXXXXXXX.com/XXXXXX/update.php ERROR: Welcome to the Coppermine upgrade program • • • ERROR • • • The following errors were encountered and need to be corrected first: Could not create a mySQL connection, please check the SQL values in include/config.inc.php MySQL error was : Access denied for user 'jayjay'@'localhost' (using password: YES) Welcome to the Coppermine upgrade program • • • ERROR • • • The following errors were encountered and need to be corrected first: Could not create a mySQL connection, please check the SQL values in include/config.inc.php MySQL error was : Access denied for user 'jayjay'@'localhost' (using password: YES) ok did the mysql stuff a different way, logged into cpanel clicked on mysql entered user name of: jayjay (not true) entered password : tchrocks (not true) clicked on create user it create a user name of jaysarah_jayjay (jaysarah is the DB name(why the XXXXXXX_XXXXX)) clicked on ad user to DB went into the include/config.inc.php changed dbusrname to jaysarah_jayjay (second) changed DBpassword to tchrocks then entered in www.XXXXXXXXXXXX.com/XXXXXX/update.php ERROR: Welcome to the Coppermine upgrade program • • • ERROR • • • The following errors were encountered and need to be corrected first: Could not create a mySQL connection, please check the SQL values in include/config.inc.php MySQL error was : Access denied for user 'jaysarah_jayjay'@'localhost' (using password: YES) Welcome to the Coppermine upgrade program • • • ERROR • • • The following errors were encountered and need to be corrected first: Could not create a mySQL connection, please check the SQL values in include/config.inc.php MySQL error was : Access denied for user 'jaysarah_jayjay'@'localhost' (using password: YES) but I will keep plugging away.... Thanks Edited November 8, 2006 by jayson Quote
LISH-Josh Posted November 8, 2006 Posted November 8, 2006 ok did the mysql stuff, logged into cpanel clicked on mysql entered user name of: jayjay (not true) entered password : tchrocks (not true) clicked on create user it create a user name of jaysarah_jayjay (jaysarah is the DB name(why the XXXXXXX_XXXXX)) clicked on ad user to DB went into the include/config.inc.php changed dbusrname to jayjay (first) changed DBpassword to tchrocks then entered in www.XXXXXXXXXXXX.com/XXXXXX/update.php ERROR: Welcome to the Coppermine upgrade program • • • ERROR • • • The following errors were encountered and need to be corrected first: Could not create a mySQL connection, please check the SQL values in include/config.inc.php MySQL error was : Access denied for user 'jayjay'@'localhost' (using password: YES) Welcome to the Coppermine upgrade program • • • ERROR • • • The following errors were encountered and need to be corrected first: Could not create a mySQL connection, please check the SQL values in include/config.inc.php MySQL error was : Access denied for user 'jayjay'@'localhost' (using password: YES) ok did the mysql stuff a different way, logged into cpanel clicked on mysql entered user name of: jayjay (not true) entered password : tchrocks (not true) clicked on create user it create a user name of jaysarah_jayjay (jaysarah is the DB name(why the XXXXXXX_XXXXX)) clicked on ad user to DB went into the include/config.inc.php changed dbusrname to jaysarah_jayjay (second) changed DBpassword to tchrocks then entered in www.XXXXXXXXXXXX.com/XXXXXX/update.php ERROR: Welcome to the Coppermine upgrade program • • • ERROR • • • The following errors were encountered and need to be corrected first: Could not create a mySQL connection, please check the SQL values in include/config.inc.php MySQL error was : Access denied for user 'jaysarah_jayjay'@'localhost' (using password: YES) Welcome to the Coppermine upgrade program • • • ERROR • • • The following errors were encountered and need to be corrected first: Could not create a mySQL connection, please check the SQL values in include/config.inc.php MySQL error was : Access denied for user 'jaysarah_jayjay'@'localhost' (using password: YES) but I will keep plugging away.... Thanks Just create a user with the credentials you want. Add that user to the CP DB. Enter those credentials into the include/config.inc.php file (make sure you use the entire username - i.e. cpanel user name prepended to the db username). Then try your update. Quote
TCH-Bruce Posted November 8, 2006 Posted November 8, 2006 Josh is correct. Enter it as cpaneluser_dbname for the password do not preface the password. For the user it's cpaneluser_dbuser. Quote
jayson Posted November 8, 2006 Author Posted November 8, 2006 everything was fine till I tried to update... geez.... I am so confused..... \ Quote
jayson Posted November 9, 2006 Author Posted November 9, 2006 I do not know what happened, but finally got it to work..Thanks to you all Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.