Where do I get the database name, username and password on my web app

Question

Where do I get the database name, username and password on my web app

Jamie Soon 145

Hi,

I would like to install the CMS, Expression Engine on my web app. But first I'm going to run EE wizard to test the server. I'm not sure what details to key in as my database name, username and password. Where do I get this information? Thank you.

I found some mysql database information under environment variables>connection strings, but I'm getting an error when I run the Expression Engine Test.

https://jamiesoonwebsite-afc4a4bhh0fyf2c8.eastasia-01.azurewebsites.net/ee_wizard/

regards

Jamie

Jamie Soon 145 Reputation points

2025-04-13T08:23:50.8966667+00:00

Hi,

I tried putting in the info from the connection string but I'm getting this error when I run the Expression Engine Wizard.

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON. in /home/site/wwwroot/ee_wizard/index.php:249 Stack trace: #0 /home/site/wwwroot/ee_wizard/index.php(249): PDO->__construct('mysql:host=jami...', 'nnezqappyr', Object(SensitiveParameterValue), Array) #1 /home/site/wwwroot/ee_wizard/index.php(131): check_db(Array) #2 {main} thrown in /home/site/wwwroot/ee_wizard/index.php on line 249

Attached some screenshots. What seems to be the problem. Is it how I set up the server configuration. Is selecting PHP stack ok? Thank you.
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator

2025-04-14T02:53:15.1133333+00:00
Hi Jamie Soon,

The error you're encountering (SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON) indicates that your MySQL server requires secure transport (SSL/TLS) for connections.

Below are the steps to resolve this issue:

1.Update Connection String to Use SSL: Ensure your connection string includes SSL parameters. Modify your connection string to include sslmode=require or similar SSL settings.

$dsn = 'mysql:host=jamesonwebsites.server.myqnapcloud.com;dbname=jamesonwebsites;sslmode=require'; $username = 'YYYYYYYYY'; $password = '********';

2.Check MySQL Server Configuration: Verify that your MySQL server is configured to accept SSL connections. You can do this by checking the server settings in the Azure portal.

3.Modify PHP Code to Use SSL: Update your PHP code to ensure it uses SSL for the connection. Here’s an example of how to modify your PDO connection:

$options = [ PDO::MYSQL_ATTR_SSL_CA => '/path/to/ca-cert.pem', PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false, ]; $pdo = new PDO($dsn, $username, $password, $options);

Firewall Rules: Ensure that your firewall rules allow connections from your web app to the MySQL server.

PHP Stack: Using PHP for ExpressionEngine is fine. Ensure that your PHP version meets the requirements for ExpressionEngine

Common Issues and Solutions

Incorrect Server Address: Ensure you are using the correct server address from the connection string and not localhost.

SSL Configuration: Make sure SSL settings match what ExpressionEngine expects. Some setups require SSL to be turned off for testing

Below is an example of a complete connection setup:

try { $dsn = 'mysql:host=jamesonwebsites.server.myqnapcloud.com;dbname=jamesonwebsites;sslmode=require'; $username = 'YYYYYYYYY'; $password = '********'; $options = [ PDO::MYSQL_ATTR_SSL_CA => '/path/to/ca-cert.pem', PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false, ]; $pdo = new PDO($dsn, $username, $password, $options); echo "Connection successful!"; } catch (PDOException $e) { echo "Connection failed: " . $e->getMessage(); }

By following these steps, you should be able to resolve the connection issue and successfully run the ExpressionEngine wizard.

I hope this information helps. Please do let us know if you have any further queries.
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator

2025-04-15T00:43:07.54+00:00

Hi Jamie Soon,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Jamie Soon 145 Reputation points

2025-04-15T07:05:04.65+00:00

Thanks Prasad,

The expression engine tech support said they are not familiar with Azure but gave us a new index.php file to replace in the EE wizard. I have uploaded to github but I'm still getting this error message.

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON. in /home/site/wwwroot/ee_wizard_new/index.php:250 Stack trace: #0 /home/site/wwwroot/ee_wizard_new/index.php(250): PDO->__construct('mysql:host=jami...', 'nnezqappyr', Object(SensitiveParameterValue), Array) #1 /home/site/wwwroot/ee_wizard_new/index.php(131): check_db(Array) #2 {main} thrown in /home/site/wwwroot/ee_wizard_new/index.php on line 250

But I haven't tried the other things you suggested like checking MySQL server configuration and firewall rules. Attached some screenshots and the updated index.php file. Here is the link to the updated eewizard.

https://webdesigner4theworld.com/ee_wizard_new

Anonymous

Hi Jamie Soon,

while you are using the new index.php file to replace in the EE wizard, i would recommend you to cross check the new index whether it has all necessary SSL options when connecting to MySQL, you can refer below example:

