String is too long for mysql user name

trellis
#1

Trellis uses the domain name as the mysql user name but I’m trying to provision a new server and the domain is quite lengthy. Mysql has a limit of 16 characters on the user name.

Where is the username set in trellis? So that I might change it to something shorter.
Or how can I update the mysql version Trellis is using to the version where 32 characters are allowed?

Thanks

1 Like
#2
1 Like
#3

That’s exactly what I was looking for. I missed that in the docs. Thanks!

1 Like
#4

No problem. This should ideally be fixed in Trellis itself so you wouldn’t need to manually make any changes. Would you mind reporting an issue about this on the GitHub repo?

1 Like
#5

How long is your domain name?

There’s no way we wouldn’t have heard more complaints about this if the limit was really 16. We use MariaDB and it looks like theirs is 80 characters: https://mariadb.com/kb/en/library/identifier-names/#maximum-length

1 Like