MySQL

SQL stands for Structured Query Language. SQL is an 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 free for use.

To create a MySQL database:
1. Click on the MySQL databases button on the home page.
2. Enter the name of the database in the Db field.
3. Click on the Add Db button. The database will be added to the /var/lib/mysql folder.

To create a MySQL user:
1. Click on the MySQL databases button on the home page.
2. Enter the user's name in the UserName field and the user's password in the Password field.
3. Click on the Add User button.

To grant user permissions to a MySQL database:
1. Click on the MySQL databases button on the home page.
2. Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list.
3. Click on the Add User to Db button. The user now has permission to use that database and sample connection strings are shown in the MySQL window.

<-- Back to Support Area