MySQL

The number of databases you can create depends on the hosting plan that you are using. In a case you need more databases, you can purchase additional database slots. You can create many tables within one MySQL database. That is, you can have several applications sharing one and the same database, as long as there is no conflict in the table names. Some software packages allow you to assign a prefix to their tables, so there will be no mix-ups with other software using the same database.

You can create MySQL databases and users only through the MySQL Databases section of the hosting Control Panel. Creating a MySQL database To create a MySQL database, you need to: Log in to your hosting Control Panel. Enter the MySQL Databases section. Navigate to the Databases tab. Specify a name for your database in the Database name field. The name of your database always starts with your hosting Control Panel username followed by an underscore. Select the collation for your database from the Collation drop-down menu. By default, the utf8_general_ci collation is selected. Click on the Create button. Once your database is created, the system will automatically grant permissions to your master MySQL user. The name of your master MySQL user is the same as your hosting Control Panel username. Its default password is the same as your initial Control Panel password. Creating a MySQL user By default, your master MySQL user has full privileges over your databases. Due to security concerns, we recommend that you create and use a separate MySQL user for each software application installed on your account. You can create a MySQL user by following these steps: Log in to your hosting Control Panel. Enter the MySQL Databases section. Navigate to the MySQL users tab. Specify a name for your MySQL user in the MySQL user field. Enter the password for your MySQL user in the Password and Confirm password fields.Note: You will notice that there is a password strength indicator below the Password field. It will update in real time as you are entering your password. There are five distinct levels of password strength: Very Weak, Weak, Fair, Strong, and Very Strong. Along with the password strength indicator, you will also get information and hints in a tooltip beside the indicator. Note that the Add button will remain inactive (grayed out) if the password level is Very Weak or Weak. Select the Enable remote option from the Remote connections options if the MySQL user will be used for accessing your databases from a remote location. Click on the Add button.

We assume you already have a SQL dump/schema file of your database on your computer, or you have it uploaded on your hosting account with us. To import the SQL dump/schema file, you have two options: Using phpMyAdminDetailed information on importing a database through phpMyAdmin is available in our Importing a database using PhpMyAdmin article. In case the SQL file that you wish to import is larger than 5-10 MB, you should use the database Import Wizard described below. Using the Import Wizard in the MySQL Databases section of your hosting Control Panel.Click on the Import button next to the database you wish to import into. After that, you can choose a file from your local computer for upload, or click on the or select an uploaded file link to import a file you have already uploaded to your account. If the database does not already exist, you need to create it first.

Here are the three easiest ways to export the SQL dump/schema file of a database: via the MySQL databases section of the hosting Control Panel through phpMyAdmin via the Backup section of the hosting Control Panel Exporting a database via the MySQL Databases section of the hosting Control Panel If you wish to export your database via the MySQL Databases section of the hosting Control Panel, follow these steps: Log in to your hosting Control Panel. Enter the MySQL Databases section. Navigate to the Databases tab. Click on the Export button next to the database you wish to export. Once the export is complete, an information () icon will appear next to your database. Click on that icon to see information about the exported MySQL dump file. Exporting a database through phpMyAdmin You can find step-by-step instructions on how to export a database through phpMyAdmin in our Exporting a database using phpMyAdmin article. Exporting a database via the Backup section of the hosting Control Panel You can use the Backup section of the hosting Control Panel to create a backup of all your MySQL databases. Detailed information on using the Backup section is available in our Backup article.

You can change the password for a MySQL user by following these steps: Log in to your hosting Control Panel. Enter the MySQL Databases section. Navigate to the MySQL users tab. Click on the Edit () button next to the MySQL user whose password you would like to change. Enter the new password for your MySQL user in the Change password and Confirm password fields.Note: You will notice that there is a password strength indicator below the Change password field. It will update in real time as you are entering your password. There are five distinct levels of password strength: Very Weak, Weak, Fair, Strong, and Very Strong. Along with the password strength indicator, you will also get information and hints in a tooltip beside the indicator. Note that the Submit button will remain inactive (grayed out) if the password level is Very Weak or Weak. Click on the Submit button.

By default, all created MySQL users are allowed to access the MySQL server locally through a script that runs on the server. In case you need to access your database using an application installed on your computer (e.g. NaviCat, MySQL Front, MySQL Control Center, or Query Browser), you need to allow remote connections for the respective MySQL user. On our servers, remote access is enabled per MySQL user, so when you enable remote connections for a MySQL user, this MySQL user will be able to connect remotely to all databases it is associated with. Enabling remote access for a MySQL user To enable remote connections for a MySQL user on our servers, you need to follow these steps: Log in to your hosting Control Panel. Enter the MySQL Databases section. Navigate to the MySQL users tab. Click on the Edit () button next to the MySQL user for which you would like to enable remote connections. Select the Enable remote option from the Remote connections options. Click on the Submit button. Once remote connections are enabled, the MySQL user will be able to connect from remote locations (e.g. from your local computer using MySQL Control Center or MySQL Front) to all databases it is associated with. MySQL settings for remote connections You can find the MySQL host and port that you need to use in your MySQL client in the MySQL Connection Settings information box from the hosting Control Panel -> MySQL Databases section. Remote access and MySQL views If you are using views in your MySQL databases, enabling/disabling remote connections for your master MySQL user may lead to problems with these views, due to the change of the type of access. Therefore, in case you have MySQL views in any of your databases, it is strongly recommended that you use a separate MySQL user for remote connections.

