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: [Solved]: Error connecting to MySQL  (Read 2969 times)

0 Members and 1 Guest are viewing this topic.

rrace

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
[Solved]: Error connecting to MySQL
« on: March 17, 2004, 02:42:09 am »

When I try to install Coppermine, I get the following error:

MySQL error was : Access denied for user: 'rrace@localhost' (Using password: YES)

I have checked the username and password for MySQL and they are correct.  The above login works with phpMyAdmin (just checking the server).

Any suggestions on how to get past this and get the install to complete?

I manually installed the database and uploaded the sql files.  When I try to connect ..coppermine/index.php, I still the same MySQL error message.  How do I manually insert the admin and password into the database (or would that matter at this point since it will not access the database?)

R Race
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
[Solved]: Error connecting to MySQL
« Reply #1 on: March 17, 2004, 09:27:41 am »

edit include/config.inc.php to verfy your db settings - there must be something wrong with them. If coppermine can't connect to the db, there's little point in adding the admin user manually to the db, so you'll have to get the db connection working in the first place.
To create the admin user manually, run a query like this:
Code: [Select]
INSERT INTO yourCoppermineTablePrefix_users VALUES (1, 1, 'YES', 'adminUsername', 'adminPassword');

GauGau
Logged

rrace

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
[Solved]: Error connecting to MySQL
« Reply #2 on: March 18, 2004, 03:05:09 am »

At this point I am stumped.  Unless it is a setting in PHP or Apache, I don't know where to go.  I put comments in the code before the mysql_connect and the variables are correct. The code if failing to connect with the database.

Any resources for hire that could help with this code?  I don't know if Coppermine offers such setup survices.

R Race
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
[Solved]: Error connecting to MySQL
« Reply #3 on: March 18, 2004, 08:11:46 am »

sent you a pm.

GauGau
Logged

rrace

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
[Solved]: Error connecting to MySQL
« Reply #4 on: March 19, 2004, 04:05:42 am »

The problem was the php setup, register_globals needed to be true. After that it installed and worked like it should.

Nice application, well done.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
[Solved]: Error connecting to MySQL
« Reply #5 on: March 19, 2004, 08:14:46 am »

leaving register_globals on is not recommended and should not be necessary to run coppermine if the server is set up properly. Although I'm glad to hear that you were able to solve the issue on your own, I recommend you take a further look into it.

GauGau
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 14 queries.