jenrose wrote:
Thank you for your suggestion.
I will quiz server in the morning.

I also feel that I may have had some problem actually creating the database in the first place through CPanel as in the past my other servers have created MySQL databases for me. Can anyone run me through creating a database in CPanel.

Main problem is though the error message replaces the index page and I cannot login through the browser.

Do I have to delete all of XOOPS and reinstall?
Did that once already and did not work.

Please help if you can.

Cheers Jen

When you enter Cpanel X, look for the MySQL Databases icon.

First you will have to create a database before you can add a user to this. Look for a textbox with DB: and a button that has ‘add db’.

Enter the name of the database you wish to use.

Next you have to create a user for this or add a new user to it.

If you are attaching a user to a database then this is very easy. Look for two pull down menus side by side like:

User: [accountname_username] DB: [accountname_database]

Select the user for the database you just created and select all ‘Privileges:’ checkbox and then click on the ‘add user to DB’ button.

That’s the database ready to go if you do it that way.

Now if you want to create a user then follow these steps:

Look for ‘Users: ‘ and it should have two text input boxes.

UserName: [ textbox ]
Password [ textbox ]

Enter the username and password for the new user.

Note: when you add a new user Cpanel actually adds your account name to the start of this. So if your actual account name with your hosting were jenrose, then Cpanel would create a new user called jenrose_username. You will notice that when you create your user (Should display it over those textboxes I mentioned previous.

Again, to add this user name to the database you created just follow the previous step.

So remember, if you create a database called ‘mydatabase’, Cpanel will have it as jenrose_mydata (or something like this) and the same with the username.

You most likely have entered the details like you did without adding your hosting account name on it first.

Hope this helps a little J

ATB

Catz