It took me 4 hours to realize that Webmin/Virtualmin has been setting a wrong password for MYSQL user.
What i did/wanted to do was to create a second user for a site, so that would be the user to access sites db.
Everything was okay, i have created it and added the corresponding database to it, but when i tried to connect to DB it said :
Access denied for user ‘myuser’@‘localhost’ (using password: YES)
After trying to change 983475893 permissions and privileges, re-setup the password(from virtualmin panel, from webmin panel) and everything, it didnt work.
Finally i tried to go to MYSQL with the root user and changed the newly created user password to what i have been trying to set for 4 hrs.
And voila, when i set the password from MYSQL directly(using 3rd party app) i managed log in.
So my question is - Are there any password policies for MYSQL password or its a bug that Virtualmin inserts wrong password ?
The password that i tried to set was: M2|2T’*88%wg9y
Maybe the field is being parsed wrong or something like that happens, probably.
I tend to believe that ""character may break it but cant confirm it, haven’t investigated any further.