SQL Database name & Username SQL Database name & Username
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

SQL Database name & Username

Started by anghel, December 14, 2004, 06:47:34 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

anghel

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...

kegobeer

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.
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Casper

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.
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

lussika

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.

Casper

Have you actually created a user for the database, and added them to it.
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

lussika

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.

Joachim Müller

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

zeyad

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:)

Joachim Müller

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