{"id":132502,"date":"2023-03-16T12:48:23","date_gmt":"2023-03-16T12:48:23","guid":{"rendered":"https:\/\/phppot.com\/?p=20579"},"modified":"2023-03-16T12:48:23","modified_gmt":"2023-03-16T12:48:23","slug":"phpmyadmin-how-to-connect-a-remote-database","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2023\/03\/16\/phpmyadmin-how-to-connect-a-remote-database\/","title":{"rendered":"phpMyAdmin \u2013 How to Connect a Remote Database?"},"content":{"rendered":"
by Vincy<\/a>. Last modified on March 16th, 2023.<\/div>\n

Do you want to connect a remote server from the phpMyAdmin installed on a local or test server? This article gives the steps needed to achieve it.<\/p>\n

There are many database clients, most of which support connecting a database server. But, working with phpMyAdmin to connect to a remote database server is heavenly easier than with other clients.<\/p>\n

We have seen many tutorials for phpMyAdmin to create a database<\/a> and perform the operations around it.<\/p>\n

Configure remote server details in the phpMyAdmin application config file<\/h2>\n

A configuration file config.inc.php<\/code> is there for the phpMyAdmin application. Open that file and add the below settings into it.<\/p>\n

This setting is to add the remote database details, host, username, and password. The database port is optional if it is the default.<\/p>\n

Before setting the database details, it increments the existing config array index. We can add as many configurations as following the current batch of settings.<\/p>\n

$i++;\n$cfg['Servers'][$i]['host'] = 'DATABASE_HOST:PORT';\/\/set the database hostname.\n$cfg['Servers'][$i]['user'] = 'DATABASE_USER';\/\/ set the remote database user\n$cfg['Servers'][$i]['password'] = 'DATABASE_PASSWORD';\/\/ database password\n$cfg['Servers'][$i]['auth_type'] = 'config';\n<\/code><\/pre>\n
After adding these details, the phpMyAdmin application lists the configured database hostnames.<\/p>\n
The list is a dropdown of selectable database hosts that appears above the left navigation menu.<\/p>\n
The below figure shows the dropdown options of the current localhost and the RemoteHost server.<\/p>\n
It allows navigation between these two database servers to manage their assets.<\/p>\n
Note:<\/strong> The RemoteHost:port is a test configuration data. Replace it with the remote database IP and port to be connected.<\/p>\n
\"phpmyadmin<\/p>\n
These guidelines assume that you have the PHP and MySQL environment with the phpMyAdmin application installed.<\/p>\n
If you newly create the environment or install the phpMyAdmin, ensure the required privileges and security measures. We have seen steps to install phpMyAdmin on a windows<\/a> machine via the WAMP package installer.<\/p>\n
Security measures needed for the machine connecting the remote database<\/h2>\n
(1) Use a Linux environment<\/h3>\n
Before connecting the remote database via phpMyAdmin, we must be confident about the security.<\/p>\n
Linux-based machines are safe for proceeding with the remote connection.<\/p>\n
If you are using a Windows machine, there are settings to enable WSL to let it be secure while working with the remote database servers.<\/p>\n
(2) Let login configuration empty<\/h3>\n
When setup the remote database server configuration, let the username and password empty.<\/p>\n
Set only the remote database server IP address to show in the phpMyAdmin web interface.<\/p>\n
Choosing the remote server to connect will redirect to the phpMyAdmin login panel to enter the details.<\/p>\n
Directly access the remote phpMyAdmin web application URL<\/h2>\n
If you know the URL of the phpMyAdmin web application installed on the remote server, we can visit and land on its login page.<\/p>\n
The login page prompts the MySQL database host, username, and password. Entering and submitting these details allows access to the remote database.<\/p>\n
Thus, we have seen the possible ways of connecting the remote database server using the phpMyAdmin application.<\/p>\n
  <\/p>\n
\n
Popular Articles<\/h2>\n<\/p><\/div>\n
 \u2191 Back to Top<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"
by Vincy. Last modified on March 16th, 2023. Do you want to connect a remote server from the phpMyAdmin installed on a local or test server? This article gives the steps needed to achieve it. There are many database clients, most of which support connecting a database server. But, working with phpMyAdmin to connect to […]<\/p>\n","protected":false},"author":2,"featured_media":132503,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-132502","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php-updates"],"_links":{"self":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/132502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/comments?post=132502"}],"version-history":[{"count":0,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/132502\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media\/132503"}],"wp:attachment":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media?parent=132502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/categories?post=132502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/tags?post=132502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}