Creating MySQL Database

This document tells you how to create and manage MySQL databases.

To be able to manage MySQL databases, you have to be logged in as CP+ admin. Once you are there, do the following

1. Select the Services tab.
2. Click the MySQL Database Server icon. You will see the following two sections:
   - MySQL Databases to create and edit databases;
   - Global Options to set and change MySQL server, database settings and user permissions.

MySQL Databases

To create a MySQL database:

1. Go to the MySQL Database Server page.



2. Click Create a new database.
3. Fill the database creation form that shows:



• Enter Database name;
• Enter Initial table name or choose 'none';
• Set the Initial table structure: enter field names, data type and, optionally, type width.
4. Click Create. Your new database appears in the database list.
5. To add more tables to your database, go to the database and click Create a new table.
6. Fill the table creation form and click Create.

To manage a specific table:

• Click the field name to modify field parameters. You can change field name, data type, type width. Make sure to click Save to preserve changes.
• Add more fields by choosing the data type from the drop-down box. Fill the form that shows and click Create.
• Click the View Data button to see the data entered into the table.
• Click the Drop Table button to delete table .

To manage databases:

• Click Drop database to delete a particular database.
• Click Backup database to back up all data stored in the database.
• Click Execute SQL to enter SQL command that can be executed on particular database everytime you click this button.

Configuring MySQL Databases

To change MySQL settings:

1. Click the MySQL Database Server icon and go to the Global Options section.
2. Use the icons below to manage global settings.



• User Permissions: click this icon to add database users and set user permissions.
• Database Permissions: click this icon to add database permissions.
• Host Permissions: click this icon to add host permissions.
• Table Permissions: click this icon to add table permissions.
• Field Permissions: click this icon to add field permissions.

 User Permissions

This option allows you to add users to your databases and set permissions. Here you can also configure synchronization between Unix users created through CP+ and MySQL users.

To add a new user of your database, click Create new user. You will see the following form:

Enter Username, password, hosts, set permissions for this new user and click Save. The new user will appear in the users list.

 Database Permissions

This option allows you to edit and add new database permissions. To add one, click Create new database permission. The following form will show:

Set database, enter username, hosts, set permissions for this database permission option and click Save.

 Host Permissions

This option allows you to edit and add new database permissions. To add one, click Create new database permission. The following form will show:

Set database, hosts, set permissions for this database permission option and click Save.

 Table Permissions

This option allows you to edit and add table permissions.

To add one, do the following:

1. Choose the database from the drop-down box.
2. Click Add new permissions in database. The following form will show:

   

3. Set database, hosts, set permissions for this database permission option and click Save.

 Field Permissions

This option allows you to edit and add permissions for specific fields in tables.

To add one, do the following:

1. Choose the database and table from the drop-down box.
2. Click Add new permissions in database and table. The following form will show:

   

3. Choose necessary field, username, hosts and choose permissions for this field.
4. Click Save.