MySQL Databases

SQL stands for Structured Query Language. SQL is a international standard in querying and retrieving information from databases. mySQL is essentially an SQL server – it responds to requests for information that are written in SQL. You can communicate with mySQL using a wide variety of programming languages (PHP being one of the most common). mySQL is Open Source software and generally free for use.

Refer to the following links for more information about mySQL :

To create a mySQL database:

  1. Click on the MySQL Databases link in the Advanced Menu area.

  2. Enter the name of the database in the Db field.

  3. Click on the Add Database button button. The database will be added to the /var/lib/mysql folder.

    You need to create at least one database user and grant that user permission to use the new database. Refer to Creating a mySQL user and Grant a user’s permissions to a mySQL database for more information.

Creating a mySQL database

Removing a database

Removing a database will delete that database from it’s online location. Be sure that you have saved a copy of the database if you want to keep any of the information in the database. Removing a database will not remove any user’s but it will remove all user’s permissions to that database.

To remove a database:

  1. Click on the MySQL Databases link in the Advanced Menu area.

  2. Click on the Delete button next to the specific database.