coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 permissions => Topic started by: jttaint on July 14, 2006, 01:51:31 PM

Title: Can anyone give me MySLQ help please?
Post by: jttaint on July 14, 2006, 01:51:31 PM
I deleted my user account from my coppermine gallery in SQL
by accident.
Now the coppermine gallery wont open, and i cant figure out how to
re add the user i deleted in SQL .

<A href="http://www.ilovetaints.net/TAINTPHOTOS">Coppermine Gallery</a>
QuoteCoppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'jttaint_copp1'@'localhost' (using password: YES)


I am using
MySQL 4.1.19-standard

I am using coppermine 1.4.2

thank you in advance

Title: Re: Can anyone give me MySLQ help please?
Post by: Abbas Ali on July 14, 2006, 02:30:34 PM
Open  includes/config.inc.php in a text editor and see whether the values for database username and password are correct or not. If not then correct them.
Title: Re: Can anyone give me MySLQ help please?
Post by: jttaint on July 14, 2006, 02:50:13 PM
Yes i see where to change the user, but

it still wont work

the user changed  though

QuoteCoppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'jttaint_copp2'@'localhost' (using password: YES)
Title: Re: Can anyone give me MySLQ help please?
Post by: jttaint on July 14, 2006, 02:52:27 PM
the user I deleted in MySQL was jttaint_copp1

when i am in MySQL and i try to add a user like that, it wont let me
or am i on the wrong path ??

Title: Re: Can anyone give me MySLQ help please?
Post by: Nibbler on July 14, 2006, 03:00:32 PM
Add the user as copp1, the username is automatically prepended (assuming you are using some control panel, you haven't actually told us).
Title: Re: Can anyone give me MySLQ help please?
Post by: jttaint on July 14, 2006, 03:01:38 PM
phpMyAdmin 2.6.4-pl2

sorry i forgot that

i think that will work i will try it now nibbler
Title: Re: Can anyone give me MySLQ help please?
Post by: jttaint on July 14, 2006, 03:05:50 PM
THANK YOU THANK YOU THANK YOU

Can you tell I really appreciate your help ?
That worked!!!
Title: Re: Can anyone give me MySLQ help please?
Post by: Joachim Müller on July 14, 2006, 03:31:22 PM
Glad this worked for you.

However, you're using a very outdated version:
Quote from: jttaint on July 14, 2006, 01:51:31 PM
I am using coppermine 1.4.2
It's mandatory to upgrade (http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#upgrade) asap!