Search code examples
mysqlazureazure-web-app-servicein-app

Reset MySQL in app Azure username and password


I was attempting to change the username and password of the MySQL in-app database in my Azure web app. I mistakenly thought that by changing the connection string in MYSQLCONNSTR_localdb.ini would change the password. I am wondering if there is a way to restore the original MYSQLCONNSTR_localdb.ini file so I can get the password and access the database. I also deleted the MYSQLCONNSTR_localdb.txt file.


Solution

  • It seems you don't need to restore the password, you could customize the database, username and password to be used.

    In the doc:

    If you want to customize the database, username and password, after you have created a new database, add new username or update password, simply modify D:\home\data\mysql\MYSQLCONNSTR_localdb.ini , remove D:\home\data\mysql\MYSQLCONNSTR_localdb.txt and restart the WebApps.