MySQL Management

Last updated October 1, 2025

MySQL is a database management system used for storing and processing structured data. In a DBaaS environment, you get a managed database cluster without the need for manual configuration: everything is handled automatically.

When creating a cluster, you can choose the MySQL version: 8.0 or 8.4.

Creating Databases

When you create a new cluster, a database named default_db is created automatically.

You can create additional databases:

Go to the Databases section of your Hostman dashboard.
Click on the cluster.
In the Databases tab, click Add.

Provide a name for your database: 3–64 characters. Letters, numbers, and special characters are allowed.
Add a description, if necessary.
Click Create.

Database Import

To import a database:

Go to the Databases section of your Hostman dashboard.
Click on the cluster.
In the Databases tab, click Import.
Enter the connection details for the database you want to import.
Click Start import.

Requirements and Limitations

Network Access: The source database must be accessible for connection from the internet from any IP address. Without this, the import will not start.
Unique Name: The target cluster must not contain a database with the same (identical) name.

What will be transferred:

Table structures
Data in tables

What will not be transferred:

Users

You will need to create users manually in the new database, after the import.

Before running the import, we recommend temporarily reducing the innodb_buffer_pool_size parameter to 50% of the RAM allocated to the database.

Users and Privileges

In your Hostman dashboard, you can manage MySQL users and their privileges.

Creating Users

When a new cluster is provisioned, it automatically includes a database user named gen_user. You can add more users in the Users tab of the interface.

Go to the Databases section and click on the cluster.
Open the Users tab and click Add.

Set the username and password:

Username: 3–32 characters. Letters, numbers, and special characters are allowed.
Password: 8–30 characters. Letters, numbers, and special characters are allowed.

(Optional) Configure the user’s privileges. You can also leave the default parameters and change them later at any time.
Click Create.

Modifying Privileges

To update the privileges of an existing user:

Go to the Databases section and click on the cluster.
Open the Users tab.
Click the three dots next to the user.
Select Privileges.

Choose the required privileges. You can grant access to a specific database or grant the same privileges for all databases by enabling Identical for all databases in the top right.

Available Privileges

Privilege	Description
`USAGE`	Basic privilege that allows login without access to objects.
`SELECT`	Read data from tables and views.
`INSERT`	Add new records.
`UPDATE`	Modify existing records.
`DELETE`	Remove records.
`CREATE`	Create new tables, indexes, and other objects.
`DROP`	Remove objects such as tables or databases.
`REFERENCES`	Use foreign keys.
`INDEX`	Create and drop indexes.
`ALTER`	Modify the structure of existing tables.
`LOCK TABLES`	Use manual table locking.
`CREATE VIEW`	Create views.
`SHOW VIEW`	Display the structure of existing views.
`CREATE ROUTINE`	Create stored procedures and functions.
`ALTER ROUTINE`	Modify stored procedures and functions.
`EVENT`	Create and manage events (`EVENT SCHEDULER`).
`TRIGGER`	Create and drop triggers.
`SELECT` on `slow_log`	Read access to the system slow query log table.
`DROP` on `slow_log`	Ability to clear the contents of the `slow_log` table.

Changing User Password

You can change the user password:

Go to the Database section and click on the cluster.
Go to the Users tab.
Click the three dots next to the user.
Select Change password.
Enter a new value and save changes.

Database Parameters

You can change database settings to optimize its performance.

By default, the database is created with the parameters that are suitable for most tasks and will ensure the performance of the selected configuration. However, if your project requires specific settings, you can change them as you wish.

Be careful and change parameters only if you are sure of their purpose. Incorrect configuration can negatively affect the operation of the database and its performance.

Changing Parameters

Go to the Databases section and click on the cluster.
Go to the Configuration tab.
Click Modify parameters next to Database parameters.

Adjust the parameters. To read more about each parameter, click Open description next to it.

Click Apply at the bottom of the page.

Available parameters depend on the selected MySQL version.

MySQL 8.0 Parameters List

Parameter	Valid Values	Default Value
auto_increment_increment	1–65535	1
auto_increment_offset	1–65535	1
innodb_io_capacity	100–4294967295	1500
innodb_purge_threads	1–32	4
innodb_read_io_threads	1–64	4
innodb_thread_concurrency	0–1000	0
innodb_write_io_threads	1–64	4
innodb_log_file_size	4194304–274877906944	214748365
join_buffer_size	128–18446744073709551488	67108864
max_allowed_packet	1024–1073741824	16777216
max_heap_table_size	16384–18446744073709550592	16777216
max_connections	1–100000	49
sql_mode	See documentation	—
sort_buffer_size	32768–18446744073709551615	14680064
thread_cache_size	0–16384	128
innodb_flush_log_at_trx_commit	0–2	1
transaction_isolation	—	read-uncommitted
long_query_time	0–31536000	10
tmp_table_size	1024–18446744073709551615	16777216
table_open_cache	1–524288	4970
table_open_cache_instances	1–64	16
innodb_flush_method	—	O_DSYNC
innodb_strict_mode	On/Off	On
slow_query_log	On/Off	On
binlog_cache_size	4096–18446744073709547520	32768
binlog_group_commit_sync_delay	1–1000000	1
binlog_row_image	—	full
binlog_rows_query_log_events	On/Off	Off
character_set_server	—	utf8
explicit_defaults_for_timestamp	On/Off	On
group_concat_max_len	4–18446744073709551615	1024
innodb_adaptive_hash_index	On/Off	On
innodb_lock_wait_timeout	1–1073741824	50
innodb_numa_interleave	On/Off	Off
net_read_timeout	1–31536000	30
net_write_timeout	1–31536000	1
regexp_time_limit	0–2147483647	32
sync_binlog	0–4294967295	1
table_definition_cache	400–524288	2000
log_bin_trust_function_creators	On/Off	On
skip_name_resolve	On/Off	Off
innodb_buffer_pool_size	5242880–18446744073709551615	858993459
wait_timeout	1–31536000	28800
interactive_timeout	1–31536000	28800
default-time-zone	-13:59–+14:00	—

