Databases

Databases are used to store large amounts of information that will be accessed by web applications, such as blogs or message boards. For example, if you wish to install a blog, it will require its own database and corresponding database user.

It may be important to note that the "user" in this case is not necessarily a person, but is often an automated part of a database that manipulates the information it contains.

Once you have configured both the database and database user, you will need to set up the appropriate privileges, so that the application can use the database user to access and manipulate information contained within the database.

There are 4 tabs available for managing databases:

• The Databases tab allows you to:
  • Repair a database — This can be useful when a database has become corrupted.
  • Check a database for errors.
  • Delete a database.
  • Create a new database.
• The Users tab allows you to create and delete users.
• The Privileges tab lets you manage users' privileges.
• The Access Hosts tab (when using MySQL) lets you restrict the location(s) from which users can log in (see below).

Restricting Access for Remote Hosts

Note: This feature only available to MySQL® users.

By default, a database user can log in from any host. If you know that a given user will always log in from the same location, you can restrict access to only allow that user to log in from that host.

Click the Access Hosts tab, then type the user's IP or hostname into the text box, and click Add.

If you need to remove user's access restriction, click the appropriate red "x".