{"id":31748,"date":"2020-03-27T15:35:08","date_gmt":"2020-03-27T20:35:08","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=31748"},"modified":"2022-06-03T03:33:05","modified_gmt":"2022-06-03T08:33:05","slug":"how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/","title":{"rendered":"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-32399\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg\" alt=\"\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database-150x75.jpg 150w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>In this tutorial we will guide you through the steps of installing WordPress on an <a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">Ubuntu 18.04 VPS<\/a> with all necessary components, such as Apache web server, PHP and MySQL\/MariaDB database server, and configure WordPress to use a database on a remote server.<\/p>\n<p><img decoding=\"async\" class=\"alignright size-full wp-image-32400\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/set-up-wordpress-cms-with-remote-database-server-easily-ubuntu.jpg\" alt=\"\" width=\"120\" height=\"120\" \/>WordPress is the most popular and most widely-used content management system (CMS). It is the CMS of choice for 26% of the entire web. It is based on PHP, and it stores its information in a MySQL database. The large amount of themes and plugins makes this CMS an excellent choice for someone that needs a user-friendly way to get their ideas onto a website that looks good. Let&#8217;s get started with the installation.<\/p>\n<p><!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-663dff9d70d1f\" 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-663dff9d70d1f\"  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-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#Prerequisites\" title=\"Prerequisites\">Prerequisites<\/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-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#Step-1-Log-in-and-Update-the-Server\" title=\"Step 1: Log in and Update the Server\">Step 1: Log in and Update the Server<\/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-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#Step-2-Install-Apache-Web-Server\" title=\"Step 2: Install Apache Web Server\">Step 2: Install Apache Web 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:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#Step-3-Install-PHP\" title=\"Step 3: Install PHP\">Step 3: Install PHP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#Step-4-Install-MySQL-on-the-Remote-Server\" title=\"Step 4: Install MySQL on the Remote Server\">Step 4: Install MySQL on the Remote Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#Step-5-Create-MySQL-Database-and-User\" title=\"Step 5: Create MySQL Database and User\">Step 5: Create MySQL Database and User<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#Step-6-Install-WordPress\" title=\"Step 6: Install WordPress\">Step 6: Install WordPress<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#Step-7-Create-an-Apache-Virtual-Host\" title=\"Step 7: Create an Apache Virtual Host\">Step 7: Create an Apache Virtual Host<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span><strong>Prerequisites<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Ubuntu 18.04 VPS + Remote database server<\/li>\n<li>PHP version 7.3 or newer.<\/li>\n<li>MySQL database version 5.6 or newer OR MariaDB version 10.1 or newer.<\/li>\n<li>HTTPS support<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Step-1-Log-in-and-Update-the-Server\"><\/span><strong>Step 1: Log in and Update the Server<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Log in to your Ubuntu 18.04 VPS via SSH as user root<\/p>\n<pre>ssh root@<span style=\"color: #ff0000;\">IP_Address<\/span> -p <span style=\"color: #ff0000;\">Port_number<\/span><\/pre>\n<p>Don&#8217;t forget to replace &#8216;<span style=\"color: #ff0000;\">IP_Address<\/span>&#8216; and &#8216;<span style=\"color: #ff0000;\">Port_number<\/span>&#8216; with the actual IP address of your server and the SSH port number.<\/p>\n<p>Once you are in, run the following commands to make sure that all installed packages on your server are updated to the latest available versions:<\/p>\n<pre>apt update &amp;&amp; apt upgrade<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-2-Install-Apache-Web-Server\"><\/span><strong>Step 2: Install Apache Web Server<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>We need to install a web server to serve WordPress&#8217; content. For this purpose, we will install and use Apache web server. It is available in the official Ubuntu repository and it can be easily installed using the apt package manager:<\/p>\n<pre>apt -y install apache2<\/pre>\n<p>Once the installation of the web server is completed, Apache should be automatically started. You can confirm this by checking its status<\/p>\n<pre>systemctl status apache2<\/pre>\n<p>Output:<\/p>\n<pre>apache2.service - The Apache HTTP Server\r\n   Loaded: loaded (\/lib\/systemd\/system\/apache2.service; enabled; vendor preset: enabled)\r\n  Drop-In: \/lib\/systemd\/system\/apache2.service.d\r\n           \u2514\u2500apache2-systemd.conf\r\n   Active: active (running) since Fri 2019-08-09 02:31:39 CST; 14min ago\r\n Main PID: 406 (apache2)\r\n    Tasks: 7 (limit: 1110)\r\n   CGroup: \/system.slice\/apache2.service\r\n           \u251c\u2500  407 \/usr\/sbin\/apache2 -k start\r\n           \u251c\u2500  423 \/usr\/sbin\/apache2 -k start\r\n           \u251c\u2500  426 \/usr\/sbin\/apache2 -k start\r\n           \u251c\u2500  427 \/usr\/sbin\/apache2 -k start\r\n           \u251c\u2500  428 \/usr\/sbin\/apache2 -k start\r\n<\/pre>\n<p>Enable Apache to automatically start after a server reboot<\/p>\n<pre>systemctl enable apache2<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-3-Install-PHP\"><\/span><strong>Step 3: Install PHP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As we already mentioned, WordPress is a PHP-based application, so we have to install PHP and several PHP extensions on the server. Run the following command to install all necessary components:<\/p>\n<pre>apt -y install php php-xml php-common php-gd php-mbstring php-xmlrpc php-curl php-soap php-zip php-intl<\/pre>\n<p>After the installation of PHP is completed, you can check the installed version:<\/p>\n<pre>PHP 7.2.19-0ubuntu0.18.04.1 (cli) (built: Jun  4 2019 14:48:12) ( NTS )\r\nCopyright (c) 1997-2018 The PHP Group\r\nZend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies\r\n    with Zend OPcache v7.2.19-0ubuntu0.18.04.1, Copyright (c) 1999-2018, by Zend Technologies\r\n<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-4-Install-MySQL-on-the-Remote-Server\"><\/span><strong>Step 4: Install MySQL on the Remote Server<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The next step is to install a database server. For the purposes of this tutorial, we will install it on a remote server.<\/p>\n<p>Login to the remote server via SSH<\/p>\n<pre>ssh root@<span style=\"color: #ff0000;\">remote_IP<\/span> -p <span style=\"color: #ff0000;\">Port_number<\/span><\/pre>\n<p>and install the MySQL database server using the following command<\/p>\n<pre>apt -y install mysql<\/pre>\n<p>To accept remote connections, edit the MySQL configuration file and modify the <code>bind-address<\/code> option. It is set to listen on localhost only. We will change <code>127.0.0.1<\/code> to the database server IP address.<\/p>\n<pre>\/etc\/mysql\/mysql.conf.d\/mysqld.cnf\r\n\r\n# Instead of skip-networking the default is now to listen only on\r\n# localhost which is more compatible and is not less secure.\r\nbind-address            = <span style=\"color: #ff0000;\">remote_IP\r\n<\/span><\/pre>\n<p>and restart MySQL for the changes to take effect:<\/p>\n<pre>systemctl restart mysql<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-5-Create-MySQL-Database-and-User\"><\/span><strong>Step 5: Create MySQL Database and User<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>While you are still logged in to the remote server which we will use as our database server, create a MySQL user and database for the WordPress installation. Login to the MySQL cli as the root user and execute the following commands:<\/p>\n<pre>mysql -u root -p\r\n\r\nmysql&gt; CREATE DATABASE wp;\r\nmysql&gt; CREATE USER 'wpser'@'IP_address' IDENTIFIED BY '<span style=\"color: #ff0000;\">PASSWORD<\/span>';\r\nmysql&gt; GRANT ALL PRIVILEGES ON wp.* TO 'wpser'@'IP_address';\r\nmysql&gt; FLUSH PRIVILEGES;\r\n<\/pre>\n<p>Where &#8216;<span style=\"color: #ff0000;\">IP_address<\/span>&#8216; is the IP address of the Ubuntu 18.04 server where WordPress will be installed. Make sure to replace the password with a good and unique one.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-6-Install-WordPress\"><\/span><strong>Step 6: Install WordPress<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now, go back to the Ubuntu 18.04 VPS where we installed Apache and PHP, and install WordPress on it. To do that, download the WordPress archive:<\/p>\n<pre>wget https:\/\/wordpress.org\/latest.zip<\/pre>\n<p>Unpack the downloaded ZIP archive to the document root directory:<\/p>\n<pre>unzip latest.zip \/var\/www\/html<\/pre>\n<p>Set the proper ownership to the WordPress files:<\/p>\n<pre>chown -R www-data:www-data \/var\/www\/html\/wordpress<\/pre>\n<p>Rename the\u00a0<code>wp-config-sample.php<\/code> WordPress configuration file to <code>wp-config.php<\/code>:<\/p>\n<pre>mv \/var\/www\/html\/wordpress\/wp-config-sample.php \/var\/www\/html\/wordpress\/wp-config.php<\/pre>\n<p>Edit the WordPress configuration file and modify the following lines<\/p>\n<pre>nano \/var\/www\/html\/wordpress\/wp-config.php\r\n\r\n\/** The name of the database for WordPress *\/\r\ndefine('DB_NAME', 'wp');\r\n\r\n\/** MySQL database username *\/\r\ndefine('DB_USER', 'wpuser');\r\n\r\n\/** MySQL database password *\/\r\ndefine('DB_PASSWORD', '<span style=\"color: #ff0000;\">PASSWORD<\/span>');\r\n\r\n\/** MySQL hostname *\/\r\ndefine('DB_HOST', '<span style=\"color: #ff0000;\">remote_IP<\/span>');\r\n<\/pre>\n<p>and save the file.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-7-Create-an-Apache-Virtual-Host\"><\/span><strong>Step 7: Create an Apache Virtual Host<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In order to be able to access WordPress with a domain name instead of the IP address, we have to create Apache virtual host for the specific domain. We will use as an example. Replace all occurences of <code>domain.com<\/code> with your actual domain name.<\/p>\n<pre>&lt;VirtualHost *:80&gt;\r\n\r\nServerAdmin admin@<span style=\"color: #ff0000;\">domain.com<\/span>\r\nServerName <span style=\"color: #ff0000;\">domain.com<\/span>\r\nServerAlias www.<span style=\"color: #ff0000;\">domain.com<\/span>\r\nDocumentRoot \/var\/www\/html\/wordpress\r\n\r\n&lt;Directory \/var\/www\/html\/wordpress&gt;\r\n     Options Indexes FollowSymLinks\r\n     AllowOverride All\r\n     Require all granted\r\n&lt;\/Directory&gt;\r\n\r\nErrorLog ${APACHE_LOG_DIR}\/<span style=\"color: #ff0000;\">domain.com<\/span>_error.log \r\nCustomLog ${APACHE_LOG_DIR}\/<span style=\"color: #ff0000;\">domain.com<\/span>_access.log combined \r\n&lt;\/VirtualHost&gt;<\/pre>\n<p>Enable the virtual host<\/p>\n<pre>a2ensite <span style=\"color: #ff0000;\">domain.com<\/span><\/pre>\n<p>And restart Apache for the changes to take effect<\/p>\n<pre>systemctl restart apache2<\/pre>\n<p>With this step the WordPress installation is completed, and you can finish its configuration by opening <code>http:\/\/domain.com<\/code> in your favorite web browser. Then follow the on-screen instructions to select a language, create your administrative account, etc&#8230;<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-large wp-image-31749\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/08\/wp-1024x696.png\" alt=\"\" width=\"1024\" height=\"696\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/08\/wp.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/08\/wp-150x102.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/08\/wp-300x204.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/08\/wp-768x522.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>Congratulations! We have not only installed WordPress on our Ubuntu 18.04 VPS, but we also made it use a database server that is remote to the one hosting the WordPress instance.<\/p>\n<hr \/>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-32401\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/get-best-industry-support-for-wordpress-database-server-help-setup-by-experts-on-ubuntu-vps.jpg\" alt=\"\" width=\"120\" height=\"120\" \/>Of course, you don\u2019t have to install WordPress on Ubuntu 18.04 and configure it to use a Remote Database if you use one of our Optimized WordPress Hosting services, in which case you can simply ask our expert system administrators to install WordPress on Ubuntu 18.04 and configure it to use a Remote Database for you, using the LAMP stack or any other web hosting stack of your choice. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS.<\/strong><\/span> If you liked this post, on <strong>how to install WordPress on Ubuntu 18.04 and configure it to use a remote database<\/strong>, please share it with your friends on the social networks using the buttons below or simply leave a comment in the comments section. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial we will guide you through the steps of installing WordPress on an Ubuntu 18.04 VPS with all &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#more-31748\" aria-label=\"Read more about How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":32399,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1710,1702,13,1698],"tags":[59,148],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting<\/title>\n<meta name=\"description\" content=\"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting\" \/>\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-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting\" \/>\n<meta property=\"og:description\" content=\"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/\" \/>\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=\"2020-03-27T20:35:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:33:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"6 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-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database\",\"datePublished\":\"2020-03-27T20:35:08+00:00\",\"dateModified\":\"2022-06-03T08:33:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/\"},\"wordCount\":821,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg\",\"keywords\":[\"ubuntu\",\"wordpress\"],\"articleSection\":[\"CMS, CRM, ERP\",\"Databases\",\"Tutorials\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/\",\"name\":\"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg\",\"datePublished\":\"2020-03-27T20:35:08+00:00\",\"dateModified\":\"2022-06-03T08:33:05+00:00\",\"description\":\"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg\",\"width\":742,\"height\":372},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting\",\"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\":\"required name=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\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?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 plugin. -->","yoast_head_json":{"title":"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting","description":"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting","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-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/","og_locale":"en_US","og_type":"article","og_title":"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting","og_description":"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2020-03-27T20:35:08+00:00","article_modified_time":"2022-06-03T08:33:05+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database","datePublished":"2020-03-27T20:35:08+00:00","dateModified":"2022-06-03T08:33:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/"},"wordCount":821,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg","keywords":["ubuntu","wordpress"],"articleSection":["CMS, CRM, ERP","Databases","Tutorials","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/","name":"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg","datePublished":"2020-03-27T20:35:08+00:00","dateModified":"2022-06-03T08:33:05+00:00","description":"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database - RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2020\/02\/how-to-install-wordpress-on-ubuntu18.04-and-configure-it-to-use-a-remote-database.jpg","width":742,"height":372},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-wordpress-on-ubuntu-18-04-and-configure-it-to-use-a-remote-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting","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":"required name=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\/"]},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?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\/31748"}],"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=31748"}],"version-history":[{"count":2,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/31748\/revisions"}],"predecessor-version":[{"id":41666,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/31748\/revisions\/41666"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/32399"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=31748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=31748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=31748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}