MySQL server settings (my.cnf) can only be updated via CLI, it would be faster if these changes could be made in Plesk Panel or PHPMyAdmin without the need to edit settings on server.

Add possibility to change the server host for remote database in Plesk

Microsoft SQL Server 2022 was released several months ago. We'd like to provide our customers services using this DB engine. Could you please add its support into Plesk?

> Drivers

With MySQL and MariaDB going their own way more and more, it is important to add MariaDB Connector/ODBC as an programming interface to Plesk as well. Side by side with the already available MySQL Connector/ODBC. This is easily done.

One cannot guarantee MySQL Connector/ODBC to be compatible with MariaDB in the near future.

Download MariaDB Connector/ODBC from here:
https://mariadb.com/kb/en/mariadb-connector-odbc-3113-release-notes/

Add diskspace calculation for remote PostgreSQL databases

Allow the user to configure Database Servers to connect over SSL, specifying SSL certificate, CA certificate and SSL key. Currently, this has to be done manually via phpMyAdmin config file at /usr/local/psa/phpMyAdmin/config.inc.php.

Sometimes Plesk is not accessible with error:
DB query failed: "SET sql_mode = ''" Error: SQLSTATE[08004] [1040] Too many connections

It is possible to inrease the number of connections but it will also be good to have some monitoring of the current number of simultaneous connections to the MySQL, for example in Advanced Monitoring extension.

It will help to prevent Plesk downtime and set the reasonabl limit for max_connections

It is required to import databases created externaly with dbo database schema.

When such database imported in Plesk it is assigned to schema of the database user created in Plesk. When user created in Plesk, new schema is created for database user. For example, user test1 created in Plesk will have database schema "test1"

This results to the non-functional Database due to wrong schema (reuqired dbo, while database imported with schema test1).

The suggestion is to add functionality to select schema when creating database users in Plesk

I would like to suggest the possibility to associate the same database user to specific databases of the same subscription.

As an example:

Subscription example.com:

Databases: Example1, example2, example3

Database users: user1 and user 2

At the moment user can only be associated via the Plesk panel to an specific database or "any"

But in case I need/want to associate the user1 to example1 and example2 it's not possible.

Add the ability to encrypt databases as Transparent Data Encryption (TDE) via Plesk interface, which is supported in MariaDB 10.1 and later.

At-rest encryption means the data files and logs are encrypted on the disk and makes it almost impossible for someone to access or steal a hard disk and get access to the original data (provided that the key is secured and not stored locally).

Protect databse from accidental removal, so the database behaves in the same way as the following wordpress_e: greyed out so it cannot be deleted.

The possibility to set the PostgreSQL Charset from ASC_II to UTF8 during a database creation.

Ability to manage ODBC connection in Plesk for Linux.

Disallowing using special characters (period, minus, backtick) in database names when database is created. This would reduce database errors caused by database names in wrong format.

It would be nice to be able to create multiple databases for the same domaine withour being forced to create a new user.

Allow to chose another charset when creating a database or do not set one.

Plesk does use:
"CREATE DATABASE databasename /*!40101 default charset=utf8 */"
And with this does overwrite when the MySQL config was changed to use utf8mb4 for example.

Or allow to choose a charset on creation or create DBs with:
"CREATE DATABASE databasename"

On the attempt to clone database with DEFINER Plesk failed if there is no the same user on destination database.

Currently, it is required either manually remove definer from database dump or add super priveleges: https://support.plesk.com/hc/en-us/articles/360005033014-Unable-to-import-MySQL-dump-using-Import-Dump-feature-in-Plesk-ERROR-1227-42000-at-line-1421-Access-denied-you-need-at-least-one-of-the-SUPER-privilege-s-for-this-operation

Since Mysql version 5.7.8 it is possible to use the --skip-definer option with mysqldump:
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html

The suggestion is to add ability to clone database skipping definers as option in Plesk GUI

A table in the Databases section where you can enter all values like memory and upload amount. So you could optimize the allocation of the working memory better. But also see what values each web page or database has.