MySQL Manager

Introduction

MySQL Manager allows you to manage the imports and exports for existing Microsoft SQL Server databases. With MySQL Manager, you ca do the following:

• Create/manage MySQL users
• Create/manage MySQL databases
• View details about their databases such as database usage (how many are included/used)

User Management

Creating Database Users

TO CREATE A DATABASE USER:

1. Click Users.
2. Click Add User.
3. In the Add New User dialog, enter a password for the new user and click Next. The username will be automatically generated when the user is created. Note: The password mist contain at least 8 characters, including 1 letter and 1 number.
4. In the Add User to Database dialog, do one of the following:
   • Select an existing database from the drop-down.
   • Add a new database by entering its name in the Create new database field.
5. Click Submit. A confirmation dialog will display the new user’s username.

Managing Users

MySQL Manager allows you to manage user settings from the User dashboard. In the right-hand column, a settings icon provides options to assign users to databases, manage permissions, change their password or delete user access. This section provides instructions to complete the following tasks:

• Add a new user
• Manage Privileges
• Change a User’s Password
• Delete User Access

TO ADD A USER TO AN EXISTING DATABASE:

1. Click the Settings icon and select Add to Database.
2. In the Add to Database dialog, select an existing database from the drop-down and click Yes. A confirmation dialog displays the successful database assignment.

TO MANAGE PRIVILEGES FOR AN EXISTING USER:

1. Click the Settings icon and select Manage Privileges.
2. In the Manage Privileges dialog, select an existing database from the drop-down and modify any of the following privileges:
   • Create Temporary Table
   • Lock Tables
   • Create View
   • Show View
   • Select
   • Insert
   • Update
   • Delete
   • Create
   • Drop
   • Index
   • Alter
3. Click Save.

TO CHANGE A USER’S PASSWORD:

1. Click the Settings icon and select Change Password.
2. In the Change Password dialog, complete the following:
   • Enter a new password
   • Enter the password in confirm password field. Note: The password mist contain at least 8 characters, including 1 letter and 1 number.
3. Click Yes.

TO DELETE USER ACCESS:

1. Click the Settings icon and select Delete User.
2. In the Delete User dialog, click Yes.

Database Management

Creating Databases

TO CREATE A NEW DATABASE:

1. Click Databases.
2. In the Add New Database dialog, enter a name for the database and click Next.
3. In the Add User to New Database dialog, do one of the following:
   • Select an existing User from the drop-down.
   • Enter a password to create a new user.
4. Click Submit.

Managing Your Database

MySQL Manager has integrated a connection to phpMyAdmin to help you use and manage your SQL server. Once you have created your user and database, your manage database function will open phpMyAdmin in separate window. Note: Before opening your server in phpMyAdmin, we will:

• Check to see if phpMyAdmin has been installed.
• If phpMyadmin is not found, it will automatically install the software in a /public/phpmyadmin directory.

TO MANAGE A DATABASE:

1. Click the Settings icon and select Manage Database.
2. Manage SQL server through phpMyAdmin.

TO RESTORE A DATABASE:

1. Click the Settings icon and select Restore Database.
2. In the Restore dialog, do the following:
   • Select a time period from the drop-down.
   • Select a target database from the drop-down.
3. Click Yes.

TO DELETE A DATABASE:

1. Click the Settings icon and select Delete Database.
2. In the Delete Database dialog, click Yes.