MySQL Support
For more
information contact us at info@mhhosting.net
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 Control Panel system
To use MySQL databases within Control Panel 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.
|
