Resolved MariaDB username length

[Kaspar]

There seems to a limit of 16 characters for the name of a MariaDB database user on my Obsidian 18.0.31 (Maria DB 10.2.36) installation. Which seems rather short. Because MariaDB supports up to 80 characters for a user name.



I found this Plesk uservoice request for longer user names from a few year back marked a finished. Which makes me wonder. Is the user name limit for MariaDB reverted back to 16? Or do I have to manually change some settings to take advantage of longer user names?

 

[Bitpalast]

Which version of MariaDB do you have? Not all version support long names.

 

[Kaspar]

Which version of MariaDB do you have? Not all version support long names.

@Peter Debik version 10.2.36. Which supports user names up to to 80 characters if I am not mistaken.

 

[Bitpalast]

MariaDB 10.x and newer support 80 characters as a user name. Please verify that you really have MariaDB 10.2 by running:
# plesk db
Then check the welcome message of the engine.

If you have verified that this is really version 10.2, please refer to the comments underneath this article for further information:

Migration or Site import fails: Unable to add database user: Database user name is invalid

Applicable to: Plesk Onyx for Linux Symptoms Unable to migrate a database in Tools & Settings > Migration & Transfer Manager > source server or via Site import extension, when a ...

support.plesk.com

 

[Kaspar]

Thank you Peter. Running MYSQL_PWD=$(cat /etc/psa/.psa.shadow) mysql_upgrade -uadmin as suggested in the comments from the article you've linked to solved my issue. Now I can enjoy longer user names