How to fix the sys.host_summary table in MariaDB

by | Dec 30, 2019 | mariadb

The sys schema is not bundled with 10.3, but seems to be planned for 10.5. If you don’t use/need it, you can safely remove it: DROP DATABASE sys;. If you do need it, you need to try resolving the issue outlined in the error message. For a start you can...

Reset the MariaDB Root Password

by | Nov 27, 2019 | mariadb

If you forget your root MariaDB password, don’t worry and be sad because it can be reset easily with this tutorial.Stop the current MariaDB server instance, then restart it with an option to not ask for a password: $ sudo systemctl stop mariadb $ sudo mysqld_safe...