MySQL 8.4 Parameters List

Parameter	Valid Values	Default Value
auto_increment_increment	1–65535	1
auto_increment_offset	1–65535	1
innodb_io_capacity	100–4294967295	1500
innodb_purge_threads	1–32	4
innodb_read_io_threads	1–64	4
innodb_thread_concurrency	0–1000	0
innodb_write_io_threads	1–64	4
innodb_log_file_size	4194304–274877906944	214748365
join_buffer_size	128–18446744073709551488	67108864
max_allowed_packet	1024–1073741824	16777216
max_heap_table_size	16384–18446744073709550592	16777216
max_connections	1–100000	49
sql_mode	See documentation	—
sort_buffer_size	32768–18446744073709551615	14680064
thread_cache_size	0–16384	128
innodb_flush_log_at_trx_commit	0–2	1
transaction_isolation	—	read-uncommitted
long_query_time	0–31536000	10
tmp_table_size	1024–18446744073709551615	16777216
table_open_cache	1–524288	4970
table_open_cache_instances	1–64	16
innodb_flush_method	—	O_DSYNC
innodb_strict_mode	On/Off	On
slow_query_log	On/Off	On
binlog_cache_size	4096–18446744073709547520	32768
binlog_group_commit_sync_delay	1–1000000	1
binlog_row_image	—	full
binlog_rows_query_log_events	On/Off	Off
character_set_server	—	utf8
explicit_defaults_for_timestamp	On/Off	On
group_concat_max_len	4–18446744073709551615	1024
innodb_adaptive_hash_index	On/Off	On
innodb_lock_wait_timeout	1–1073741824	50
innodb_numa_interleave	On/Off	Off
net_read_timeout	1–31536000	30
net_write_timeout	1–31536000	1
regexp_time_limit	0–2147483647	32
sync_binlog	0–4294967295	1
table_definition_cache	400–524288	2000
log_bin_trust_function_creators	On/Off	On
skip_name_resolve	On/Off	Off
innodb_redo_log_capacity	8388608–137438953472	104857600
innodb_buffer_pool_size	5242880–18446744073709551615	858993459
wait_timeout	1–31536000	28800
interactive_timeout	1–31536000	28800
default-time-zone	-13:59–+14:00	—

Resetting Parameters

You can easily restore the default parameters:

Go to the Databases section and click on the cluster.
Go to the Configuration tab.
Click Modify parameters next to Database parameters.
Scroll down to the bottom of the page and click Restore default settings.

Connecting to the Database

You can connect to your databases using a web interface or a terminal. Connecting via a web interface is possible only if the cluster has a public IP address.

Adminer and phpMyAdmin

You can connect to the database via the built-in web interfaces: Adminer or phpMyAdmin.

Go to the Databases section and click on the cluster.
Click the Web Interface button and select the preferred option.

Terminal

Install the MySQL client:

Ubuntu:

sudo apt install mysql-client

Debian:

sudo apt install mariadb-client

Arch:

sudo pacman -S percona-server-clients

Fedora:

sudo dnf install mysql

There are two ways to connect to a MySQL cluster:

via public IP;
via private IP.

You can copy the connection command from:

the Dashboard tab;

the Connection tab.

Creating a Dump

To create a dump, run the following command:

mysqldump --set-gtid-purged=off -y -u gen_user -p'password' -h ip_dbaas default_db | gzip > default_db.sql.gz

Here:

--set-gtid-purged=off excludes the SET @@GLOBAL.GTID_PURGED command, which may cause errors if privileges are insufficient.
-y (--no-tablespaces) excludes tablespaces, preventing possible errors during dump creation.

Importing a Dump

To import a dump, run:

cat default_db.sql.gz | gzip -d | mysql -u gen_user -p'password' -h ip_dbaas default_db

This command decompresses the dump and pipes it into the MySQL client for execution.

Basic Plan Limitations

The basic database plan (1 CPU / 1 GB RAM / 20 GB NVMe) has the following technical limitations:

Additional databases cannot be added
Additional users cannot be added
The following parameters cannot be configured:
- innodb_buffer_pool_size
- sort_buffer_size
- max_connections
- join_buffer_size
- thread_cache_size

Creating Databases Copy link

Database Import Copy link

Requirements and Limitations Copy link

Users and Privileges Copy link

Creating Users Copy link

Modifying Privileges Copy link

Available Privileges Copy link

Changing User Password Copy link

Database Parameters Copy link

Changing Parameters Copy link

MySQL 8.0 Parameters List Copy link

MySQL 8.4 Parameters List Copy link

Resetting Parameters Copy link

Connecting to the Database Copy link

Adminer and phpMyAdmin Copy link

Terminal Copy link

Creating a Dump Copy link

Importing a Dump Copy link

Basic Plan Limitations Copy link

Creating Databases

Database Import

Requirements and Limitations

Users and Privileges

Creating Users

Modifying Privileges

Available Privileges

Changing User Password

Database Parameters

Changing Parameters

MySQL 8.0 Parameters List

MySQL 8.4 Parameters List

Resetting Parameters

Connecting to the Database

Adminer and phpMyAdmin

Terminal

Creating a Dump

Importing a Dump

Basic Plan Limitations