What is MySQL?
MySQL refers to a database management tool, as well as the type of database it manages. Such databases are used by applications like bulletin boards and retail shopping carts. This screen lets you create, edit, and delete MySQL databases and user accounts, and give users access to specific databases.
Only MySQL users (different than mail or other users) that have privileges
to access a database can read from or write to that database.
Create a new MySQL database
- Enter a database name in the New Database box.
- Click Create Database.
Check a MySQL database for errors or corruption
- Select a database from the Check DB menu.
- Click Check DB.
Repair a MySQL database with errors or corruption
- Select a database from the Repair DB menu.
- Click Repair DB.
Search for a MySQL database
If you manage a large number of databases, you can use the Search field above the Current Databases table to locate a particular database. To search the Current Databases table, type your criteria into the Search field and click Go.
Delete a MySQL database
- Click Delete Database. You will be directed to a new page.
- Click Yes to permanently remove the database, or click No to cancel the removal.
Add a new MySQL user
You will need to create MySQL user accounts separately from mail and web administrator accounts.
- Enter the username, password, and password confirmation in the appropriate boxes.
Note: The Strength box will show you the strength of your password choice. If you cannot think of a strong password, click Password Generator for an appropriate option. - Click Create User.
Add a MySQL user to a MySQL database
For a user to be able to access a database, you will need to assign the user to the database.
- Select the appropriate user from the User menu.
- Select the appropriate database from the Database menu.
- Click Add.
Delete a MySQL user
- Click X. You will be directed to a new page.
- Click Yes to permanently remove the user, or click No to cancel the removal.
Delete a MySQL user from a specific database
- In the Current Databases table, locate the user whose privileges you wish to delete.
- Click the X. You will be directed to a new page.
- Click Yes to permanently remove the user, or click No to cancel the removal.
