Can anyone give me MySLQ help please?

[jttaint]

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>

Coppermine 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

[Abbas Ali]

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.

[jttaint]

Yes i see where to change the user, but

it still wont work

the user changed  though

Coppermine critical error:
Unable to connect to database !

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

[jttaint]

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

[Nibbler]

Add the user as copp1, the username is automatically prepended (assuming you are using some control panel, you haven't actually told us).

[jttaint]

phpMyAdmin 2.6.4-pl2

sorry i forgot that

i think that will work i will try it now nibbler

[jttaint]

THANK YOU THANK YOU THANK YOU

Can you tell I really appreciate your help ?
That worked!!!

[Joachim Müller]

Glad this worked for you.

However, you're using a very outdated version:

I am using coppermine 1.4.2

It's mandatory to upgrade asap!