• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Issue Problems with Database/phpMyAdmin

Azurel

Silver Pleskian
1. In Plesk Obsidian (centOS 7.8) for "Database Hosting Settings" is set as "Allow remote connections from any host". For security reason and most users don't use external connections, thats a bad default value. The default value should be "Allow local connections only".

2. In phpMyAdmin you see information about "Database server" in sidebar. Here is vor "Server charset" as value "cp1252 West European (latin1)". What is that? In every modern system this should be "Server charset: UTF-8 Unicode (utf8mb4)".
  • Server: Localhost via UNIX socket
  • Server type: MariaDB
  • Server connection: SSL is not being used
  • Server version: 10.1.45-MariaDB - MariaDB Server
  • Protocol version: 10
  • User: *****@localhost
  • Server charset: cp1252 West European (latin1)

3. In phpMyAdmin you see in block "General settings" with value "utf8_unicode_ci". Its impossible to set it as "utf8mb4_unicode_ci". Its jump every time back to "utf8_unicode_ci".


#1 I can change quite simple, but how I can change #2 and #3?
 
Back
Top