How to fix the sys.host_summary table in 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 do SHOW CREATE VIEW sys.host_summary; to see which tables, … Read more

Reset the MariaDB Root Password

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 –skip-grant-tables & Reconnect to the MariaDB server with … Read more

Pin It on Pinterest

Open chat