Problems with Confirguration

[walby3]

Apologies in advance I truly am not a web designer and don't pretend to be!

I've just changed my hosting company to 123-Reg and since my website hasnt been working. I have copied over all the files and database and changed a few bits of the configuration file as 123-reg requested but I keep getting this error.

Database Error: Unable to connect to the database:Could not connect to MySQL

123-Reg have tried to fix the problem but have apparently tested it and there is no problem with Database but must be a problem with the website itself and suggested I try this forum. If anyone on here could lend any help it would be appreciated I'm pretty much at the end of my tether with it all now to be honest.

Thanks in advance everyone!

[NickC4555]

These entries in configuration.php (in the root of your website) need updating:

public $host = 'localhost';
public $user = 'database user name';
public $password = '************';
public $db = 'database name';

$host is probably 'localhost', but could be an IP address if your database and website are on different servers. Have you created a database user and assigned it permissions to the database?

[imanickam]

For the user (that was defined to connect to the database) has been GRANTed ALL PRIVILEGES?

[walby3]

Thanks for responding both of you! I've been trying to delve into the settings of MySQL but not much luck yet, I believe the configuration file is okay although I will double check this. I think you have a point about these priveleges though. I've got a screenshot here.

https://www.dropbox.com/s/wuhgyh2d9xc6w ... 2.png?dl=0

Only problem is I can't work out how to change the priveleges I've been trying to understand the manual but nothing I'm doing is working. I cant work out where the commands need to go what commands to use and finally whether I'm even logged into the right account I see mention of a Root account which I have never used or set up, is this something I should get onto 123-Reg about?

[NickC4555]

I don't know what hosting control panel 123-reg uses, but it will be in there somewhere, not in phpMyAdmin.

[imanickam]

Generally, in a shared hosting environment, from the cPanel, the steps would be as follows:
- Create a Database
- Create a User to access the database
- Add the User to the Database & in this step, one has to choose the Privileges

[walby3]

Hi there, I've spoken to 123-Reg and they have said this...

The privileges of the username cannot be modified. However, please rest assured that they are set to the ones needed to run a Joomla website.

[NickC4555]

I suggest you get a new hosting provider. It is ridiculous that you haven't got control over this through the hosting control panel. If they are offering such a basic service it is likely you are going to run into other problems with them in the future, such as PHP settings, versions etc. They are not providing you with the tools you need to manage your environment.

[walby3]

Yeah I think your right, just for my peace of mind though and not wasting my time with another hosting provider lets just say they are right and the priveleges are fine, any idea what else it could possibly be that is causing this error?

i dont want to go with another hosting company and have the same problem because in fact the priveleges were fine, we just couldnt find that out.