{"id":10226,"date":"2026-01-08T04:26:26","date_gmt":"2026-01-08T04:26:26","guid":{"rendered":"https:\/\/ubiq.co\/tech-blog\/?p=10226"},"modified":"2026-01-26T06:14:27","modified_gmt":"2026-01-26T06:14:27","slug":"enable-remote-access-mysql","status":"publish","type":"post","link":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/","title":{"rendered":"How to Enable Remote Access in MySQL"},"content":{"rendered":"\n<p>MySQL is used by many organizations and websites around the world. Often database administrators need to set up multi-user MySQL environments where different users are able to access data from different locations using different devices. In such cases, they need to create remote users to MySQL database. In this article, we will learn how to enable remote access in MySQL.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#What_is_Remote_Access\" >What is Remote Access?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#Enable_Remote_Access_in_MySQL\" >Enable Remote Access in MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#1_Configure_MySQL_Server\" >1. Configure MySQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#2_Create_Remote_User\" >2. Create Remote User<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#3_Open_Firewall_Port\" >3. Open Firewall Port<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#4_Test_Remote_Access\" >4. Test Remote Access<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#Key_Points\" >Key Points<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_Remote_Access\"><\/span>What is Remote Access?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Remote Access means when a user accesses database from a different IP address other than that of the database server. In simple terms, they are accessing database from a different machine other than the server. This machine may be a workstation, laptop or a mobile device. For example, a user accessing an office database from home desktop is a remote user. In today&#8217;s distributed working environment, with remote work on the rise, it has become essential to allow remote access to databases. Such access is commonly required in <a href=\"https:\/\/ubiq.co\/business-intelligence-software-tools\">business intelligence and reporting systems<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Enable_Remote_Access_in_MySQL\"><\/span>Enable Remote Access in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>There are three parts to enabling remote access in MySQL &#8211; Configure MySQL server to accept remote connections, create remote MySQL user and open firewall port 3306.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Configure_MySQL_Server\"><\/span>1. Configure MySQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>By default, MySQL Server listens to only localhost (127.0.0.1) for security reasons. We need to modify this setting so that it listens to requests from other IP addresses also. For this, open MySQL configuration file in a text editor. This file is located at \/etc\/mysql\/my.cnf or \/etc\/mysql\/mysql.conf.d\/mysqld.conf<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo vi \/etc\/mysql\/my.cnf<\/pre>\n\n\n\n<p>Next, locate the following line.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">bind-address=127.0.0.1<\/pre>\n\n\n\n<p>In the above line, replace 127.0.0.1 with the specific remote IP address that you want your MySQL server to listen to. Or you can replace it with 0.0.0.0 so that it listens to queries from all IP addresses. <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">bind-address=0.0.0.0<\/pre>\n\n\n\n<p>Save and close the file. Restart MySQL server to apply changes.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo service mysql restart<br>OR<br>sudo systemctl restart mysql<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Create_Remote_User\"><\/span>2. Create Remote User<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Next, we create a specific remote user. We have assumed that you are still logged into your MySQL console.<\/p>\n\n\n\n<p>Run the following query to create a new user that will send requests from IP 12.23.34.45. Replace test_user and test_pass with username and password of your choice.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE USER 'test_user'@'12.23.34.45' IDENTIFIED BY 'test_pass';<\/pre>\n\n\n\n<p>Run the following query to grant several permissions such as SELECT, INSERT, UPDATE, etc. to this new user.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">GRANT SELECT, INSERT, UPDATE, DELETE on my_database.* to 'test_user'@'12.23.34.45';<\/pre>\n\n\n\n<p>Run the following command to apply changes.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">FLUSH PRIVILEGES;<\/pre>\n\n\n\n<p>We have covered a very generic case of a remote user from a specific IP address who has multiple privileges on your database. Here are some common use cases required by organizations. You can implement them by modifying the above commands.<\/p>\n\n\n\n<p>Often database administrators need to <a href=\"https:\/\/ubiq.co\/tech-blog\/create-read-only-mysql-user\/\">allow read only access<\/a> for a remote user from a single IP address (e.g. 45.56.67.78). In such cases, run the following queries to create a remote user<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE USER 'test_user'@'45.56.67.78' IDENTIFIED BY 'test_pass';<br>GRANT SELECT, SHOW VIEW on my_database.* to 'test_user'@'45.56.67.78';<br>FLUSH PRIVILEGES;<\/pre>\n\n\n\n<p>Sometimes, you may need to allow a remote user to access your database from all IP addresses. In such cases, replace the IP address in above queries with %. Please note, do this only if you absolutely need it because it will open your system to all IPs.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE USER 'test_user'@'<strong>%<\/strong>' IDENTIFIED BY 'test_pass';<br>GRANT SELECT, SHOW VIEW on my_database.* to 'test_user'@'<strong>%<\/strong>';<br>FLUSH PRIVILEGES;<\/pre>\n\n\n\n<p>In the above examples, we have given remote access to all tables of our database. If you want to give read only access to one table, then specify in your GRANT query as shown. Replace table_name with the name of your table. <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE USER 'test_user'@'45.56.67.78' IDENTIFIED BY 'test_pass';<br>GRANT SELECT, SHOW VIEW on my_database.<strong>table_name<\/strong> to 'test_user'@'45.56.67.78';<br>FLUSH PRIVILEGES;<\/pre>\n\n\n\n<p>If you want to allow access to multiple tables and databases, then run a separate GRANT query for each table and database as shown.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE USER 'test_user'@'45.56.67.78' IDENTIFIED BY 'test_pass';<br>GRANT SELECT, SHOW VIEW on my_database1.table1_name to 'test_user'@'45.56.67.78';<br>GRANT SELECT, SHOW VIEW on my_database2.table2_name to 'test_user'@'45.56.67.78';<br>FLUSH PRIVILEGES;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Open_Firewall_Port\"><\/span>3. Open Firewall Port<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>By default, port 3306 is blocked on all systems for remote connections, thanks to the operating system firewall on the server. This is true even if you have enabled MySQL server to accept remote connections. So you will need to modify firewall rules to open port 3306. You can do this using UFW firewall or iptables service as shown.<\/p>\n\n\n\n<p><strong>Using UFW<\/strong> <\/p>\n\n\n\n<p>Here is the command to open port 3306 using UFW service.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo ufw allow from 12.23.34.45 to any port 3306<\/pre>\n\n\n\n<p><strong>Using iptables<\/strong><\/p>\n\n\n\n<p>Here is the command to accept remote connections using iptables service.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo iptables -A INPUT -p tcp -s 12.23.34.45 --dport 3306 -j ACCEPT<\/pre>\n\n\n\n<p>If your server is running on cloud service providers such as AWS, Azure, Cloudflare, etc. then opening port using Linux firewall service is not enough. You need to also open the port on the firewall management panel of cloud service provider by adding inbound traffic rules for port 3306, from specific IP addresses.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_Test_Remote_Access\"><\/span>4. Test Remote Access<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Log in to your MySQL server from MySQL client located at 12.23.34.45. Replace server_ip with the IP address of your MySQL server. You will be prompted for password. Enter password to proceed.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql -u test_user -h server_ip -p<\/pre>\n\n\n\n<p>On successful login, you will see mysql&gt; prompt.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt;<\/pre>\n\n\n\n<p>Now you can start running queries from remote client.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Key_Points\"><\/span>Key Points<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>You have to be very careful while allowing remote access to database. Here are some things to keep in mind while doing so.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Allow remote access from specific IP address or a group of IP addresses. Do not allow remote users to access your data from all IP addresses, by mentioning % in your CREATE USER statement.<\/li>\n\n\n\n<li>If your users do not need remote access any more, revoke it. Similarly, if your users leave a project team or the company itself, then revoke their access. Database administrators to regularly check if remote access is needed by their users.<\/li>\n\n\n\n<li>Some users have a habit of sharing username and passwords. If this happens in case of remote users, it is more dangerous since it can easily fall into the hands of unknown people. So it is advisable to periodically change remote username and password.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this article, we have learnt how to enable remote access in MySQL. It is very important for database administrators to understand this when they <a href=\"https:\/\/ubiq.co\/tech-blog\/top-5-online-resources-to-learn-mysql\/\">learn MySQL<\/a>. We have learnt what is remote access and why it is needed. We have learnt how to configure the MySQL server to accept remote connections, how to create a remote user and also how to test remote access. You can customize these steps as per your requirement.<\/p>\n\n\n\n<p>Also read:<br><a href=\"https:\/\/ubiq.co\/tech-blog\/create-read-only-mysql-user\/\">How to Create Read Only MySQL User<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-increase-max-connections-in-mysql\/\">How to Increase Max Connections in MySQL<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/unpivot-table-mysql\/\">How to Unpivot Table in MySQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Often database administrators need to allow remote users to access database. Here is how to enable remote access in MySQL.<\/p>\n","protected":false},"author":1,"featured_media":10252,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[324],"tags":[622],"class_list":["post-10226","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-remote-access-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Enable Remote Access in MySQL - Ubiq BI<\/title>\n<meta name=\"description\" content=\"Often database administrators need to allow remote users to access database. Here is how to enable remote access in MySQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Enable Remote Access in MySQL - Ubiq BI\" \/>\n<meta property=\"og:description\" content=\"Often database administrators need to allow remote users to access database. Here is how to enable remote access in MySQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Ubiq BI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ubiqbi\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-08T04:26:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-26T06:14:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2026\/01\/enable-remote-access-in-mysql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"288\" \/>\n\t<meta property=\"og:image:height\" content=\"192\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sreeram Sreenivasan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:site\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sreeram Sreenivasan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/\"},\"author\":{\"name\":\"Sreeram Sreenivasan\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"headline\":\"How to Enable Remote Access in MySQL\",\"datePublished\":\"2026-01-08T04:26:26+00:00\",\"dateModified\":\"2026-01-26T06:14:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/\"},\"wordCount\":997,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/enable-remote-access-in-mysql.jpg?fit=288%2C192&ssl=1\",\"keywords\":[\"remote access\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/\",\"name\":\"How to Enable Remote Access in MySQL - Ubiq BI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/enable-remote-access-in-mysql.jpg?fit=288%2C192&ssl=1\",\"datePublished\":\"2026-01-08T04:26:26+00:00\",\"dateModified\":\"2026-01-26T06:14:27+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"description\":\"Often database administrators need to allow remote users to access database. Here is how to enable remote access in MySQL.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/enable-remote-access-in-mysql.jpg?fit=288%2C192&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/enable-remote-access-in-mysql.jpg?fit=288%2C192&ssl=1\",\"width\":288,\"height\":192,\"caption\":\"enable remote access in mysql\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/enable-remote-access-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Enable Remote Access in MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\",\"name\":\"Ubiq BI\",\"description\":\"Build dashboards &amp; reports in minutes\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\",\"name\":\"Sreeram Sreenivasan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"caption\":\"Sreeram Sreenivasan\"},\"description\":\"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/sreeram-sreenivasan\\\/\"],\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/author\\\/wordpress\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Enable Remote Access in MySQL - Ubiq BI","description":"Often database administrators need to allow remote users to access database. Here is how to enable remote access in MySQL.","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:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/","og_locale":"en_US","og_type":"article","og_title":"How to Enable Remote Access in MySQL - Ubiq BI","og_description":"Often database administrators need to allow remote users to access database. Here is how to enable remote access in MySQL.","og_url":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/","og_site_name":"Ubiq BI","article_publisher":"https:\/\/www.facebook.com\/ubiqbi","article_published_time":"2026-01-08T04:26:26+00:00","article_modified_time":"2026-01-26T06:14:27+00:00","og_image":[{"width":288,"height":192,"url":"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2026\/01\/enable-remote-access-in-mysql.jpg","type":"image\/jpeg"}],"author":"Sreeram Sreenivasan","twitter_card":"summary_large_image","twitter_creator":"@UbiqBI","twitter_site":"@UbiqBI","twitter_misc":{"Written by":"Sreeram Sreenivasan","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#article","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/"},"author":{"name":"Sreeram Sreenivasan","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"headline":"How to Enable Remote Access in MySQL","datePublished":"2026-01-08T04:26:26+00:00","dateModified":"2026-01-26T06:14:27+00:00","mainEntityOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/"},"wordCount":997,"commentCount":0,"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2026\/01\/enable-remote-access-in-mysql.jpg?fit=288%2C192&ssl=1","keywords":["remote access"],"articleSection":["MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/","url":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/","name":"How to Enable Remote Access in MySQL - Ubiq BI","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#primaryimage"},"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2026\/01\/enable-remote-access-in-mysql.jpg?fit=288%2C192&ssl=1","datePublished":"2026-01-08T04:26:26+00:00","dateModified":"2026-01-26T06:14:27+00:00","author":{"@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"description":"Often database administrators need to allow remote users to access database. Here is how to enable remote access in MySQL.","breadcrumb":{"@id":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#primaryimage","url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2026\/01\/enable-remote-access-in-mysql.jpg?fit=288%2C192&ssl=1","contentUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2026\/01\/enable-remote-access-in-mysql.jpg?fit=288%2C192&ssl=1","width":288,"height":192,"caption":"enable remote access in mysql"},{"@type":"BreadcrumbList","@id":"https:\/\/ubiq.co\/tech-blog\/enable-remote-access-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ubiq.co\/tech-blog\/"},{"@type":"ListItem","position":2,"name":"How to Enable Remote Access in MySQL"}]},{"@type":"WebSite","@id":"https:\/\/ubiq.co\/tech-blog\/#website","url":"https:\/\/ubiq.co\/tech-blog\/","name":"Ubiq BI","description":"Build dashboards &amp; reports in minutes","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ubiq.co\/tech-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc","name":"Sreeram Sreenivasan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","caption":"Sreeram Sreenivasan"},"description":"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.","sameAs":["https:\/\/www.linkedin.com\/in\/sreeram-sreenivasan\/"],"url":"https:\/\/ubiq.co\/tech-blog\/author\/wordpress\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2026\/01\/enable-remote-access-in-mysql.jpg?fit=288%2C192&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/pbGGTT-2EW","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/10226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/comments?post=10226"}],"version-history":[{"count":30,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/10226\/revisions"}],"predecessor-version":[{"id":10431,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/10226\/revisions\/10431"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media\/10252"}],"wp:attachment":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media?parent=10226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/categories?post=10226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/tags?post=10226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}