Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: SQL Database name & Username  (Read 3590 times)

0 Members and 1 Guest are viewing this topic.

anghel

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
SQL Database name & Username
« 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...
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: SQL Database name & Username
« Reply #1 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.
Logged
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

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: SQL Database name & Username
« Reply #2 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.
Logged
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

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: SQL Database name & Username
« Reply #3 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.
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: SQL Database name & Username
« Reply #4 on: December 20, 2004, 07:02:03 pm »

Have you actually created a user for the database, and added them to it.
Logged
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

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: SQL Database name & Username
« Reply #5 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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: SQL Database name & Username
« Reply #6 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
Logged

zeyad

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Re: SQL Database name & Username
« Reply #7 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:)
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: SQL Database name & Username
« Reply #8 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
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 15 queries.