This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 55.00000000000001%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
I tried setting up a WordPress website on Azure Virtual Machine.
Instead of installing MySQL DB. I tried creating an Azure DB for MySQL (Flexible Server) in the same network with the private access and gave the database details in the wp-config.php file in the server.
While loading the webpage with the IP Address in the browser. I am receiving "Error establishing connection with database"
Can you please help me resolve this.
OS: Linux
apache and php used.
Hi, @Jami Prem Kumar Welcome to Microsoft, thanks for posting your query,
As we understand the ask here is you are trying to load the WordPress webpage and it throws a connection error with MySQL database, please correct me if I am wrong.
For the mentioned scenario you need to make changes in the wp-config file to use azure DB for MySQL server in your WordPress VM as mentioned in the below article Here
Regards
Geetha
@GeethaThatipatri-MSFT Yes Geetha. It is throwing an error "Error establishing connection with the database"
I gave the below details in the wp-config.php file
Database account name
Database name
Username
Password
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 51%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
I have the same question. I created the MySQL flexible db server and now I wanna connect with my Azure VM running WordPress and can't able to do it.
Hi @Ejaz Talha look at the second answer to this question, below the "accepted answer", for more details. This issue is easily resolved by updating the "wp-config.php" file.
Hi @ JamiPremKumar-7324 As per the support team this issue has been resolved after disabling the SSL Connection setting for the server parameter and WordPress website on Azure Virtual Machine is working as expected.
Regards
Geetha
Thank you for visiting the Microsoft QA forums! Have a great day!
Regards
Geetha
Hi,
I have a similar setup: WordPress is running on a Linux VM and MySQL is setup in an Azure DB for MySQL (Flexible Server).
You do NOT have to disable traffic encryption between your DB and web servers. You want data to be secure in transit.
WordPress can handle SSL connections to a database. To enable this, add the following lines in your "wp-config.php" file.
define( 'DB_SSL', true );
define( 'MYSQL_CLIENT_FLAGS', MYSQLI_CLIENT_SSL );
Thanks Alexandar. Is there any way I can contact you? For changing wp-config file I can't go to Cpanel and I installed a file manager plugin where has wp_config.php file is read-only. How can I modify it?
The best way to update the file is using Notepad through RDP, if the VM is Windows. Or VIM through a terminal connection to your VM, if it is Linux. If your PC runs Windows and you do not have WSL installed, you can use PowerShell to SSH to the Linux VM.
Since you are using cPanel, you could try changing the file permissions using the cPanel File Manager - link to blog post below. After the permissions have been updated, you should be able to edit the file - link to file editing docs below. If these steps fail, you should remote into your VM, as described above, and edit the file that way.