This guide details the error "Database connection error: could not connect to mysql" that may occur when making changes around an Infomaniak hosting on which the Web app Joomla is installed.

Preamble

• To get the site working again, you need to check and update some information in the Joomla configuration.php file:
  1. The name of the MySQL database — this is often a prefix that has been added before the existing database name and the username (for example bddname before, abcd_bddname after).
  2. The MySQL database host server (for example mysql.domain.xyz before, abcd.myd.infomaniak.com after).
  3. The username that accesses the MySQL database (for example userbdd before, abcd_userbdd after).
  4. The path of two directories /tmp and /logs:
     

Obtain updated information

For points 1, 2 and 3 of the preamble above:

1. Click here to access the management of your product on the Infomaniak Manager (need help?).
2. Click directly on the name assigned to the product in question.
3. Click on Database in the left sidebar.
4. Find and keep your current MySQL information (need help?).

For point 4 of the preamble above:

1. Click here to access the management of your product on the Infomaniak Manager (need help?).
2. Click directly on the name assigned to the product in question.
3. Click on Manage under Advanced settings:
   
4. Under the PHP | Apache tab, under PHP Information click on Show Information.
5. At the line _SERVER['DOCUMENT_ROOT'] copy the path to the right:
   

Modify the Joomla configuration.php file

Prerequisites

• Create an FTP account (need help?).
• Connect via FTP (need help?).

Then edit the configuration.php file which is in the root folder of your Joomla:

1. Find the relevant paragraph and update the 4 pieces of information in the preamble above.
2. Also replace the old path (including "www") with the new path:
    
3. Save the file; your Joomla will now connect to the correct database.

Check the changes made

On the Joomla interface, it is possible to check the paths of the /logs and /tmp folders:

• For the /logs folder: go to System / Configuration then System
• For the /tmp folder: go to System / Configuration then Server