Lazarus Gb Error

[Gail]

Hi,

 

Well I am having my share of computer problems these past couple of days.

 

I have been using the Lararus GB script for some months now and I am running the current version. It works great until last PM - when I clicked on the link for my GB, I got the following error message:

 

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user '******_Gail'@'localhost' (using password: YES) in /home/*****/public_html/lazarusgb/lib/mysql.class.php on line 40 $message

 

Any ideas as to what the problem may be.

 

I am not into php as yet - I don't understand why a script works perfectly for days/weeks/months and then for no apparent reason - I get an error message and can't get into the GB (obviously a connect problem to db). I haven't made any changes to the way I connect to MySQL.

 

Thanks for any help.

 

Gail

Edited December 2, 2006 by Gail

[TCH-Don]

Did you look at the admin/config.inc.php file

to check the database info to make sure its still right.

 

I would open a help desk ticket to the techs.

[TCH-Andy]

I think you have set the same user for several different databases. You have modified the password for that user, and hence you will need to modify the password in the admin/config.inc.php and update it to the new one.

[Gail]

Hi Guys,

 

You hit the nail on the head. I never realized that using another password for the MySQL db when I set up WordPress would change the other database passwords as well. I think this is the first time it has happened. It changed both Lazarus GB and Gallery 2 but not Coppermine - the Coppermine Gallery still worked. When I think about it, changing the other passwords does make sense when I use the same username.

 

Question: Am I better to use the same username and password for each MySQL db I set up or should I set up different usernames and passwords for each db? I will leave the current ones but I am thinking if I should happen to use another php script in the future that requires setting up a db.

 

As always, thanks for your time.

 

Gail

[TCH-Bruce]

Question: Am I better to use the same username and password for each MySQL db I set up or should I set up different usernames and passwords for each db? I will leave the current ones but I am thinking if I should happen to use another php script in the future that requires setting up a db.

 

As a personal preference I use a different user/password for each database. But that's just my preference. You can do it either way.

 

Using the same user/pass combination I feel is not such a good idea. If my user/pass combination is hacked and I was using the same for all my databases they would have access to everything.

[Gail]

Hi Bruce,

 

Thanks for your response. Yes, what you say does make sense to me. I must say I have learned something today (not that I don't learn everyday or at least I hope I do). I thought I was doing pretty good at setting up MySQL databases and I never thought of the issue of using the same username and different passwords.

 

Thanks again folks.

 

Gail

[carbonize]

Up until recently I only ever used a single database for all the scripts I run. It was only when testing SMF for the Lazarus support forums that I created a new database to test with and decided to keep it once live.

 

Anyway I'm glad you got the problem sorted but not as glad as I am that it's not a problem with Lazarus it's self as that would of meant work for me

Edited December 4, 2006 by carbonize