1
torweb
Error: Unable to connect to database
  • 2010/2/1 23:08

  • torweb

  • Just popping in

  • Posts: 56

  • Since: 2007/3/5 1


My site has been up for the last year then all of a sudden - Error: Unable to connect to database

My sql database is still on the host server but something may have happend to my user login info.

Is it possible to change the user login for the XOOPS database. I saw it listed in a couple of mainfile.php

Thanks for any help on this


2
ghia
Re: Error: Unable to connect to database
  • 2010/2/2 0:01

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


The database user and password is indeed defined in the mainfile.php You can change it by editing the file (don't forget to set the permissions).

3
torweb
Re: Error: Unable to connect to database
  • 2010/2/2 0:29

  • torweb

  • Just popping in

  • Posts: 56

  • Since: 2007/3/5 1


Thank you very much for the reply! A couple of questions.

1. How many mainfile.php are there. I only found two.
2. Do I change the permissons on those files? They're set to 444 now.

So if I add a new user to the database for my XOOPS site then change the user and password in the mainfile.php, I may be able to connect again?

I think my host company had something to do with this

Thanks again

4
ghia
Re: Error: Unable to connect to database
  • 2010/2/2 0:52

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


There should be only one /mainfile.php
You have to set the permission to eg 777 for editing or replacing it. When finished, set it again to readonly (444).

It is unclear to me how you come to know, that there is a new user and password for the database. Did your hoster tell you this? Then he probably moved or updated the server.

5
torweb
Re: Error: Unable to connect to database
  • 2010/2/2 0:53

  • torweb

  • Just popping in

  • Posts: 56

  • Since: 2007/3/5 1


I got it back...thanks for the help. Prior to this happening, I was receiving "Internal Server Errors" for all of my sites...very strange.

Thank you again!!

Login

Who's Online

228 user(s) are online (161 user(s) are browsing Support Forums)


Members: 0


Guests: 228


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits