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