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: MYSQL Error  (Read 6791 times)

0 Members and 1 Guest are viewing this topic.

AlphaAddict

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
MYSQL Error
« 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 ?
« Last Edit: March 19, 2006, 03:54:47 pm by Nibbler »
Logged

Nibbler

  • Guest
Re: MYSQL Error
« Reply #1 on: March 16, 2006, 10:29:17 pm »
Use alpha2_t, and make sure you added the user to the database.
Logged

AlphaAddict

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
Re: MYSQL Error
« Reply #2 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)
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MYSQL Error
« Reply #3 on: March 16, 2006, 11:16:25 pm »
don't use the cpanel version of coppermine, it's probably the outdated, buggy Fantastico version.
Logged

AlphaAddict

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
Re: MYSQL Error
« Reply #4 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
Logged

Nibbler

  • Guest
Re: MYSQL Error
« Reply #5 on: March 19, 2006, 03:37:36 pm »
Enter alpha2_t, not just t
Logged

AlphaAddict

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
Re: MYSQL Error
« Reply #6 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 ..
Logged

Nibbler

  • Guest
Re: MYSQL Error
« Reply #7 on: March 19, 2006, 03:49:06 pm »
Did you click 'Add User to Db' ?
Logged

AlphaAddict

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
Re: MYSQL Error
« Reply #8 on: March 19, 2006, 03:53:52 pm »
No ,  Success  :)
Thanks
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.016 seconds with 15 queries.