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)".
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?
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?