coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: anghel on December 14, 2004, 06:47:34 AM

Title: SQL Database name & Username
Post by: anghel on December 14, 2004, 06:47:34 AM
here is my problem...

i used to have coppermine installed before using my hosts-fantastico where it will automatically be installed...but today my database got corrupted so i decided to install a new coppermine album. But since my fantastico isnt working..i have to install coppermine manually...upload the downloaded zip coppermine to my server...then i run the install.php
the problem is i dunno how to fill my database name & username...

can u give me examples how to fill that up?
cos i fill out copp1 to database name and "myun"_copp1 to username...but it says...

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

MySQL error was : Access denied for user: 'l"myun"_copp1@localhost' (Using password: YES)

i have MY SQL Database on my cpanel...
Title: Re: SQL Database name & Username
Post by: kegobeer on December 14, 2004, 06:50:03 AM
If you don't know what your MySQL connection settings are, it's best to ask your host exactly what needs to be entered.  One thing's for sure, this is not correct: 'l"myun"_copp1@localhost.  No quotation marks in the username field.
Title: Re: SQL Database name & Username
Post by: Casper on December 14, 2004, 03:10:48 PM
You could also download the include/config.inc.php from your old gallery, and see what the database details are in that.
For a new install, you just need to make sure the prefix is different when asked to fill that in.
Title: Re: SQL Database name & Username
Post by: lussika on December 20, 2004, 12:18:08 PM
Hello !
So, I have the same problem with my gallery (my first) :

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

MySQL error was : Access denied for user: 'lussika@freesuperhost.com' (Using password: YES)

What should I make ? Please help me !  :)

Thanks... and sorry for my english.
Title: Re: SQL Database name & Username
Post by: Casper on December 20, 2004, 07:02:03 PM
Have you actually created a user for the database, and added them to it.
Title: Re: SQL Database name & Username
Post by: lussika on December 21, 2004, 04:37:45 PM
Can you explain me how create a user for the database ?
I  had ever created a mySQL database (lussika_lussika), sorry if I'm little dumbass, I'm a newbie with PHP, etc...
Thanks.
Title: Re: SQL Database name & Username
Post by: Joachim Müller on December 22, 2004, 04:05:32 PM
usually you can't create mySQL database users when webhosted - you can't make this bit of information up either; contact your webhost for support, ask them for your mySQL data. If you're self-hosted and have no idea about mySQL users, the only recommendation I can give is: don't run your own server publicly if you have no idea about the basics.

Joachim
Title: Re: SQL Database name & Username
Post by: zeyad on December 23, 2004, 11:50:19 AM
Notice: Undefined index: e-yemen_cop1 in /home/e-yemen/public_html/gallery/include/functions.inc.php on line 65
Coppermine critical error:
Unable to connect to database !

MySQL said: No Database Selected
===============

database was selected, what doi i do know

thanks for your help:)
Title: Re: SQL Database name & Username
Post by: Joachim Müller on December 23, 2004, 01:43:28 PM
edit the file include/config.inc.php (that only exists on your webserver, as the install routine has created it to store the mySQL connection data). Make sure everything in it is set correctly (maybe a spelling erro/typo?).
If you want to start from scratch (running the installer a second time), then delete include.config.inc.php and include/install.lock and run install.php once more.

As suggested above: you have to know your mySQL data, you can't guess or make up. If you're not sure, contact your webhost for support.

Joachim