How to Disable MySQL Strict Mode
To Disable MySQL Strict Mode, edit Add under [mysqld] section Verify MySQL Strict Mode To check if MySQL is running
Find all MySQL databases using InnoDB engine
To find all MySQL database using InnoDB MySQL engine, run MySQL
MySQL root can’t login to phpMyAdmin
On Debian/Ubuntu MySQL root user can only login using socket. This is done with Plugin. To fix this, first set
MySQL Optimize
Optimize MariaDB Edit file Find On this section, you will see “#skip-external-locking”, add below. This is some basic settings. Now
MySQL
MySQL Cluster MySQL 8 Find all MySQL databases using InnoDB engine Find MySQL Server Version Find MySQL Database and Table
Reset MySQL root Password
To reset MySQL root password, stop MySQL Start MySQL with Start another terminal, login to MySQL as root Run following
MySQL User
Create a user For local mysql access To allow remote access, run To allow a user to create another user
Debian Allow MySQL root user to login using phpMyAdmin
On Debian/Ubuntu by default MySQL root user can only login from local accounts. To enable login from phpMyAdmin, you need
Configuring MySQL .my.cnf
Add following content Replace DBPASSWORD with your MySQL root password. Now set permission for this file to 600, so no
InnoDB: space header page consists of zero bytes in tablespace
On a server, starting MySQL i get following error This was because the server used InnoDB database engine and my.cnf
myisamchk: Argument list too long
When repairing a large database, i got following error To fix the error, run SOLUTION 1 SOLUTION 2 See MySQL