coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: AlphaAddict on March 16, 2006, 10:16:35 PM

Title: MYSQL Error
Post by: AlphaAddict on March 16, 2006, 10:16:35 PM
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 ?
Title: Re: MYSQL Error
Post by: Nibbler on March 16, 2006, 10:29:17 PM
Use alpha2_t, and make sure you added the user to the database.
Title: Re: MYSQL Error
Post by: AlphaAddict on March 16, 2006, 10:42:43 PM
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)
Title: Re: MYSQL Error
Post by: Joachim Müller on March 16, 2006, 11:16:25 PM
don't use the cpanel version of coppermine, it's probably the outdated, buggy Fantastico version.
Title: Re: MYSQL Error
Post by: AlphaAddict on March 19, 2006, 03:35:37 PM
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
Title: Re: MYSQL Error
Post by: Nibbler on March 19, 2006, 03:37:36 PM
Enter alpha2_t, not just t
Title: Re: MYSQL Error
Post by: AlphaAddict on March 19, 2006, 03:46:59 PM
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 ..
Title: Re: MYSQL Error
Post by: Nibbler on March 19, 2006, 03:49:06 PM
Did you click 'Add User to Db' ?
Title: Re: MYSQL Error
Post by: AlphaAddict on March 19, 2006, 03:53:52 PM
No ,  Success  :)
Thanks