|
What's MySQL? What do
I need it for?
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. Since computers
are very good at handling large amounts of data, database
management 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. Anybody can download MySQL from the Internet and
use it without paying anything. Anybody interested can study
the source code and change it to fit his/her 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 from us.
Working with MySQL in NatHost
2.x system
To use MySQL databases within NatHost you must be subscribed
to a plan supporting MySQL. Please consult our IT consultants
in selecting the plan that will best correspond to your needs.
It is very important to understand that MySQL users cannot
exist separately from MySQL databases. This means that you
must:
- create a database
- add MySQL users to each created database.
However, MySQL users can be shared by different databases.
Creating MySQL Database
And Its Users
To create any MySQL database, please use MySQL DB creation
Wizard. It is automatically launched when you click MySQL
DB creation:
Then it takes you to the following form:
On this step you are asked 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 as well
add a user from an existing database. To do this, select a
user and user role in the right-hand panel. After you have
added all users, press 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
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
that already exist in your account:
To add a new database, use MySQL DB creation
Wizard.
To edit settings for any of the existing databases , 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 also belong to other databases.
Editing MySQL DB
Settings
Click the Edit icon in the Controls section next to the DB
which settings you decided to view/change. You will be brought
to the form similar to the one below:
where:
- Host name: the address that a user needs to connect
to his MySQL Database via the built-in phpMyAdmin control
panel or user's own MySQL GUI client.
- Port number through which users get to this database.
- Database name shows you which database settings
you are viewing/editing.
- Built in phpMyAdmin lets you log into the database
as the administrator.
- Quota shows you the disc space used by this database
and its quota. Change database disk space quota by clicking
the Change icon. If you exceed this quota, you'll
be charged for the excess at a different (usually higher)
price.
- Users of the database: the list of all DB users.
By a user we mean a unique username, a password and a set
of privileges required to work with a database. What privileges
are and how you set them for a user is explained in Managing
MySQL User Privileges paragraph further in this
chapter.
- Click the Edit icon to set privileges for this user.
- Click the Change icon to change users password.
IMPORTANT: If you change user password for this database,
it will automatically be changed for all other databases.
- Click the Trash Can icon to remove the user.
- Click the Add icon to create other users of this DB You'll
be asked to fill in the following form:
Here you can add entirely new users to your database. These
are users that have not been added to any other databases
in this account.
In the lower section you
determine
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: You cannot create users with identical names and
different passwords.
Setting MySQL User
Privileges
After you have added MySQL users to a database, each with
a certain user role, you may change each user's privileges
to use the database. By default, each user gets the following
privileges depending on the user role that 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
learn more about administering a MySQL database. 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. You
will be brought to the Privilege Maintenance page.
Just check or uncheck the desired privileges and press the
Submit button.
|
