When a new user is added to a virtual server with a database access, the user/password doesnt work in mysql. This happens if the username format is set to user.domain in server templates.
I changed the username format to user@domain and it only works if we choose a username that makes username@domain less than 16 characters. in fact the username is truncated by mysql (for mysql < 5.7.8)
To fix this bug I think it's better to move the database user creation from Edit users to Edit databases page so that users can manage their database users there where virtualmin takes account of database username limitations
Mos
Status:
Active
Comments
Submitted by andreychek on Sat, 04/15/2017 - 08:37 Comment #1
Howdy -- Jamie may need to comment on this, but just to make sure he has all the info you need -- can you verify your MySQL/MariaDB version?
To do that, what is the output of this command:
mysql -VSubmitted by JamieCameron on Sat, 04/15/2017 - 11:48 Comment #2
MySQL will always truncate usernames to 16 characters, regardless of whether the username format contains a dot or @.
Submitted by JamieCameron on Sat, 04/15/2017 - 11:51 Comment #3
On the Edit User page, it will also show the truncated MySQL username - make sure you enter that correctly when connecting to the DB.