This knowledgebase article contains,
1) Creating Databases
2) Deleting Databases
3) Creating New Database user
4) Changing Database user password
5) Assign / Modify Database user Privileges
6) Download a Database
7) Accessing PHPMyAdmin
1) Creating Databases
Sign into the control panel and then click on the "MySQL Management" link ( Under Account Manager ),
Click on Create new Database > Provide Database name, Database username and Strong Password for Database user > Then click on Create Database
Note :
Database Name format : ControlPanelUsername_DBName
Database username format : ControlPanelUsername_DBUserName
2) Deleting Databases
Sign into the control panel and then click on the "MySQL Management" link ( Under Account Manager ),
Select the check box near the Database you need to delete > Click on "Delete" button
3) Creating New Database user
Sign into the control panel and then click on the "MySQL Management" link ( Under Account Manager ), this will list all databases.
Click on the Database Name > This will open user window, Now click on "Create New User" > Provide username, Strong password and Create.
4) Changing Database user password
Sign into the control panel and then click on the "MySQL Management" link ( Under Account Manager ), this will list all databases.
Click on the Database Name > This will open user window, Click on "Change Password" > Provide a New strong Password > Save
5) Assign / Modify Database user Privileges
Sign into the control panel and then click on the "MySQL Management" link ( Under Account Manager ), this will list all databases.
Click on the Database Name > This will open user window, Click on "Modify Privileges" > Set required Privileges and Save
6) Download a Database
Sign into the control panel and then click on the "MySQL Management" link ( Under Account Manager ),
Click on "+" sign infront of the database > Click on the download format link.
Note: Also you can use export function on phpMyAdmin interface.
7) Accessing PHPMyAdmin
phpMyAdmin is a tool written in PHP that allows you to administrate your MySQL databases.
To access phpMyAdmin, sign into the control panel and then click on the "Extra Features" icon, followed by the "phpMyAdmin" link.
