{"id":3092,"date":"2022-02-03T16:03:15","date_gmt":"2022-02-03T14:03:15","guid":{"rendered":"https:\/\/www.scalahosting.com\/kb\/?p=3092"},"modified":"2023-03-13T13:41:18","modified_gmt":"2023-03-13T11:41:18","slug":"what-is-a-database-host-in-wordpress","status":"publish","type":"post","link":"https:\/\/www.scalahosting.com\/kb\/what-is-a-database-host-in-wordpress\/","title":{"rendered":"What Is a Database Host in WordPress?"},"content":{"rendered":"

Everybody knows that the database is an integral part of any WordPress website. However, many people don’t really understand how it works and what it does. Site owners are also a bit baffled when WP asks them to set <\/span>a database host<\/b>.<\/span><\/p>\n

Let’s clear up some of the confusion, starting with the basics.<\/span><\/b><\/p>\n

What Is a WordPress Database?<\/b><\/b><\/h2>\n

The database is where your website’s data is stored. Thanks to it, instead of a<\/span> collection of static HTML pages with images and text<\/b>, you can have an interactive website where users can sign up, leave comments, generate and manage data, search through and filter content, and a lot more.<\/span><\/p>\n

In the database, you have anything from the <\/span>posts<\/b> and <\/span>pages<\/b> you write, through <\/span>users’ personal data<\/b>, to <\/span>WP’s core configuration and settings<\/b>.<\/span><\/p>\n

The information in the database <\/span>shouldn’t be freely accessible<\/b>. That’s why, in addition to a database, you also need to create <\/span>a user account<\/b>. It has <\/span>a username, a password, and a set of permissions<\/b> governing what it’s allowed to do with the data.<\/span><\/p>\n

WordPress uses this user account to retrieve the information and serve it to the site’s visitors. Users of ScalaHosting’s SPanel VPS services can view and <\/span>manage MySQL user accounts and databases<\/b><\/a> via the <\/span>MySQL Databases<\/b> tool in <\/span>SPanel’s User Interface.<\/b><\/p>\n

\"What<\/figure>\n

What Is a Database Table?<\/b><\/h2>\n

WordPress works with <\/span>MySQL databases<\/b> which organize the information in tables. During the initial installation, WP automatically creates the required tables for <\/span>users, posts, comments, options, etc<\/b>., with more being added at later stages (e.g., <\/span>when you install plugins<\/span><\/i>).<\/span><\/p>\n

You can view all tables through the <\/span>phpMyAdmin database management tool<\/b> inside your web hosting control panel.<\/span><\/p>\n

\"What<\/figure>\n

Tables allow for <\/span>a tidier database and a quicker delivery of the requested information<\/b>.<\/span><\/b><\/p>\n

What Is an SQL Query?<\/b><\/h2>\n

WordPress and the database communicate through <\/span>SQL queries<\/b>. In simple terms, whenever WP needs to display a piece of information, it sends an SQL query. The <\/span>MySQL server processes it<\/b> and responds with the correct data.<\/span><\/p>\n

All manner of events may trigger an<\/span> SQL query<\/b>. It could be a user clicking on a button, you filtering comments in the <\/span>WP dashboard<\/b><\/a>, or a plugin trying to alter some settings.<\/span><\/p>\n

Traffic volumes directly affect the number of queries your server needs to process, but they’re far from the only factor. <\/span>Complex WP plugins<\/b> can also generate quite a few database queries and significantly affect your hardware resource usage.<\/span><\/b><\/p>\n

What Is a Database Host?<\/b><\/b><\/h2>\n

Many people understand the roles of the <\/span>database, the MySQL user, and the SQL queries<\/span><\/i>. However, they still get confused when, for example, they’re <\/span>setting up WordPress manually<\/b><\/a>, and the installation wizard asks them for <\/span>the database host<\/b>.<\/span><\/p>\n

By default, the wizard sets it to “<\/span>localhost<\/b>,” and a quick Google search reveals leaving it like this will work in most cases. However, the search engine results rarely explain <\/span>what the database host actually is.<\/span><\/i><\/p>\n

In simple terms, it’s <\/span>the server hosting the database<\/b>. Most website owners host the site and the database on the same server, so leaving “localhost” in the DB host field usually works.<\/span><\/p>\n

But what if you want to put the database on another machine? Is it possible to do it? Yes, it is. However, there are certain preparations you need to take care of first.<\/span><\/i><\/p>\n

You need to make sure MySQL on the database host is <\/span>configured to receive connections from your web hosting server<\/b>. If you don’t have root access to the database host, you might need some assistance with this because it involves editing MySQL’s main configuration file – <\/span>\/etc\/mysql\/my.cnf<\/span><\/i>. You need to find the <\/span>bind-address<\/span><\/i> parameter and set it to the IP of your web hosting server. A restart of the MySQL service saves the changes.<\/span><\/p>\n

Next, you’ll have to create the MySQL user account WP will use to connect to the database. Depending on the database host, you’ll need to do that either through the control panel or via the command-line interface. You need to make sure you set <\/span>the new user account’s hostname to your web hosting server’s IP<\/b> (i.e.,<\/span> user@xx.xx.xx.xx<\/span><\/i> instead of<\/span> user@localhost<\/span><\/i>).<\/span>\u00a0<\/span><\/i><\/p>\n

Pay attention to <\/span>the permissions<\/b> the MySQL user account gets. WordPress needs the<\/span> select<\/i><\/b>, <\/b>delete<\/i><\/b>, <\/b>insert<\/i><\/b>, and <\/b>update<\/i><\/b> privileges<\/b> to work correctly, and security best practices dictate that these are the privileges you’ll need to give the new user. However, if you’re configuring a fresh installation, you’ll need to grant it full permissions, at least until WP is fully set up and ready to go.<\/span><\/p>\n

The only thing left is to <\/span>configure WordPress to work with the remote database host<\/b>.<\/span><\/p>\n

If you’re installing WordPress manually, you can do that from the installation wizard. You’ll need to enter the<\/span> database name<\/b>, the <\/span>MySQL account’s login credentials<\/b>, and the <\/span>database host’s IP address<\/b>.<\/span> WP should have no problems connecting to the database if everything is configured correctly.<\/span><\/p>\n

If you’re using an automatic installer or re-configuring an existing WordPress installation, you’ll need to edit the <\/span>wp-config.php file<\/b>. The parameters you need to look for are:<\/span><\/p>\n