none
[PHP][Web Apps] Database Connection RRS feed

  • Question

  • Hello,

    I am a Systems Engineer and has a very far knowledge in programming but I was tasked to forward a back end using Microsoft Azure to the developer we hired for our company's web app.

    I followed and collaborated instructions from these sites 

    http://www.talmeida.net/blog/2015/11/23/get-started-with-a-free-website-and-mysql-db-in-azure

    https://blogs.msdn.microsoft.com/uk_faculty_connection/2015/09/16/creating-a-php-web-site-with-a-cleardb-mysql-database-all-with-a-free-azure-student-account/

    As I selected the specific database I created, it seemed that clearDB does not detect the database connection.

    Hoping for anyone's help.

    Thank you and regards,




    Monday, March 21, 2016 3:16 AM

Answers

  • Hi,

    The article which you followed is for free azure student account, when you need to have a azure student account.

    If you are already using the same account, then please let us know what is the complete error message do you get.

    Also check this article:
    https://azure.microsoft.com/en-in/documentation/articles/store-php-create-mysql-database/

    Regards,
    Azam khan

    • Marked as answer by Dave Panulaya Tuesday, March 22, 2016 3:37 AM
    Monday, March 21, 2016 12:34 PM
  • Hi Dave,

    When we create the Web App service use the App Service + MySQL template, which will require us to create a new MySQL service or associate an existing one, it will generate the database connection string automatically in "App Settings". 

    And you can try to find t he connection string in MySQL service portal:

    Any concern, please feel free to let me know.

    • Marked as answer by Dave Panulaya Tuesday, March 22, 2016 3:37 AM
    Tuesday, March 22, 2016 2:22 AM
    Moderator

All replies

  • Hi,

    The article which you followed is for free azure student account, when you need to have a azure student account.

    If you are already using the same account, then please let us know what is the complete error message do you get.

    Also check this article:
    https://azure.microsoft.com/en-in/documentation/articles/store-php-create-mysql-database/

    Regards,
    Azam khan

    • Marked as answer by Dave Panulaya Tuesday, March 22, 2016 3:37 AM
    Monday, March 21, 2016 12:34 PM
  • Hi Dave,

    When we create the Web App service use the App Service + MySQL template, which will require us to create a new MySQL service or associate an existing one, it will generate the database connection string automatically in "App Settings". 

    And you can try to find t he connection string in MySQL service portal:

    Any concern, please feel free to let me know.

    • Marked as answer by Dave Panulaya Tuesday, March 22, 2016 3:37 AM
    Tuesday, March 22, 2016 2:22 AM
    Moderator
  • Good day Sir,

    I have already solved my question, I was just lost regarding where to look at and found the connection string which I already did to connect it to MySQL Workbench. 

    Thank you very much for giving the time to answer.

    Regards,

    Dave

    Tuesday, March 22, 2016 3:41 AM
  • Good day,

    I was actually using a different account which was given by my company.

    The issue was already answered and the article you provided me made it more precise that I was actually on the right track.

    Thank you very much for your time in answering.

    Regards,

    Dave

    Tuesday, March 22, 2016 3:46 AM