MYSQL Error

[AlphaAddict]

im installing cpg the latest version and i keep getting

"

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

MySQL error was : Access denied for user 't'@'localhost' (using password: YES)


"

and a basic copy text from my cpanel  mysql

"MySQL Account Maintenance

   
   
Databases:
alpha2_Coppermine
User: Db:
Privileges: ALL ALTER CREATE TEMPORARY TABLES CREATE DELETE DROP SELECT INSERT UPDATE REFERENCES INDEX LOCK TABLES


Db:
Users:
alpha2_t
UserName:t
Password:
Access Hosts:
localhost
Host (% wildcard is allowed):
phpMyAdmin

    You can use phpMyAdmin to administrate your MySQL databases in a web based environment.


"

ive tried it with multiple names /  passwords but no luck can anyone help ?

[Nibbler]

Use alpha2_t, and make sure you added the user to the database.

[AlphaAddict]

now its not even showing the database

it says alpha2_Coppermine in cpanel but

mySQL could not locate a database called 'alpha2_Coppermine' please check the value entered for this

when i remove the alpha2_ from the db name and user i get

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

MySQL error was : Access denied for user 't'@'localhost' (using password: YES)

[Joachim Müller]

don't use the cpanel version of coppermine, it's probably the outdated, buggy Fantastico version.

[AlphaAddict]

No its the latest version i downloaded it from here last week
the instalation is here

http://www.alphaaddict.net/gallery/

here is the db screen

http://i1.tinypic.com/rs916r.jpg

[Nibbler]

Enter alpha2_t, not just t

[AlphaAddict]

well when i use alpha2_t it fails to find the database


mySQL could not locate a database called 'alpha2_Coppermine' please check the value entered for this


even if i use

Coppermine

but when i use just t it finds the database but cant connect i have no idea whats wrong ..

[Nibbler]

Did you click 'Add User to Db' ?

[AlphaAddict]

No ,  Success 
Thanks