Hello and good morning to all.
I look forward to your comments and suggestions.
eris
May 3, 2022, 2:52pm
2
Yes
backup all databases…
apt remove mariadb-client mariadb-common mariadb-server
Modify /etc/apt/sources.list.d/mariadb.list
apt install mariadb-client mariadb-common mariadb-server
Run:
# Securing MariaDB installation
mpass=$(gen_pass)
echo -e "[client]\npassword='$mpass'\n" > /root/.my.cnf
chmod 600 /root/.my.cnf
# Ater root password
mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '$mpass'; FLUSH PRIVILEGES;"
# Allow mysql access via socket for startup
mysql -e "UPDATE mysql.global_priv SET priv=json_set(priv, '$.password_last_changed', UNIX_TIMESTAMP(), '$.plugin', 'mysql_native_password', '$.authentication_string', 'invalid', '$.auth_or', json_array(json_object(), json_object('plugin', 'unix_socket'))) WHERE User='root';"
# Disable anonymous users
mysql -e "DELETE FROM mysql.global_priv WHERE User='';"
# Drop test database
mysql -e "DROP DATABASE IF EXISTS test"
mysql -e "DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%'"
# Flush privileges
mysql -e "FLUSH PRIVILEGES;"
If you need phpmyadmin / roundcube make sure to add the database / users again
it’s not working to remove old software.
