{"id":5880,"date":"2014-09-02T00:00:00","date_gmt":"2014-09-02T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites"},"modified":"2025-09-12T13:22:25","modified_gmt":"2025-09-12T20:22:25","slug":"create-your-own-dedicated-mysql-server-for-your-azure-websites","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/","title":{"rendered":"Create your own dedicated MySQL Server for your Azure Websites"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">If you&#8217;re working on an LAMP or WAMP application and want to host it on Azure , Azure websites is the&nbsp;fastest and most reliable way to host your application on Azure. &nbsp;Azure Websites support PHP stacks and provides you with two great&nbsp;options for MySQL server :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Use ClearDB MySQL Service from Azure Store<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Use Azure Virtual Machine to set up your own MySQL Server<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">There are a couple of scenarios when you would want to use MySQL server Virtual machine running on Azure :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">You have special requirements for MySQL configuration and ClearDB service plans from the Store does not meet your needs<\/li>\n\n\n\n<li class=\"wp-block-list-item\">You want a MySQL server for development\/test purposes and reuse for multiple development\/staging sites<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The easiest way to spin up a MySQL server is&nbsp;by&nbsp;using Azure virtual machines. This will give you the flexibility to create your own scalable compute infrastructure when you need flexible resources. Azure management portal makes it easy to create a new Azure Virtual machine for both Windows and Linux distributions in just a few minutes. In this article I will show you how to perform the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Create a MySQL server on a Windows Azure VM<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Create a MySQL server on Linux Azure VM<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Create an Azure Website that can connect to your MySQL server<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"create-a-mysql-server-on-windows-azure-vm\">Create a MySQL server on Windows Azure VM<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Login to the\u00a0<a href=\"https:\/\/manage.windowsazure.com\/\">Azure Management Portal<\/a>\u00a0using your Azure account.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">In the Management Portal, at the bottom left of the web page, click\u00a0<strong>+New<\/strong>, click\u00a0<strong>Virtual Machine<\/strong>, and then click\u00a0<strong>Quick\u00a0Create.<\/strong><\/li>\n\n\n\n<li class=\"wp-block-list-item\">On the\u00a0<strong>Virtual machine configuration<\/strong>\u00a0page, provide the following information:\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Provide a\u00a0<strong>Virtual Machine Name<\/strong>, such as <em>windowsmyslsrv<\/em><\/li>\n\n\n\n<li class=\"wp-block-list-item\">Specify a\u00a0<strong>New User Name<\/strong>, such as <em>azureuser<\/em><\/li>\n\n\n\n<li class=\"wp-block-list-item\">In the\u00a0<strong>New Password<\/strong>\u00a0box, type a\u00a0<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms161962.aspx\">strong password<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">In the\u00a0<strong>Confirm Password<\/strong>\u00a0box, retype the password.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Select the appropriate\u00a0<strong>Size<\/strong>\u00a0from the drop down list.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">In the\u00a0<strong>Region\/Affinity Group\/Virtual Network<\/strong>\u00a0box, select a region where this virtual image will be hosted.<img loading=\"lazy\" decoding=\"async\" width=\"1452\" height=\"658\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/img1.webp\" alt=\"Create Windows Virtual Machine\"><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Now a&nbsp; Windows Server 2012 VM is created .&nbsp;To Install MySQL on your Windows VM, check out this article <a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/virtual-machines-mysql-windows-server-2008r2\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to install MySQL on Windows Azure VM<\/a>. The article focuses on Windows Server 2008 R2 however,&nbsp;the same process is applicable for any Windows Server VM from Azure Virtual machines.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"enable-remote-access\">Enable remote access<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The MySQL server does not allow remote access by default to the &#8220;root&#8221; user. To enable this you need to create a new HOST for root and allow root to login from anywhere.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nmysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'\n> IDENTIFIED BY 'password' WITH GRANT OPTION;\nmysql> FLUSH PRIVILEGES;\nmysql> exit\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Now that your MySQL server is configured, your Database host name for your Windows Azure VM is <em>windowsmysqlsrv.cloudapp.net:3306.<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Create a simple PHP application on Azure Web Sites as described in this article <a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/web-sites-php-create-web-sites\/\">How to create a PHP website\u00a0<\/a>\u00a0with an <strong>index.php<\/strong> file that tries to connect to a database on your MySQL server VM to test if your website can connect to your newly created MySQL server:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Note:<\/strong> If you see any error messages like &#8220;Access denied&#8221; or &#8220;Host &#8216;xxx.xx.xxx.xxx&#8217; is not allowed to connect to this MySQL server&#8221; ; check the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Firewall for port 3306 is open for both inbound and outbound connections<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">MySQL server is configured to allow remote connections for the user you are using to connect . Check the <em>mysql.host<\/em> table to check if the user is associated with &#8216;%&#8217;\u00a0\u00a0 wildcard for the host column to allow any remote IP .<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"create-a-mysql-server-on-linux-azure-vm\">Create a MySQL server on Linux Azure VM<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Login to the\u00a0<a href=\"https:\/\/manage.windowsazure.com\/\">Azure Management Portal<\/a>\u00a0using your Azure account.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">In the Management Portal, at the bottom left of the web page, click\u00a0<strong>+New<\/strong>, click\u00a0<strong>Virtual Machine<\/strong>, and then click\u00a0<strong>From Gallery<\/strong>.<br><img loading=\"lazy\" decoding=\"async\" width=\"1162\" height=\"500\" class=\"wp-image-8776\" style=\"width: 600px\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/Capture11.png\" alt=\"graphical user interface, text, application\"><\/li>\n\n\n\n<li class=\"wp-block-list-item\">Select an <strong>Ubuntu virtual<\/strong> machine image from\u00a0<strong>Platform Images<\/strong>, and then click the next arrow at the bottom right of the page.<br><img loading=\"lazy\" decoding=\"async\" width=\"1013\" height=\"634\" class=\"wp-image-8778\" style=\"width: 600px\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/Capture2.png\" alt=\"graphical user interface, text, application\"><\/li>\n\n\n\n<li class=\"wp-block-list-item\">On the\u00a0<strong>Virtual machine configuration<\/strong>\u00a0page, provide the following information:\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Provide a\u00a0<strong>Virtual Machine Name<\/strong>, such as <em>linuxmysqlsrv<\/em><\/li>\n\n\n\n<li class=\"wp-block-list-item\">You may choose to use SSH key or Username\/Password authentication for you virtual machine. For this tutorial I am going to use a Username\/Password method. Specify a\u00a0<strong>New User Name<\/strong>, such as <em>azureuser<\/em>, which will be added to the Sudoers list file.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">In the\u00a0<strong>New Password<\/strong>\u00a0box, type a\u00a0<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms161962.aspx\">strong password<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">In the\u00a0<strong>Confirm Password<\/strong>\u00a0box, retype the password.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Select the appropriate\u00a0<strong>Size<\/strong>\u00a0from the drop down list.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Click the next arrow to continue.<br><img loading=\"lazy\" decoding=\"async\" width=\"1013\" height=\"632\" class=\"wp-image-8780\" style=\"width: 150px\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/Capture3.png\" alt=\"text\"><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li class=\"wp-block-list-item\">On\u00a0the\u00a0<strong>Virtual machine mode<\/strong>\u00a0page, provide the following information:\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Select\u00a0<strong>Standalone Virtual Machine<\/strong>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">In the\u00a0<strong>DNS Name<\/strong>\u00a0box, type a valid DNS address. For example, <em>linuxmysqlsrv<\/em><\/li>\n\n\n\n<li class=\"wp-block-list-item\">In the\u00a0<strong>Region\/Affinity Group\/Virtual Network<\/strong>\u00a0box, select a region where this virtual image will be hosted.Click the next arrow to continue.<br><img loading=\"lazy\" decoding=\"async\" width=\"1264\" height=\"809\" class=\"wp-image-8782\" style=\"width: 600px\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/Capture4.png\" alt=\"graphical user interface, text, application\"><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Wait while Azure prepares your virtual machine.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Once the virtual machine is created, you must configure endpoints in order to remotely connect. By default, the Azure installer creates an SSH endpoint on the public port 22 so that you can connect to the machine.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"connect-to-the-virtual-machine\">Connect to the Virtual Machine<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When the virtual machine has been provisioned and the endpoints configured, you can connect to it using SSH (Linux) or <a href=\"https:\/\/www.putty.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">PuTTY<\/a>\u00a0(Windows).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"connecting-using-ssh\">Connecting Using SSH<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you are using a linux computer, connect to the VM using SSH. At the command prompt, run:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n ssh newuser@testlinuxvm.cloudapp.net -o ServerAliveInterval=180\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Enter the machine user\u2019s password when prompted to gain access to your virtual machine.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"connecting-using-putty\">Connecting using PuTTY<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you are using a Windows computer, connect to the VM using PuTTY. PuTTY can be downloaded from the\u00a0PuTTY Download Page.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Download and save\u00a0<strong>putty.exe<\/strong>\u00a0to a directory on your computer. Open a command prompt, navigate to that folder, and execute<strong>putty.exe<\/strong>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Enter &#8220;<em>linuxmysqlsrv.cloudapp.net<\/em>&#8221; for the\u00a0<strong>Host Name<\/strong>\u00a0and &#8220;<em>22&#8243;<\/em> for the\u00a0<strong>Port<\/strong>.<\/li>\n<\/ol>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/Capture8.webp\" alt=\"graphical user interface, application\" class=\"wp-image-8784 webp-format\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/Capture8.webp\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"update-the-virtual-machine\">Update the Virtual Machine<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Once you&#8217;ve connected to the virtual machine, you can optionally install system updates and patches. Run:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n sudo apt-get update\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"install-mysql-server-5-on-ubuntu\">Install MySQL Server 5 on Ubuntu<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Installing MySQL 5 Server&nbsp;on Ubuntu is a quick and easy process. It almost feels like it should be more difficult.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Open a terminal window, and use the following command:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsudo apt-get install mysql-server\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">You would also need a MySQL client , so in a terminal window run the following command:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsudo apt-get install mysql-client\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">This will install MySQL server and to check the status of your server run the following command:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsudo service mysql status\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"connecting-to-mysql-using-an-ssh-tunnel\">Connecting to MySQL Using an SSH Tunnel<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Secure Shell, or SSH, is used to create a secure channel between a local and remote computer. While SSH is commonly used for secure terminal access and file transfers, it can also be used to create a secure tunnel between computers for forwarding other network connections that are not normally encrypted. SSH tunnels are also useful for allowing outside access to internal network resources. SSH opens a local port and seamlessly transferring all of the communication over that port through to MySQL running on your server; making it look like MySQL server is running on local system.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To create an SSH tunnel on your Ubuntu VM, you can run the command line SSH command with the&nbsp;-L&nbsp;to enable local port forwarding.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Open port 3306 port is not opened by default, hence you need to first open this port so a remote client can connect to your MySQL Server. Run the following command to open TCP port 3306<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\niptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Now let\u2019s check if the port 3306 is open by running this command:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsudo netstat -anltp|grep :3306\n<\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Create a SSH tunnel for port 3307<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsudo ssh -fNg -L 3307:127.0.0.1:3306 azurevmuser@servername\n<\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Create an endpoint for the port 3307 in the dashboard of the VM in Azure management\u00a0portal. For more details , See\u00a0<a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/virtual-machines-set-up-endpoints\/\">how to add endpoint to you Virtual machine\u00a0<\/a>\u00a0.Now your Database host name is<em>\u00a0linuxmysqlsrv.cloudapp.net:3307<\/em><\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/img3.webp\" alt=\"timeline\" class=\"wp-image-8786 webp-format\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/img3.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You can enable Direct Access to your MySQL from Remote Systems which I will not cover in this tutorial because this is <strong>NOT A\u00a0RECOMMENDED<\/strong> solution to connect to your MySQL server since allowing direct access to MySQL increases the risk of your server being compromised by attackers. MySQL does not use secure connections by default, so please refer to SSL with MySQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"create-a-php-website-that-can-connect-to-your-mysql-server\">Create a PHP Website that can connect to your MySQL server<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When you create a website in the Azure Management Portal, you have three options: Quick Create, Create with Database, and From Gallery. The instructions below will cover the Quick Create option. For information about the other two options, see Create a PHP-MySQL Azure web site and deploy using Git and Create a WordPress web site from the gallery in Azure. Here I will show you to create a simple site and add a simple PHP script to connect to the database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Create a simple PHP application \u00a0on Azure Web Sites as described in this article\u00a0<a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/web-sites-php-create-web-sites\/\">How to create a PHP website\u00a0<\/a>\u00a0with an\u00a0<strong>index.php<\/strong>\u00a0file that tries to connect to a database on you MySQL server Linux VM to test you website can connect with the newly created MySQL server:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Clear DB service or Azure Virtual machines can both\u00a0provide you the benefit of using MySQL with Azure Websites. Understand your requirements for the Database and choose the best solution that fits your needs.<\/p>\n\n\n<pre class=\"prettyprint\">\u00a0<\/pre>\n<p>\u00a0<\/p>","protected":false},"excerpt":{"rendered":"<p>If you are working on an LAMP or WAMP application and want to host it on Azure , Azure websites is the fastest and most reliable way to host your application on Azure.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473],"tags":[],"audience":[3057,3055,3056],"content-type":[1511],"product":[2913],"tech-community":[],"topic":[],"coauthors":[1019],"class_list":["post-5880","post","type-post","status-publish","format-standard","hentry","category-databases","audience-data-professionals","audience-developers","audience-it-implementors","content-type-best-practices","product-azure-database-for-mysql","review-flag-1680286581-295","review-flag-1680286581-364","review-flag-1-1680286581-825","review-flag-5-1680286581-950","review-flag-anywh-1680286580-635","review-flag-new-1680286579-546","review-flag-vm-1680286585-143"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Create your own dedicated MySQL Server for your Azure Websites | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"If you are working on an LAMP or WAMP application and want to host it on Azure , Azure websites is the fastest and most reliable way to host your application on Azure.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create your own dedicated MySQL Server for your Azure Websites | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"If you are working on an LAMP or WAMP application and want to host it on Azure , Azure websites is the fastest and most reliable way to host your application on Azure.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2014-09-02T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-12T20:22:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/img1.webp\" \/>\n<meta name=\"author\" content=\"Sunitha Muthukrishna\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sunitha Muthukrishna\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/sunitha-muthukrishna\/\",\"@type\":\"Person\",\"@name\":\"Sunitha Muthukrishna\"}],\"headline\":\"Create your own dedicated MySQL Server for your Azure Websites\",\"datePublished\":\"2014-09-02T00:00:00+00:00\",\"dateModified\":\"2025-09-12T20:22:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/\"},\"wordCount\":1498,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/img1.webp\",\"articleSection\":[\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/\",\"name\":\"Create your own dedicated MySQL Server for your Azure Websites | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/img1.webp\",\"datePublished\":\"2014-09-02T00:00:00+00:00\",\"dateModified\":\"2025-09-12T20:22:25+00:00\",\"description\":\"If you are working on an LAMP or WAMP application and want to host it on Azure , Azure websites is the fastest and most reliable way to host your application on Azure.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Create your own dedicated MySQL Server for your Azure Websites\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create your own dedicated MySQL Server for your Azure Websites | Microsoft Azure Blog","description":"If you are working on an LAMP or WAMP application and want to host it on Azure , Azure websites is the fastest and most reliable way to host your application on Azure.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/","og_locale":"en_US","og_type":"article","og_title":"Create your own dedicated MySQL Server for your Azure Websites | Microsoft Azure Blog","og_description":"If you are working on an LAMP or WAMP application and want to host it on Azure , Azure websites is the fastest and most reliable way to host your application on Azure.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2014-09-02T00:00:00+00:00","article_modified_time":"2025-09-12T20:22:25+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/img1.webp","type":"","width":"","height":""}],"author":"Sunitha Muthukrishna","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Sunitha Muthukrishna","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/sunitha-muthukrishna\/","@type":"Person","@name":"Sunitha Muthukrishna"}],"headline":"Create your own dedicated MySQL Server for your Azure Websites","datePublished":"2014-09-02T00:00:00+00:00","dateModified":"2025-09-12T20:22:25+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/"},"wordCount":1498,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/img1.webp","articleSection":["Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/","name":"Create your own dedicated MySQL Server for your Azure Websites | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/09\/img1.webp","datePublished":"2014-09-02T00:00:00+00:00","dateModified":"2025-09-12T20:22:25+00:00","description":"If you are working on an LAMP or WAMP application and want to host it on Azure , Azure websites is the fastest and most reliable way to host your application on Azure.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/create-your-own-dedicated-mysql-server-for-your-azure-websites\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Create your own dedicated MySQL Server for your Azure Websites"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/5880","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=5880"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/5880\/revisions"}],"predecessor-version":[{"id":46207,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/5880\/revisions\/46207"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=5880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=5880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=5880"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=5880"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=5880"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=5880"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=5880"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=5880"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=5880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}