MySQL

To find all MySQL database using InnoDB MySQL engine, run mysql -N mysql -e “SELECT table_schema … Find all MySQL databases using InnoDB engineRead more

To Disable MySQL Strict Mode, edit vi /etc/my.cnf Add under [mysqld] section sql_mode = “” Verify … How to Disable MySQL Strict ModeRead more

When i restore a MySQL database backup taken on MairaDB 10 on MySQL 5.5, i get … MySQL Unknown collation: utf8mb4_unicode_520_ciRead more

When i try to restore a MySQL database, i get following error. [root@server2 ~]# mysql sok_wp … ERROR 2006 (HY000) at line 348: MySQL server has gone awayRead more

If you have MYSQL root password and want to change the MySQL root password, first log … Change MySQL root passwordRead more

Change MySQL Password Reset MySQL root password MySQL Password Reset Errors

To find MySQL server version, connect to MySQL, then run select version(); You can also use … Find MySQL Server VersionRead more

To create a user with “root” privileges, you need to find what privileges root has, this … MySQL create user with root privilegesRead more

On a Cpanel Server, MySQL did not start. I checked the error log in /var/lib/mysql folder, … Can’t open and lock privilege tables: Table ./mysql/db is marked as crashedRead more

Can’t open and lock privilege tables: Table ‘./mysql/db’ is marked as crashedMySQL Can’t create new tempfilemysqlcheckHow … MySQL RepairRead more