Operating system: Debian 10
OS version: Buster
Hello!
I have one problem with editing and creating db…!
Can you help me to resolve it
Best regards,
Goran
Could you describe how exactly you edit and create DBs in your Virtualmin system? Do you use the Virtualmin GUI or go about it some other way?
Yes!
In Webmin -> Servers -> MySQL Databse Server -> User Permissions I tried to make some changes 
after that I can’t to see any database Clipboard 1.png!
When I click to User Permissions I get error: Clipboard 2.png
In your attempt to make some changes, the root password of mysql has got changed. You must configure Virtualmin to use the current password of root or configure mysql root to use the currently configured Virtualmin password. Only when Virtualmin is able to access mysql as root will this error be resolved.
How to I do it?
When you installed Virtualmin, the root password that Virtualmin set for mysql was displayed on one of the screens. Do you have that stored somewhere?
If not, you will have to run the Virtuamin Post Install Wizard and apply the current password of mysql root there.
I check it, password it’s ok, because all hosted pages work fine!
I (like root) just loose all access. Backup also not work any more!
We recently fixed Virtualmin to be able to reset MySQL/MariaDB root password. If you cannot make it on your own, you could update Virtualmin MySQL library by running:
curl https://raw.githubusercontent.com/virtualmin/virtualmin-gpl/master/feature-mysql.pl -o /usr/share/webmin/virtual-server/feature-mysql.pl
… and then run the following command:
virtualmin set-mysql-pass --user root --pass 1234
Note: In the future, for users with Virtualmin 6.13+ updating internal library using curl command as exampled above, will not be necessary.
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.