My root mysql user has no password, every time i try to log in to mysql via command line and change the password it says access denied for user ‘’@localhost like I’m not using a username. I try to change it from the virtualmin interface and the same result happens.
in webmin-servers-mysql database server and then click in the right screen at the top on module config.
do you see: Administration login Automatic
Administration password Don’t change Set to?
what if you changed Administration Login from automatic to root and then set a password?
My root username has no password… that’s the problem. I dont know how to give my root username a password either.
I tried what you said and it didn’t work. always said failed to connect with username pass.