Hello! I used an older version of XOOPS a few years ago and had everything up and running great. However, a few months ago I was doing some "experimenting" with PHP and wound up trashing everything. So I just deleted all the files and the XOOPS database and haven't touched it since.

Last week I have decided to reinstall the latest version of XOOPS but am having trouble setting it up. I go through the setup but it cannot connect to the database to save my life.

My question is, does the database HAVE TO be named "xoops"? Or can it be called something else? Since I deleted the database a few months ago, my provider won't let me reinstate it or recreate it using the same name. I have created new a database called Xoops2 but it just doesn't want to connect. Is the database name why I cannot connect during the initial setup?

The other thing I noticed is during the first few setup steps -when you pull down the drop down box to choose the database name it says "MySQL" and there are no other choices. Does this have any impact?

I use IPower hosting which includes MySQL 5.0.45. I have checked and double checked everything. Permissions, user names, etc. are all okay. This is the only thing that is out of the ordinary...

Any suggestions would be greatly appreciated. Thanks!

1) You can use any name that you want

2) I have couple of Websites on IPowerWeb, and don't have any problems with the connection to the MySQL database.

Make sure that you have the right permissions to the database as the admin

bebosh, Welcome to the XOOPS Forum!

Quote:That is the database type selection and it is correct that only MySQL is present.

You may test your database with this dbtest.php, that contains:
You need to replace MY SQL SERVER by the server, probably localhost and USERNAME and PASSWORD by your values.
The databasename is already set to Xoops2.
What does it say?

Well, I tried that script and got this result:

Connected to MySQL
Access denied for user 'xoops2'@'10.%' to database 'Xoops2'


I don't get it. I've checked and double checked everything. The user has full priveleges to do everything! I've even created other databases with other usernames just to test and get the same result... can't connect.

It's got to be something super simple and stupid that I'm forgetting....

This is really driving me crazy. I don't remember having a problem like this when I set up XOOPS a couple years ago.

Thanks for all your help and advice!

Evidently it was a problem with the database. My provider deleted and recreated a new database and it works fine.

Thanks for your help and sorry for being such a noob!!!!