Databases & WordPress in cPanel

Summary

A practical guide for Lynx Digital cPanel hosting customers on databases and installing WordPress. It explains that dynamic sites like WordPress store their content in a MySQL database, and walks through creating a database, creating a database user with a strong password, and adding that user to the database with privileges (all handled in the MySQL Databases area). It then covers installing WordPress two ways: with a one-click application installer (such as Softaculous, the modern replacement for the older Fantastico), which creates the database and configures WordPress automatically in a couple of minutes; or manually, by uploading WordPress to the web root and running its setup against the database you created. The guidance notes that a one-click install is fine to get going, but a professionally built site involves theme, plugin, security, and performance choices beyond the default install, which is where Lynx's WordPress build service comes in.

Dynamic sites like WordPress store their content in a MySQL database. cPanel gives you both the database tools and one-click installers to get a site running.

Creating a MySQL database

In the Databases section, open MySQL Databases and:

  1. Create a database (give it a clear name).
  2. Create a database user with a strong password.
  3. Add the user to the database and grant it all privileges.

Note the database name, username, and password, you will need them if you install software manually.

Installing WordPress the easy way

The fastest route is a one-click installer. Look for Softaculous (the modern replacement for the older Fantastico) in the Software section. Choose WordPress, pick the domain and a few settings, and it creates the database and installs WordPress for you in a couple of minutes.

Installing WordPress manually

If you prefer, you can install by hand:

  1. Download WordPress and upload it to your web root (public_html).
  2. Create a database and user as above.
  3. Visit your domain and follow the WordPress setup, entering the database details when prompted.

From install to a real website

A one-click install gets WordPress running, but a site that looks great, loads fast, and gets found involves theme, plugin, security, and SEO choices beyond the defaults. That is what our Professional WordPress Website build handles, and we can host and maintain it too.

Key Concepts
  • MySQL Database
  • Database User & Privileges
  • One-Click WordPress Install
  • Softaculous / Fantastico
  • Manual WordPress Install
This entry was posted in . Bookmark the permalink.