Some Web applications request access to a database connected with your website so they can retrieve data. A database stores computer data for efficient retrieval. When visitors enter your site, they need to retrieve posts and photos, and a database organizes your data and makes it easy to access. SQL is the language a computer uses to retrieve this data. If you are using a CMS such as WordPress or Drupal, it automatically uses a database to retrieve your site information.
In this section, we’ll discuss:
- Creating a Database
- Managing a Database
- Checking a Database for Errors
- Repairing a Database
- Connecting a Database to a Remote Server
Creating a Database
There are two SQL databases in the cPanel: phpMyAdmin and MySQL Database. We recommend the MySQL Database application for new users because it’s the most basic and user-friendly application. If you plan on storing a lot of data on your database, we recommend you use an outside storage service.
Managing a Database
Editing a Database
The Current Databases section gives you the opportunity to edit your database.
- Click Rename to rename a database. It is strongly recommended NOT to rename a database. When a database is renamed, all connections with it are severed.
- Click Delete to delete a database.
- Click the trash can icon next to a privileged user to remove his or her access to a database.
- Click a name in the Privileged Users list to edit a user’s privileges. Select privileges, and then click Make Changes.
Adding a User to a Database
Editing a User
The Current Users sections gives you the opportunity to edit a user. You can change a user’s password, rename a user, or delete a user.
Checking a Database for Errors
If your content won’t appear on your website, or your website crashed, it may have been caused by a database error.
Follow these steps to check your database for errors.
Repairing a Database
Connecting a Database to a Remote Server
Applications like bulletin boards, online shopping carts, and content management systems require databases to operate. You can authorize these applications to have access to your database.
2. Type the host’s name or IP address in the Host text box, and then click Add Host% as a wildcard. For example, to allow access from all IP addresses that begin with 192.68.0, type 192.68.0.%.
3. Remove a host’s access by clicking Delete, and then clicking Remove Access Host.