Advanced search  

News:

cpg1.5.30 maintenance release - upgrade recommended
The Coppermine development team is releasing an update for Coppermine in order to fix several minor issues. All fixes are not security critical, so if your gallery is running fine with cpg1.5.28 you don't need to upgrade. If you are running an older version than cpg1.5.28, you must update to this latest version as soon as possible because of the security impact!
[more]

Pages: [1]   Go Down

Author Topic: [Solved]: Access Denied - SQL ERROR [ mysql4 ]  (Read 7818 times)

0 Members and 1 Guest are viewing this topic.

posh

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
[Solved]: Access Denied - SQL ERROR [ mysql4 ]
« on: December 29, 2008, 06:43:52 PM »

Yeah, another newbie post! :(

I installed the Coppermine Gallery, as part of my forum so the url went like this mysite.com/forum/gallery/. Had a few bumps when installing the gallery with the mysql databases, something with the passwords so I set up a new one and it worked then. So installed the gallery, uploaded a few things... then when I went back to my homepage i.e. www.mysite.com, this came up

Quote
General Error

SQL ERROR [ mysql4 ]

Access denied for user 'xxxxxxx_caroline'@'xxxx.xxxxxxxxxx.ie' (using password: YES) [1045]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

I dunno what's happened?  ??? I then checked to see if my forum database was working (I have three databases, one for the main site, forum and the gallery), so went to www.mysite.com/forum but got the same error.

I tried adding new users to the database and making them DBA and deleting xxxxxxx_caroline from the user list but it still comes up. Anyone know what the problem is?

 :-\ :-\ :-\
« Last Edit: December 29, 2008, 07:12:32 PM by Nibbler »
Logged

Nibbler

  • Guest
Re: Access Denied - SQL ERROR [ mysql4 ]
« Reply #1 on: December 29, 2008, 06:45:37 PM »

Make sure include/config.inc.php has valid details for connecting to the database. We can't help you with setting up databases and users, ask your host about that.
Logged

posh

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Access Denied - SQL ERROR [ mysql4 ]
« Reply #2 on: December 29, 2008, 06:58:11 PM »

Cheers for the speedy response, I checked the config.php file in the gallery/include, it was the same, then checked it for my forum config.php file and got the right password, changed it for that user and now everything is hunky dory again!  :D  :D :D

Thank you!!!  :-*
Logged
Pages: [1]   Go Up
 

Page created in 0.074 seconds with 19 queries.