by sarkarijob | 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...by sarkarijob | Dec 30, 2019 | mariadb
Login to mariadbuse mysql;ALTER TABLE mysql.user MODIFY `User` varchar(30) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT ”;SHOW COLUMNS FROM mysql.user;by sarkarijob | Nov 28, 2019 | mariadb, mysql
Error: Access denied; you need (at least one of) the SUPER privilege(s) for this operationsolution: 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...by sarkarijob | 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...