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, …
How to fix the sys.host_summary table in MariaDB Read More »
Login to mariadb use mysql; ALTER TABLE mysql.user MODIFY `User` varchar(30) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT ”; SHOW COLUMNS FROM mysql.user;
Error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation solution: download the SQL file then import it as a root user then give permission to the same database with the IP based user. GRANT ALL PRIVILAGES ON tacportal_db.* to [email protected]’IP’ IDENTIFIED BY ‘tacportal_db’;
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 …