try {
    $dsn = 'mysql:host=jamesonwebsites.server.myqnapcloud.com;dbname=jamesonwebsites;charset=utf8mb4';
    $username = 'YYYYYYYYY';
    $password = '********';
    $options = [
        PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8mb4",
        PDO::MYSQL_ATTR_SSL_CA => '/home/site/wwwroot/ssl/ca-cert.pem', // Update this path to where you've uploaded the cert
        PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false, // Only use this for testing!
    ];
    $pdo = new PDO($dsn, $username, $password, $options);
    echo "Connection successful!";
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

if your hosted MySQL is on Azure Database for MySQL, then:

SSL is enforced by default, and it requires clients to connect securely.
You should download the CA certificate and upload it to your App Service (e.g., in /home/site/wwwroot/ssl/).
Update the path in index.php accordingly.

If not let us know which MySQL server you are using.

Jamie Soon 145 Reputation points

2025-04-17T08:40:45.25+00:00
Thanks Siva, can you clarify for the last 2 steps, provide a screenshot where I can download CA certificate.. and if I'm using github desktop, do I just create an SSL folder in my html folder...? thanks

You should download the CA certificate and upload it to your App Service (e.g., in /home/site/wwwroot/ssl/).

Update the path in index.php accordingly.
Jamie Soon 145 Reputation points

2025-04-18T01:58:09.1933333+00:00

I'm going to cancel the web app and try setting the website up on a Azure Virtual Machine, so that I can get back the 'traditional' web hosting environment setup. Hopefully it works.
Anonymous

2025-04-22T01:37:28.73+00:00
Hi Jamie Soon

Can you download the SSL from here ssl-certificate and then update the below path in index.php as per the path where the certificate is stored inside wwwroot.

PDO::MYSQL_ATTR_SSL_CA => '/home/site/wwwroot/ssl/

Do let me know if you have implemented virtual machine for environment works fine for you, If it does, Please share it so that other people who faces similar issue may get benefitted from it.

Thanks
Jamie Soon 145 Reputation points

2025-04-22T02:49:39.39+00:00
Thanks Siva. It works! Thank goodness......

Attached screenshots..

This is the code I added

PDO::MYSQL_ATTR_SSL_CA => '/home/site/wwwroot/ssl/DigiCertGlobalRootCA.crt.pem', // Update this path to where you've uploaded the cert PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false, // Only use this for testing!

I haven't tried it on a Virtual Machine yet. Looks like there's alot of work like setting up Apache, MySQL, DNS zone...
Anonymous

2025-04-22T03:24:56.43+00:00

Hi Jamie Soon,

Glad that you got your issue resolved, Thanks for sharing back, this will really help other member who has similar issue, Thanks again.

Answer accepted by question author

0 additional answers

Your answer

Jamie Soon 145 Reputation points

2025-04-13T08:23:50.8966667+00:00

Hi,

I tried putting in the info from the connection string but I'm getting this error when I run the Expression Engine Wizard.

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON. in /home/site/wwwroot/ee_wizard/index.php:249 Stack trace: #0 /home/site/wwwroot/ee_wizard/index.php(249): PDO->__construct('mysql:host=jami...', 'nnezqappyr', Object(SensitiveParameterValue), Array) #1 /home/site/wwwroot/ee_wizard/index.php(131): check_db(Array) #2 {main} thrown in /home/site/wwwroot/ee_wizard/index.php on line 249

Attached some screenshots. What seems to be the problem. Is it how I set up the server configuration. Is selecting PHP stack ok? Thank you.
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator

2025-04-15T00:43:07.54+00:00

Hi Jamie Soon,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Jamie Soon 145 Reputation points

2025-04-15T07:05:04.65+00:00

Thanks Prasad,

The expression engine tech support said they are not familiar with Azure but gave us a new index.php file to replace in the EE wizard. I have uploaded to github but I'm still getting this error message.

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON. in /home/site/wwwroot/ee_wizard_new/index.php:250 Stack trace: #0 /home/site/wwwroot/ee_wizard_new/index.php(250): PDO->__construct('mysql:host=jami...', 'nnezqappyr', Object(SensitiveParameterValue), Array) #1 /home/site/wwwroot/ee_wizard_new/index.php(131): check_db(Array) #2 {main} thrown in /home/site/wwwroot/ee_wizard_new/index.php on line 250

But I haven't tried the other things you suggested like checking MySQL server configuration and firewall rules. Attached some screenshots and the updated index.php file. Here is the link to the updated eewizard.

https://webdesigner4theworld.com/ee_wizard_new
Anonymous

2025-04-17T07:29:26.42+00:00

Hi Jamie Soon,

while you are using the new index.php file to replace in the EE wizard, i would recommend you to cross check the new index whether it has all necessary SSL options when connecting to MySQL, you can refer below example:

try { $dsn = 'mysql:host=jamesonwebsites.server.myqnapcloud.com;dbname=jamesonwebsites;charset=utf8mb4'; $username = 'YYYYYYYYY'; $password = '********'; $options = [ PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8mb4", PDO::MYSQL_ATTR_SSL_CA => '/home/site/wwwroot/ssl/ca-cert.pem', // Update this path to where you've uploaded the cert PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false, // Only use this for testing! ]; $pdo = new PDO($dsn, $username, $password, $options); echo "Connection successful!"; } catch (PDOException $e) { echo "Connection failed: " . $e->getMessage(); }

if your hosted MySQL is on Azure Database for MySQL, then:

SSL is enforced by default, and it requires clients to connect securely.

You should download the CA certificate and upload it to your App Service (e.g., in /home/site/wwwroot/ssl/).

Update the path in index.php accordingly.

If not let us know which MySQL server you are using.
Jamie Soon 145 Reputation points

2025-04-17T08:40:45.25+00:00

Thanks Siva, can you clarify for the last 2 steps, provide a screenshot where I can download CA certificate.. and if I'm using github desktop, do I just create an SSL folder in my html folder...? thanks

You should download the CA certificate and upload it to your App Service (e.g., in /home/site/wwwroot/ssl/).

Update the path in index.php accordingly.
Jamie Soon 145 Reputation points

2025-04-18T01:58:09.1933333+00:00

I'm going to cancel the web app and try setting the website up on a Azure Virtual Machine, so that I can get back the 'traditional' web hosting environment setup. Hopefully it works.
Anonymous

2025-04-22T01:37:28.73+00:00

Hi Jamie Soon

Can you download the SSL from here ssl-certificate and then update the below path in index.php as per the path where the certificate is stored inside wwwroot.

PDO::MYSQL_ATTR_SSL_CA => '/home/site/wwwroot/ssl/

Do let me know if you have implemented virtual machine for environment works fine for you, If it does, Please share it so that other people who faces similar issue may get benefitted from it.

Thanks
Jamie Soon 145 Reputation points

2025-04-22T02:49:39.39+00:00

Thanks Siva. It works! Thank goodness......

Attached screenshots..

This is the code I added

PDO::MYSQL_ATTR_SSL_CA => '/home/site/wwwroot/ssl/DigiCertGlobalRootCA.crt.pem', // Update this path to where you've uploaded the cert PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false, // Only use this for testing!

I haven't tried it on a Virtual Machine yet. Looks like there's alot of work like setting up Apache, MySQL, DNS zone...
Anonymous

2025-04-22T03:24:56.43+00:00

Hi Jamie Soon,

Glad that you got your issue resolved, Thanks for sharing back, this will really help other member who has similar issue, Thanks again.

Answer 1

Hi ,

Thanks for reaching out to Microsoft Q&A.

To run the ExpressionEngine wizard on your Azure Web App, you need valid MySQL connection details: database name, username, password, and the correct server address. Based on your message and the screenshot, here is what you should check and where to get the required information.

Step by step guide to get MySQL connection details in Azure Web App:

Go to Azure Portal

Open your Web App in the Azure portal.

Navigate to Configuration

Under the Settings section, go to Configuration.

Check the Application settings and Connection strings tabs.

Find the MySQL connection string

Look for a connection string with something like:

Database=jamiesoonwebsite-database;Data Source=mydb.mysql.database.azure.com;User Id=myuser@mydb;Password=yourpassword;

Database name: jamiesoonwebsite-database
Server address: mydb.mysql.database.azure.com
Username: myuser@mydb
Password: as provided in the string

Make sure you do not use localhost as the server address. Azure does not run MySQL locally in the Web App, it connects to an external MySQL service (azure database for MySQL).

Enter these values in the EE Wizard

Use these in the ExpressionEngine wizard:

Server address: use the Data Source value (e.g., mydb.mysql.database.azure.com)
Name: use the Database value
Username: use the User Id
Password: from the connection string

Common error reasons:

Using localhost instead of the Azure MySQL server address.

Typo in username or password.

Database not yet created (ExpressionEngine does not auto create it).

Tip:

If you are using Azure Database for MySQL, make sure:

The firewall rules allow access from Azure services or your Web App.

SSL settings match what the CMS expects (some CMS setups require SSL to be turned off for testing).

Please feel free to click the 'Upvote' (Thumbs-up) button and 'Accept as Answer'. This helps the community by allowing others with similar queries to easily find the solution.

Share via

Where do I get the database name, username and password on my web app

0 additional answers

Your answer