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:
- Click MySQL Server on your control
panel home page.
- Click Add database at the bottom
of the form:
- On the form that shows enter the name of
the database and database description if needed:
- Agree with additional charges if any.
- In the form that appears, create a new user
or grant privileges to users of other databases:
6. 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:
- Click MySQL Server on your control
panel home page.
- In the form that appears, click the name
of the existing MySQL Database you
want to edit or the Edit icon on its
right:
- In the form that appears, click Built
in phpMyAdmin control panel to start editing
your database:
- Follow the instructions of the phpMyAdmin
control panel to edit your MySQL DB.
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.
- Click MySQL Server on your control
panel home page.
- Click the MySQL Database or the Edit
icon on its right:
- On the form that shows, click the Add
icon against the Database users field.
- 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 |
- Click the Add or Grant button
- To edit privileges, click the Edit
icon next to the user. You will be brought
to the Privilege Maintenance page.
- 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.
|
|
|
|
 |
|
Fast
& friendly assistance with your ambition |
 |
| May |
100.00% |
| April |
100.00% |
| March |
100.00% |
|
 |
|
|
