Creating MySQL Database

To be able to manage MySQL databases:

1. log in as CP+ admin;
2. choose the System Administration icon in the CP+ mode section;
3. scroll down to the Databases section and click the MySQL Database Server icon. You will have the following sections to choose from:
   - MySQL Databases to create and edit databases;
   - Global Options to set and change MySQL server, database settings and user permissions;
   - Stop MySQL Server to stop the MySQL database server on your system;
   - Backup Databases to setup the backup of all MySQL databases, either immediately or on a configured schedule.

MySQL Databases

To create a MySQL database:

1. Go to the MySQL Database Server page.



2. Click on the Create a new database link.
3. Fill the database creation form that appears:



• Enter Database name;
• Enter Initial table name or choose 'none';
• Set the Initial table structure: enter field names, data type and, optionally, type width; also you can choose the following options for each field of the table:
  
  • Key? - set to "Yes" to mark the field as a key field
  • Autoinc? - if enabled, then the field value will be automatically generated, when a new record is added, as the last assigned value plus some step value ( "1" by default)
  • Allow nulls? - set to "Yes" if the empty field is allowed
  • Unsigned? - if this option is chosen, only positive value is allowed for this field
  • Default value - here you can set a default value of the field
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 every time 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.

Backup All Databases

• Backup to directory - enter the directory, where the backup will be stored
• Only backup rows matching where clause - either choose All rows or enter the part of "where" SQL-query to select rows (find more information at mysql.com)
• Choose if you need to add drop table statements to backup
• Specify Command to run before backup and Command to run after backup if needed
• Scheduled backup enabled? - if you choose "Yes", it allows you to set the most convenient backup schedule