MySQL Commands

Repair all databases from root user

mysqlcheck --auto-repair --check --all-databases

Check all databases from root user

mysqlcheck --check --all-databases

Check for MySQL skip_name_resolve if phpMyAdmin gives errors

mysql> show variables like "skip_name_resolve";
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| skip_name_resolve | ON    |
+-------------------+-------+

Turn off MySQL strict mode

echo 'sql_mode="ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"' >> /etc/my.cnf; service mariadb restart;