Chapter 9. Running a MySQL Database Server

In this chapter, we will cover the following topics:

• Installing the MySQL database server

• Allowing access to MySQL over the network

• Accessing your MySQL server over an SSH tunnel

• Creating a new database

• Creating users and granting permissions to databases

• Creating a backup of your database

• Executing custom SQL commands

• Restoring database from the backup

• Editing the structure of your database

• Editing records in a database

• Checking who is using your database server

• Installing phpMyAdmin