Solve a cut between Joomla and MySQL

This guide concerns users who make changes around an Infomaniak hosting on which Joomla is installed.

Preamble

• If you had to update the connection between the MySQL database and your Joomla site (to avoid error "Database connection error: could not connect to mysql" e.g.) then this procedure details how to proceed.
• Often it is a matter of prefix which was simply added in front of the existing database name and username.

Elements to be amended

Here is the information to adapt in the file configuration.php for your Joomla site to work:

1. the name of the MySQL database (e.g. bddname before, abcd_bddname after)
2. the host server of the MySQL database (e.g. mysql.domain.xyz before, abcd.myd.infomaniak.com after)
3. the username that accesses the MySQL database (e.g. userbdd before, abcd_userbdd after)
4. the path of the following two directories: /tmp and /logs
   
   

Edit File configuration.php of Joomla

To this end:

1. Click here in order to access the management of your product on the Manager Infomaniak (Need help?).
2. Click directly on the nameallocated to the product concerned.
3. Click on the button Advanced Parameters.
4. Under the tab PHP click on PHP information.
5. On the line _SERVING['DOCUMENT_ROOT'] copy the path to the right
    
   
    
6. In the left side menu, click on Databases.
7. Find and store your current MySQL information according to the above list (help: https://faq.infomaniak.com/1981).
8. In the left side menu, click on FTP/SSH.
9. Create an FTP account: https://faq.infomaniak.com/1982
10. Log in via FTP: https://faq.infomaniak.com/1130
11. Edit file configuration.php which is in the root folder of your Joomla.
12. Find the relevant paragraph and update the 4 information (according to the list above).
13. Don't forget to replace the old way (including "www") by the new way:
     
    
     
14. Save the file and that's it, your Joomla will now connect to the correct database!

a

Check for changes made

In the Joomla interface, it is possible to check folder paths /logs and /tmp:

• For the folder /logs: Go under System / Configuration then System
• For the folder /tmp: Go under System / Configuration then Server