Published onApril 13, 2023Connect Remote MySQL Database Through SSH TunnelingMySQLmysql -u remote_db_user -h 127.
Published onDecember 17, 2022mysqldump: Got error: 1044: Access denied for user 'username'@'localhost' to database 'databasename' when using LOCK TABLESMySQL
Published onDecember 16, 2022Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespacesMySQL
Published onDecember 15, 2022mysqldump throws: Unknown table 'COLUMN_STATISTICS' in information_schema (1109)MySQLThis is due to a new flag that is enabled by default in **mysqldump 8**.
Published onJune 15, 2022Copy MySQL data folderMySQLI often install different Linux OS, to save the time for MySQL setup, do the following.
Published onJanuary 22, 2021InnoDB vs MyISAMMySQLMyISAM has `FULLTEXT` search indexes, InnoDB did not until MySQL 5.