{"id":1199,"date":"2021-04-07T16:05:42","date_gmt":"2021-04-07T13:05:42","guid":{"rendered":"https:\/\/www.scalahosting.com\/kb\/?p=1199"},"modified":"2022-03-09T14:35:07","modified_gmt":"2022-03-09T12:35:07","slug":"what-is-my-mysql-server-hostname","status":"publish","type":"post","link":"https:\/\/www.scalahosting.com\/kb\/what-is-my-mysql-server-hostname\/","title":{"rendered":"What is My MySQL Server Hostname?"},"content":{"rendered":"

Like humans, computers also require unique names to be individually addressed. These unique addresses enable them to communicate with each other on a network and share files.\u00a0<\/span><\/p>\n

The names also help people identify<\/span> the individual computers in a network.<\/b><\/p>\n

The advent of the internet and the explosion in the number of connected computers have placed much need on hostnames. It assigns a uniquely identifiable name to each computer and also serves as an identification of where MySQL databases<\/strong><\/span> reside.<\/b><\/p>\n

This article will explore what a hostname is and how to find a <\/span>MySQL server hostname<\/b>.<\/span><\/p>\n

Let\u2019s get started.<\/span><\/p>\n

What is a Server Hostname?<\/b><\/h2>\n

A server hostname is a unique identifier that serves as the name of a host computer. It could consist of numbers and alphabets, and it\u2019s usually less than<\/span> 255 characters.<\/b><\/p>\n

IP addresses help identify computers and servers. These strings of numbers are not easily memorable, so hostnames assign names to these IP addresses so that people don\u2019t have to memorize those long numbers.<\/span><\/p>\n

They are name resolution for <\/b>IP addresses<\/b><\/a>.<\/b> And they\u2019re not the same as a domain name.<\/span><\/p>\n

The latter is the address people type in the browser when visiting the website. It consists of two or more labels. The left and right labels concatenate and a dot delimits them, for example, www.scalahosting.com.<\/span><\/p>\n

The right-hand side label <\/span>com<\/span><\/i> is the top-level domain, while the left label, <\/span>scalahosting<\/span><\/i> is the sub-domain of <\/span>com<\/span><\/i>. Each label to the left delimited by a dot is a sub-domain of the domain to the right. Of course,<\/span> sub-domains are also domains but are subordinate to their parent domains.<\/b><\/p>\n

The next component beyond these levels specifies<\/span> the host server.<\/b><\/p>\n

For instance, the <\/span>www <\/span><\/i>in our example denotes that the domain name is on a World Wide Web host server. <\/span>The hostname identifies the servers that connect to the WWW.\u00a0<\/b><\/p>\n

A hostname is a domain name with at least one associated IP address, but a valid domain name is not necessarily a valid hostname.<\/span><\/p>\n

How to Find a MySQL Server Hostname<\/b><\/h2>\n

MySQL Server hostname defines the location of a MySQL database. Connecting to your database requires that you specify <\/span>the MySQL hostname to enable the program to know where to look.<\/b><\/p>\n

Let’s see how you can find your MySQL hostname.<\/p>\n

The easiest way to find<\/span> your MySQL server hostname is by checking your phpMyAdmin web interface \u2014<\/b> phpMyAdmin is free software that helps people administer their MySQL and MariaDB databases through a browser-based graphic interface.\u00a0<\/span><\/p>\n

And here\u2019s how to find you<\/span>r MySQL server hostname via phpMyAdmin.<\/b><\/p>\n

Log in to your control panel. Below, you can see screenshots of ScalaHosting’s<\/span> SPanel<\/span><\/a> – out proprietary all-in-one management platform designed for VPS solutions. In this case, you’ll need to log into SPanel’s User Interface.<\/span><\/p>\n

\"What<\/p>\n

When logged in, locate the phpMyAdmin tool on the Databases section on the homepage.<\/span><\/p>\n

\"What<\/p>\n

SPanel will log you in automatically.
\n<\/span><\/p>\n

Once you’re in in, you could see<\/span> the MySQL version on the panel\u2019s right side<\/b>, under the Database Server section.<\/span><\/p>\n

\"What<\/p>\n

Here\u2019s what you\u2019d see when you zoom into the right-hand panel of the above image.<\/span><\/p>\n

\"What<\/p>\n

As you could see, the MySQL server hostname is <\/span>Localhost<\/b>. Localhost means the MySQL database is running on the same server as the website.<\/span><\/p>\n

If you use <\/span>WordPress<\/span><\/a>, you can also check the MySQL database hostname in the <\/span>wp-config.php<\/span><\/i> file.<\/span><\/p>\n

Here\u2019s <\/span>how to locate this file.<\/b><\/p>\n

Log in to your SPanel’s User Interface and open the <\/span>File manager<\/b> located under the Files section.<\/span><\/p>\n

\"What<\/p>\n

Click on the <\/span>public_html <\/b>folder to open the files in this directory.<\/span><\/p>\n

\"What<\/p>\n

Scroll down until you locate the <\/span>wp-config.php<\/b> file and click on it and select <\/span>Edit<\/b> to open the file.<\/span><\/p>\n

\"What<\/p>\n

You\u2019ll see the server hostname under <\/span>\/** MySQL hostname *\/<\/b><\/p>\n

\"What<\/p>\n

As you can see, the hostname is <\/span>\u201cLocalhost.\u201d<\/b><\/p>\n

Wrapping It Up<\/b><\/h2>\n

In most cases the website’s files and its databases are hosted on the same server. That’s why, you often see localhost<\/strong> as the hostname for the MySQL server. However, sometimes, you may end up with a setup that needs a separate machine for the databases. In such cases, it’s a good idea to know where to find the hostname.<\/p>\n

Feel free to contact our technical support specialists if you have any further problems locating it.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Like humans, computers also require unique names to be individually addressed. These unique addresses enable them to communicate with each other on a network and share files.\u00a0 The names also help people identify the individual computers in a network. The advent of the internet and the explosion in the number of connected computers have placed […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","_seopress_news_disabled":"","_seopress_video_disabled":"","_seopress_video":[],"_seopress_pro_schemas_manual":[],"_seopress_pro_rich_snippets_disable_all":"","_seopress_pro_rich_snippets_disable":[],"_seopress_pro_schemas":[],"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1199","post","type-post","status-publish","format-standard","hentry","category-web-hosting"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/posts\/1199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/comments?post=1199"}],"version-history":[{"count":2,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/posts\/1199\/revisions"}],"predecessor-version":[{"id":3797,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/posts\/1199\/revisions\/3797"}],"wp:attachment":[{"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/media?parent=1199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/categories?post=1199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/tags?post=1199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}