Hi Guys,
So cPanel used to have an 8 char limit on the usernames and this then got changed (to 16 characters I believe) - which is great. However, this brings another issue because MySQL usernames and database names were left at 16 characters.
This means if one creates a user with a long username, there is no space left for MySQL and then it just gives errors when trying to create users / db's.
I created a user recently, and cpanel automatically gave me a username based off the domain name (purpose of this demonstration, domain is 123456guestrooms.com and the username was 123456guestrooms).
I just got errors when trying to create MySQL users / db's and eventually figured this out - then just recreated the account with a smaller username (123456) and bob's your uncle - it worked.
So, in short:
Account username 16 char limit
MySQL username / database = 16 char limit
If account username = 16 char limit; then there are no characters left to create database users / database names.
Shouldn’t the account username limit be 14 characters so there is at least space for and under score and 1 character? Or, preferably, and from my understanding, MySQL now supports 32 characters so just update the mysql 16 character limit to 32?
So cPanel used to have an 8 char limit on the usernames and this then got changed (to 16 characters I believe) - which is great. However, this brings another issue because MySQL usernames and database names were left at 16 characters.
This means if one creates a user with a long username, there is no space left for MySQL and then it just gives errors when trying to create users / db's.
I created a user recently, and cpanel automatically gave me a username based off the domain name (purpose of this demonstration, domain is 123456guestrooms.com and the username was 123456guestrooms).
I just got errors when trying to create MySQL users / db's and eventually figured this out - then just recreated the account with a smaller username (123456) and bob's your uncle - it worked.
So, in short:
Account username 16 char limit
MySQL username / database = 16 char limit
If account username = 16 char limit; then there are no characters left to create database users / database names.
Shouldn’t the account username limit be 14 characters so there is at least space for and under score and 1 character? Or, preferably, and from my understanding, MySQL now supports 32 characters so just update the mysql 16 character limit to 32?