{"id":47968,"date":"2024-03-06T12:30:00","date_gmt":"2024-03-06T18:30:00","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=47968"},"modified":"2024-02-20T03:26:50","modified_gmt":"2024-02-20T09:26:50","slug":"how-to-log-into-remote-mysql-server","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/","title":{"rendered":"How to Log Into Remote MySQL Server"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/02\/how-to-log-into-remote-mysql-server.webp\" alt=\"how to log into remote MySQL server\" class=\"wp-image-48137\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/02\/how-to-log-into-remote-mysql-server.webp 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/02\/how-to-log-into-remote-mysql-server-300x169.webp 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/02\/how-to-log-into-remote-mysql-server-150x84.webp 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/02\/how-to-log-into-remote-mysql-server-768x432.webp 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>MySQL is the most popular database server &#8211; odds are your website is using MySQL to store its data. Sometimes we need to check or do other database related work on our website. The default configuration of MySQL server restricts access &#8211; only allowing connections from localhost, limiting connections solely to applications hosted on the same server. To enable remote access, we&#8217;ll have to modify the server settings to allow connections from external sources, adjust the permissions of the database user, configure the firewall, and so on. In this article, we will demonstrate how to log into remote MySQL server.<\/p>\n\n\n\n<!--more-->\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69ed5f3d7a683\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><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><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69ed5f3d7a683\"  aria-label=\"Toggle\" \/><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:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#Step-1-Configure-Remote-MySQL-Server\" >Step 1. Configure Remote MySQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#Step-2-Create-MySQL-User\" >Step 2. Create MySQL User<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#Step-3-Log-into-Remote-MySQL-Server\" >Step 3. Log into Remote MySQL Server<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-1-Configure-Remote-MySQL-Server\"><\/span>Step 1. Configure Remote MySQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Before connecting to our remote MySQL server, we need to allow remote connections to it. This should be done at the remote MySQL server you want to connect to. First, we need to configure MySQL server to listen not only on localhost, but also on any available IP addresses. Let&#8217;s edit our <code>my.cnf<\/code> file.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo nano \/etc\/my.cnf<\/pre>\n\n\n\n<p>Please note that your MySQL configuration path might not be the same. Your MySQL configuration file could be loaded from <code>\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code> or <code>\/etc\/mysql\/mysql.conf.d\/mysqld.conf<\/code>, so make sure to edit the correct configuration file. <\/p>\n\n\n\n<p>Find <code>bind_address<\/code>, if it looks like this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">bind-address = 127.0.0.1<\/pre>\n\n\n\n<p>or<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">bind-address = localhost<\/pre>\n\n\n\n<p>We need to edit the value. Replace <code>127.0.0.1<\/code> or <code>localhost<\/code> with our MySQL server&#8217;s IP address or <code>0.0.0.0<\/code> if you want MySQL to be accessible from any IP address present on the server.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">bind-address = 0.0.0.0<\/pre>\n\n\n\n<p>If you are using MySQL version 8.0.13 and above or MariaDB version 10.11 and above, you can also combine multiple IP addresses if you want to choose only specific IP addresses or if you want to maintain access using localhost. For example:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">bind-address = x.x.x.x, 127.0.0.1<\/pre>\n\n\n\n<p>Replace x.x.x.x with the IP address that you want to allow MySQL to let connections in through.<\/p>\n\n\n\n<p>Save the changes then exit from the <code>nano<\/code> text editor. Keep in mind that every time we make changes to MySQL configuration file, we need to restart the MySQL service.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl restart mysql<\/pre>\n\n\n\n<p>or<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl restart mariadb<\/pre>\n\n\n\n<p>At this point, MySQL is listening on a specific IP address or all available IP addresses on your server, and not only localhost. If you have a firewall enabled, you should open port 3306 now. We have a handy guide on <a href=\"https:\/\/www.rosehosting.com\/blog\/how-to-open-ports-in-ubuntu-and-centos-using-iptables\/\" target=\"_blank\" rel=\"noreferrer noopener\">how to open ports using iptables<\/a> if you need help with that.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-2-Create-MySQL-User\"><\/span>Step 2. Create MySQL User<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To connect to a remote MySQL server, we need to have the database details. The details should be the database name, database username, and database user&#8217;s password. Let&#8217;s consider we already have a database called <strong>database_2024<\/strong>. We will create a new database user and its password. Let&#8217;s log in to the MySQL command line:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ mysql -u root -p<\/pre>\n\n\n\n<p>You will be prompted to type your MySQL root password. Once logged in, you will get into MySQL shell, like this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Welcome to the MariaDB monitor.  Commands end with ; or \\g.\nYour MariaDB connection id is 31\nServer version: 10.11.4-MariaDB-1~deb12u1 Debian 12\n\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nMariaDB [(none)]&gt;<\/pre>\n\n\n\n<p>Let&#8217;s run the commands below to create a new MySQL user:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE USER 'youruser'@'localhost' IDENTIFIED BY 'm0d1fyth15';<\/pre>\n\n\n\n<p>Please replace <code>m0d1fyth15<\/code> with a stronger password, like a password that does not contain any dictionary words. Next, let\u2019s say we want to give our new user the permission to access only the database &#8216;database_2024&#8217; on our MySQL server. We can do that by executing the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">GRANT ALL ON database_2024.* TO 'youruser'@'localhost';\nFLUSH PRIVILEGES;<\/pre>\n\n\n\n<p>Now, pay attention to the <code>'youruser'@'localhost'<\/code> part. If you want to give the access from an IP address like <code>123.123.123.123<\/code>, then you need to replace <code>'youruser'@'localhost'<\/code> with <code>'youruser'@'123.123.123.123'<\/code> &#8211; the command would look like this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE USER 'youruser'@'123.123.123.123' IDENTIFIED BY 'm0d1fyth15';\nGRANT ALL ON database_2024.* TO 'youruser'@'123.123.123.123';<\/pre>\n\n\n\n<p>Or, if you want to allow this user to login from any IP address, we can run this command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE USER 'youruser'@'%' IDENTIFIED BY 'm0d1fyth15';\nGRANT ALL ON database_2024.* TO 'youruser'@'%';<\/pre>\n\n\n\n<p>That&#8217;s it! You can run the flush privileges command once again.<\/p>\n\n\n\n<p>If you have a control panel on your server like cPanel or DirectAdmin, you can use their interface to create the MySQL user and whitelist\/allow the IP address you want to connect to MySQL from.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-3-Log-into-Remote-MySQL-Server\"><\/span>Step 3. Log into Remote MySQL Server <span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now that you have the credentials to connect to your remote MySQL server, we can execute this command below from another server.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ mysql -u youruser -h 1.2.3.4 -p<\/pre>\n\n\n\n<p>Replace <code>youruser<\/code> with your own MySQL username and replace <code>1.2.3.4<\/code> with your MySQL server IP address, the command above will ask for your password for the user <code>youruser<\/code>, you can type the password and hit ENTER. If your password is correct, you should be connected to your remote MySQL server now.<\/p>\n\n\n\n<p>If you are not familiar with the command line interface and prefer to use a MySQL client with graphical interface like MySQL Workbench, you can use your MySQL database credentials to connect to your remote MySQL server.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"805\" height=\"507\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/01\/connect-to-remote-mysql.jpg\" alt=\"\" class=\"wp-image-47969\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/01\/connect-to-remote-mysql.jpg 805w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/01\/connect-to-remote-mysql-300x189.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/01\/connect-to-remote-mysql-150x94.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/01\/connect-to-remote-mysql-768x484.jpg 768w\" sizes=\"(max-width: 805px) 100vw, 805px\" \/><\/figure>\n\n\n\n<p>Do you want to connect to your MySQL server through an SSH tunnel? If yes, you can check our blog post on <a href=\"https:\/\/www.rosehosting.com\/blog\/access-your-database-remotely-through-an-ssh-tunnel\/\" target=\"_blank\" rel=\"noreferrer noopener\">accessing your database remotely using an SSH tunnel<\/a>.<\/p>\n\n\n\n<p>Congratulations! You have just learned how to log into remote MySQL server. Hopefully, you have a better understanding of connecting to a remote MySQL server.<\/p>\n\n\n\n<p>Of course, you don&#8217;t have to follow this article and try to configure your server by hand. If you need connect to your MySQL server remotely and you are one of our Fully-Managed hosting customers, our Linux admins will help you configure everything for you and provide you with MySQL login credentials to use. Simply contact our expert admins through our live chat or submit a ticket in the client area. Our expert administrators are available 24\u00d77 and will take care of your request immediately.<\/p>\n\n\n\n<p>PS. If you liked this post, please consider sharing it with your friends on the social networks. Also, if you have any other ways of configuring remote access to a MySQL database, we&#8217;d love to hear it! Feel free to leave a reply below. Thanks!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL is the most popular database server &#8211; odds are your website is using MySQL to store its data. Sometimes &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Log Into Remote MySQL Server\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#more-47968\" aria-label=\"Read more about How to Log Into Remote MySQL Server\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":48137,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,2071,13],"tags":[296,39,65],"class_list":["post-47968","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-linux","category-tutorials","tag-mariadb","tag-mysql","tag-security","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Log Into Remote MySQL Server | RoseHosting<\/title>\n<meta name=\"description\" content=\"MySQL is super handy for storing data, especially on a separate server. Here&#039;s how to log into a remote MySQL server.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Log Into Remote MySQL Server\" \/>\n<meta property=\"og:description\" content=\"How to Log Into Remote MySQL Server | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-06T18:30:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/02\/how-to-log-into-remote-mysql-server.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"576\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\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:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Log Into Remote MySQL Server\",\"datePublished\":\"2024-03-06T18:30:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/\"},\"wordCount\":916,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/how-to-log-into-remote-mysql-server.webp\",\"keywords\":[\"mariadb\",\"mysql\",\"security\"],\"articleSection\":[\"Databases\",\"Linux\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/\",\"name\":\"How to Log Into Remote MySQL Server | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/how-to-log-into-remote-mysql-server.webp\",\"datePublished\":\"2024-03-06T18:30:00+00:00\",\"description\":\"MySQL is super handy for storing data, especially on a separate server. Here's how to log into a remote MySQL server.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/how-to-log-into-remote-mysql-server.webp\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/how-to-log-into-remote-mysql-server.webp\",\"width\":1024,\"height\":576,\"caption\":\"how to log into remote MySQL server\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-log-into-remote-mysql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Log Into Remote MySQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/RoseHosting\",\"https:\\\/\\\/x.com\\\/rosehosting\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/rosehosting\\\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\\\/\\\/www.rosehosting.com\",\"https:\\\/\\\/www.facebook.com\\\/rosehosting.helpdesk\"],\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/author\\\/jwilson\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Log Into Remote MySQL Server | RoseHosting","description":"MySQL is super handy for storing data, especially on a separate server. Here's how to log into a remote MySQL server.","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:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/","og_locale":"en_US","og_type":"article","og_title":"How to Log Into Remote MySQL Server","og_description":"How to Log Into Remote MySQL Server | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2024-03-06T18:30:00+00:00","og_image":[{"width":1024,"height":576,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/02\/how-to-log-into-remote-mysql-server.webp","type":"image\/webp"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Log Into Remote MySQL Server","datePublished":"2024-03-06T18:30:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/"},"wordCount":916,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/02\/how-to-log-into-remote-mysql-server.webp","keywords":["mariadb","mysql","security"],"articleSection":["Databases","Linux","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/","name":"How to Log Into Remote MySQL Server | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/02\/how-to-log-into-remote-mysql-server.webp","datePublished":"2024-03-06T18:30:00+00:00","description":"MySQL is super handy for storing data, especially on a separate server. Here's how to log into a remote MySQL server.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/02\/how-to-log-into-remote-mysql-server.webp","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2024\/02\/how-to-log-into-remote-mysql-server.webp","width":1024,"height":576,"caption":"how to log into remote MySQL server"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-log-into-remote-mysql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Log Into Remote MySQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/47968","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=47968"}],"version-history":[{"count":8,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/47968\/revisions"}],"predecessor-version":[{"id":48168,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/47968\/revisions\/48168"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/48137"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=47968"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=47968"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=47968"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}