USER GUIDE
MySQL Support
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.
MySQL 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:
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.
Role: www.mysql.com .
Managing MySQL database
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:
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:
- General Issues
-
Working with MySQL in Control Panel system
- Creating MySQL database and its users
- Managing MySQL database
- Editing MySQL settings
- Managing MySQL user privileges
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.
MySQL 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.
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.
Role: www.mysql.com .
Managing MySQL database
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.
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.
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.
