|
For additional information contact HitSites Support at
support@hitsites.net
General issues
MySQL is a database management system.
A database is a structured collection of data. It may be anything
from a simple shopping list to a picture gallery or the vast
amounts of information in a corporate network. To add, access, and
process data stored in a computer database, you need a database
management system such as MySQL. A database management
system plays a
central role in computing, as stand-alone utilities, or as parts
of other applications.
MySQL is a relational database management
system.
A relational database stores data in separate tables rather than
putting all the data in one big storeroom. This adds speed and
flexibility. The tables are linked by defined relations making it
possible to combine data from several tables on request. The SQL
part of MySQL stands for "Structured Query Language" - the most
common standardized language used to access databases.
My SQL is Open Source Software.
Open source means that it is possible for anyone to use and modify
it. You can download MySQL from the Internet and use it
without paying anything. You can study the
source code and change it to fit your needs. MySQL uses the GPL
(GNU General Public License) http://www.gnu.org, to define what
you may and may not do with the software in different situations.
If you feel uncomfortable with the GPL or need to embed MySQL into
a commercial application you can buy a commercially licensed
version.
Working with MySQL in H-Sphere system
To use MySQL databases within H-Sphere you must subscribe
to a plan supporting MySQL. Please contact Hitsites Support for
assistance in
selecting the plan that will best meet your needs.
It is important to understand that MySQL users cannot
exist in isolation from MySQL databases. This means you must first
create a database and then add MySQL users to each created
database. However, MySQL users can be shared by different
databases.
How to Create a Database
To work with MySQL you first need to create a database. You can
do it using two alternative tools:
- MySQL database creation wizard.
- MySQL database maintenance page.
They both can be found in the MySQL database menu:
MySQL Database Creation wizard
Select MySQL DB creation in the navigation menu to open
the first page of MySQL database creation wizard:
As you enter the name and the description of the database, you
will be taken to the second step of the wizard:
On this step, MySQL database creation wiza rd asks you to add
users to your database. If you want to create a completely new MySQL user, enter user name, user password, typical user role and
click the Add new user button in the left-hand panel. You
can also add a user from an existing database. To do so, select
a user and user role in the right-hand panel. After you have added
all users, select the Finish button.
User role determines what privileges you assign to the user -
to read, to write, or to administer the database. For more
information on MySQL access privileges please refer to
www.mysql.com.
Managing MySQL databases
Note: If you are not familiar with MySQL database
management, it is recommended
you
use MySQL creation wizard.
To access MySQL database management page, select the MySQL
Databases in the navigation menu.
On the page that appears you will see the list of databases
already existing in your account and fields to create a new
database:
To add a new database, enter database name and description in
the fields at the bottom of the form and press the Add new
database button.
The upper part of MySQL database maintenance page lists all
existing databases. To edit settings for any of them, click the
Edit icon on its right. To delete a database, click the
Trash Can icon. Important: If you delete a database,
its users will also be deleted unless they belong to other
databases as well.
Host name:
the address a user needs to connect to his
MySQL Database via the built-in phpMyAdmin control panel or his
own MySQL GUI client.
To edit settings
for your existing databases, click the Edit icon or Database
Name. You will be taken to the database management
page.
You can log into the database as the administrator by
clicking the Built in phpMyAdmin control panel link. Also,
you can change database disk space quota by clicking the Change
icon in the Quota field.
Here you can delete existing database users, edit their
privileges and change their passwords. By a user we understand a
unique username, a password and a set of privileges required to
work with a database. What privileges and how you set them for
a user is explained in
Managing MySQL User Privileges.
IMPORTANT: If you change user password for this database, it
will automatically be changed for all other databases.
Here is where you can add
a new users to your database. These are
users that have not been added to any other databases in this
account.
To create new users for the selected database, enter a user
name and a user password and select a typical user role for this
database from the drop-down list. The new user will be added only
after you click the Add new user button.
User role determines what privileges you assign to the user -
to read, to write, or to administer the database.
For more
information on MySQL access privileges,
please refer to
www.mysql.com.
NOTE: Creation of users with identical names and different
passwords is not supported.
Here you can add existing users to your database. These are the
users that have already been added to one or more other databases
in your account.
Here you can delete the whole database you are working with.
Important: If you delete a database, its users will also be
deleted unless they also belong to other databases.
Managing MySQL User Privileges
After you have added MySQL users to a database, each with a
certain user role, you may refine each user's privileges to use
the database. By default, each user gets the following privileges
depending on the user role you have defined:
| Role: |
Set of privileges: |
| read |
select |
| read/write |
select, insert, delete, update |
| dba |
select, insert, update, drop, create,
alter, index |
NOTICE: Before changing the defaults, it is recommended to
become familiar with MySQL database administration. To read more,
please visit
www.mysql.com.
IMPORTANT: any changes in user privileges will be applied to the
whole selected database.
To change the defaults, click the Edit icon next to the
user whose privileges you would like to configure. The Privilege Maintenance page
appears.
Check or uncheck the desired privileges and press the
Submit button.
|