To associate a MySQL user with a database, you need to grant some privileges for that MySQL user to the database by following these steps: Log in to your hosting Control Panel. Enter the MySQL Databases section. Navigate to the Privileges tab. Select your database from the Database name drop-down menu. Select the MySQL user from the MySQL user drop-down menu. From the Privileges list, select the privileges that you wish to grant the MySQL user to the database. Click on the Associate button. Note: By default, your master MySQL user has full privileges over your databases. Due to security concerns, we recommend that you create and use a separate MySQL user for each software application installed on your account.

If a MySQL user does not have any privileges over a database, you should associate it with that database. Detailed instructions on the process are available in our Associating a MySQL user with a database article. To modify the privileges of a MySQL user for database, you need to follow these steps: Log in to your hosting Control Panel. Enter the MySQL Databases section. Navigate to the Privileges tab. Click on the Edit () button next to the database and MySQL user whose permissions you would like to change. From the Privileges section, select the new privileges that you wish to grant to the MySQL user. If you remove all privileges, the association between the MySQL user and the database will be removed. Click on the Associate button. Note: By default, your master MySQL user always has full privileges over your databases. Due to security concerns, we recommend that you create and use a separate MySQL user for each software application installed on your account. If you would like to remove all privileges a MySQL user has over a database, follow these steps: Log in to your hosting Control Panel. Enter the MySQL Databases section. Navigate to the Privileges tab. Click on the Remove () button next to the database and MySQL user whose permissions you would like to remove.

Deleting a MySQL database To delete a MySQL database, you need to follow these steps: Log in to your hosting Control Panel. Enter the MySQL Databases section. Navigate to the Databases tab. Click on the Delete button next to the database you wish to delete. Click OK in the confirmation window. Note: MySQL users that were associated only with the deleted database will not get deleted automatically. You should delete such MySQL users manually. Deleting a MySQL user You can delete a MySQL user by following these steps: Log in to your hosting Control Panel. Enter the MySQL Databases section. Navigate to the MySQL users tab. Click on the Delete () button next to the MySQL user you wish to delete. Click OK in the confirmation window.

First you need to create an SQL dump file from your old hosting provider server. Once you have the database SQL dump file, you need to create a database on our server and import the file. (see our Creating a MySQL database/user and Importing a database articles)

The phpMyAdmin program is available on the server, and you can use it to manage your database content. You can log into phpMyAdmin via the phpMyAdmin section of the hosting Control Panel or by using the phpMyAdmin link from the MySQL Databases section of the hosting Control Panel. Detailed information on using the phpMyAdmin program is available in the Using phpMyAdmin section of our online documentation.

If you want to grant someone else (e.g. a developer) access to a MySQL database, you should not provide them with Control Panel access; you can create an additional MySQL user for them. You can manage your MySQL databases and users at the hosting Control Panel's MySQL Databases section. If this is a new project, you should create a new database and MySQL user for it first. For security reasons, databases can be created only through the hosting Control Panel. Detailed instructions on the process are available in our Creating a MySQL database/user article. Once you have the database and MySQL user created, you should associate the MySQL user with the database by following the instructions from our Associating a MySQL user with a database article. Unless you have a reason to do otherwise, you can select all available privileges for the new MySQL user. Your developer may need direct access to the database for manual manipulations. You can provide them with a link to access the phpMyAdmin tool which is available on all our servers. Be sure to provide them with the URL of the phpMyAdmin link, not the (log in) link next to it. In case your developer needs remote access to the database via an application that is installed on their computer (e.g. MySQL Workbench), you will need to enable remote connections for their MySQL user. The process is explained in details in our Enabling remote access to a MySQL database article.If your developer needs to upload files on the server, you should create an FTP user for them. You can find step-by-step instructions on how to do this in our FTP Manager article. Important: You may wish to change the password for the MySQL user once the developer no longer needs it. However, if any software installed under your account connects through their MySQL user, you will need to update the password for that software in its corresponding configuration files.

You can create databases and assign MySQL users to them only through the MySQL Databases section of the hosting Control Panel.

The official reference manual of MySQL 5.7 can be found on the MySQL site: https://dev.mysql.com/doc/refman/5.7/en/index.html

If you want to change the MySQL time zone setting for your MySQL session, you should execute the following SQL query right after the MySQL connection has been established in your scripts: SET time_zone = 'custom_timezone'; Make sure that you replace custom_timezone with the name of the desired time zone. A list of the valid time zones is available in the zone.tab file. Please refer to the MySQL Server Time Zone Support article of the official MySQL documentation for additional information.

To access a MySQL5 database from your PHP scripts, you can provide the following database server name in your connection string: localhost Here is a sample connection string to use with MySQL 5: $link = mysqli_connect('localhost', 'mysql_user', 'mysql_password');  

To access your MySQL database from your Perl scripts, you can provide the following database server name in your connection string: localhost Here is a sample Perl DBI connection string to use with MySQL: DBI->connect('DBI:mysql:localhost:database=user_dbName', 'userID', 'password') or die "Database connection failed";