mariadb root password has changed

[mark edwards]

hello - i manually changed my mariadb root password, and now webmin cannot connect anymore. is there a confile file somewhere that contains this information that needs to be manually edited?

or does webmin/virtualmin have its own username/password? its been several years since i set this up and do not remember, maybe i accidentally just used the mariadb root username/password... i forget.

[Ilia]

Hi, Mark!

Go to Virtualmin/Edit Databases -> Passwords/Change database passwords.

[mark edwards]

thanks - does this apply to some sort of master database for webmin/virtualmin? i never used webmin to create any databases, but created all the individual databases manually. note: i plan on migrating servers soon and will start with a nice CLEAN install of webmin/virtualmin.

[mark edwards]

thanks - does this apply to some sort of master database for
webmin/virtualmin? i never used webmin to create any databases, but did
all this manually. note: i plan on migrating servers soon and will start
with a nice CLEAN install of webmin/virtualmin.

Thank you,

Mark Edwards

On Tue, Jun 18, 2019 at 9:29 AM Ilia Rostovtsev rostovtsev@users.sourceforge.net wrote:

Hi, Mark!

Go to Virtualmin/Edit Databases -> Passwords/Change database passwords
.

---

mariadb root password has changed
https://sourceforge.net/p/webadmin/discussion/600155/thread/06bc6727ae/?limit=25#6955

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/webadmin/discussion/600155/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

[Ilia]

For administrative password go to Webmin tab, then Servers/MySQL Database Server -> Change Administration Password.

[Ilia]

In order to migrate it, I would simply back up /var/lib/mysql/ directory. You would need to tar it with keeping permissions using -p switch. You would need to chcon for right attrs in case you use SELinux.

It's also possible to preserv all kind of permissions by running:

tar --selinux --acls --xattrs -cvf mysql_backup.tar /var/lib/mysql

[mark edwards]

😃😃😃😃😃😃😃😃😃😃
personally, i like to use "mysqldump" when migrating a database. at least that way it tends to fix any hidden issues (although recently i had a mysqldump script with an error, surprinsingly)