coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: mcrockford on September 06, 2005, 09:43:52 AM

Title: Could not create a mySQL connection, please check the SQL values entered
Post by: mcrockford on September 06, 2005, 09:43:52 AM
Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user 'mcrockford1'@'server218-apache202.livedns.org.uk' (using password: YES)

any ideas what this means ?

Regards

Martin.
Title: Re: Could not create a mySQL connection, please check the SQL values entered
Post by: Nibbler on September 06, 2005, 11:12:37 AM
You need to fill in a valid username and password in order for Coppermine to be able to connect to your database.
Title: Re: Could not create a mySQL connection, please check the SQL values entered
Post by: mcrockford on September 06, 2005, 11:52:36 AM
I have setup a username and password and double checked it, but can't see what's wrong. The server does not like localhost but I used an i.p. addess instead. Where should I go from here ?

Regards

Martin.
Title: Re: Could not create a mySQL connection, please check the SQL values entered
Post by: Joachim Müller on September 06, 2005, 05:30:20 PM
ask your webhost then, this is not something we could help you to figure out. You can't make up the mysql username and password: the user has to already exist and have the proper permissions to access the database.
Title: Re: Could not create a mySQL connection, please check the SQL values entered
Post by: mcrockford on September 07, 2005, 12:56:20 AM
My host has an on-line controll panel where you setup your database name etc for myql , which I have done for coppermine.
Title: Re: Could not create a mySQL connection, please check the SQL values entered
Post by: kegobeer on September 07, 2005, 02:14:43 AM
http://forum.coppermine-gallery.net/index.php?topic=16217.msg75687;topicseen#msg75687

Create the test connection script, upload it to your site, and see what happens.
Title: Re: Could not create a mySQL connection, please check the SQL values entered
Post by: mcrockford on September 07, 2005, 12:01:02 PM
Thanks for that , I get this.

Warning: mysql_connect(): Access denied for user 'mcrockford1'@'server218-apache202.livedns.org.uk' (using password: YES) in /home/fhlinux202/r/reecall.com/user/htdocs/text.php on line 7
Could not connect: Access denied for user 'mcrockford1'@'server218-apache202.livedns.org.uk' (using password: YES)
Title: Re: Could not create a mySQL connection, please check the SQL values entered
Post by: kegobeer on September 07, 2005, 02:37:24 PM
http://dev.mysql.com/doc/mysql/en/access-denied.html
Title: Re: Could not create a mySQL connection, please check the SQL values entered
Post by: mcrockford on September 08, 2005, 07:50:54 AM
Reset the password and all seems ok , thanks very much for all your help