|
MySQL
is a database management system. It allows you to add, access, and
process stored data. The SQL part of MySQL stands for "Structured
Query Language" - the most common standardized language used to
access databases.
Creating
MySQL Database and Its Users
MySQL users
cannot exist separately from MySQL databases. You must stick to the
following sequence:
- Create a
database
- Add MySQL
users to each created database.
However, MySQL
users can be shared by different databases.
To create a
MySQL database, do the following:
1. Select
MySQL in the Databases menu and a MySQL DB creation
Wizard automatically appears.
2. On the form
that shows enter the name of the database and database description
if needed:
3. Agree with
additional charges if any.
4. In the form
that appears, create a new user or grant privileges to users of
other databases:
- Add a new
user to the database you have just created. User roles are
explained
below. Click Add user.
- Choose
roles for users of other databases so they can use your new
database. Click Grant.
5. Click
Finish to complete creating your MySQL database.
Editing
MySQL databases (phpMyAdmin)
You can edit
the content of your databases using the phpMyAdmin utility that
comes with your control panel. To run phpMyAdmin, do the following:
1. Select
MySQL DBs in the Databases menu.
2. In the
form that appears, click the name of the existing MySQL
Database you want to edit or the Edit icon on its
right:
3. In the form
that appears, click Built in phpMyAdmin control panel to
start editing your database:
4. Follow the
instructions of the phpMyAdmin control panel to edit your MySQL
DB.
Changing MySQL disk quota.
MySQL disk
quota is the maximum allowed size of one MySQL database. If
you exceed this quota, you'll be charged for overlimit at a
different (usually higher) price.
To change
MySQL disk quota, do the following:
1. Select
MySQL DBs in the Databases menu.
2. Click the
MySQL Database or the Edit icon on its right:
3. Click the
Change button against the Quota field:
4. Enter the
new quota.
5. Click
Submit.
6.
Agree to
additional charges.
Changing user passwords.
To change user
password in the MySQL database, do the following:
- Click the
MySQL Database
.
- In the form
that appears (see above), click the Change password icon
next to the DB user.
Adding MySQL users and granting them privileges.
Here you will
learn how to add new users to an existing MySQL database.
1. Select
MySQL DBs in the Databases menu.
2. Click the
MySQL Database or the Edit icon on its right:
3. On the form
that shows, click the Add icon against the Database
users field.
4. Fill the
following form:
Each user
role involves a fixed set of privileges on this specific
database:
|
Role: |
Set of privileges: |
| read |
select |
|
read/write |
select, insert, delete, update |
| dba |
select, insert, update, drop, create, alter, index |
5. Click the
Add or Grant button and agree to additional
charges.
6. To edit
privileges, click the Edit icon next to the user. You will
be brought to the Privilege Maintenance page.
7. Check or
uncheck the desired privileges and press the Submit button.Note:For
more information on MySQL access privileges, please refer to
www.mysql.com.
IMPORTANT:
any changes in user privileges will be applied to the whole selected
database.
|
