MySQL


Topic Replies Created
How have I fixed «InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.» 1 February 20, 2019
How to escape a single quote within a password of mysqldump? 1 December 5, 2018
How to order MySQL databases by size? 1 July 29, 2018
How do I fix «The user specified as a definer ('<user>'@'%') does not exist»? 2 April 28, 2018
How to fix the «Could not increase number of max_open_files to more than 1024» MySQL issue? 1 May 18, 2017
How to change a MySQL user's password via phpMyAdmin? 1 May 28, 2018
How to create a new database via phpMyAdmin? 1 May 28, 2018
How to fix «The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled» in MySQL 5.7? 2 March 3, 2018
How to allow remote connects to a MySQL server? 1 February 22, 2018
My my.ini for my localhost-only Windows machine 1 April 30, 2017
How to fix the «'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled» Backupninja / Duplicity warning about backup a MySQL database? 2 May 19, 2017
How to fix the «Function (archive, blackhole, federated, innodb) already exists» MySQL issue? 2 May 18, 2017
How to split an all databases MySQL dump into separate files for each database? 1 April 30, 2017
How to register a new user with the full administrative rights in MySQL 1 April 30, 2017
How to workaround the «mysql_upgrade» freeze error? 1 April 30, 2017
How to remove the «SSL context is not usable without certificate and private key» warning for a localhost-only MySQL server? 1 April 30, 2017
How to fix the «Cannot open datafile for read-only» / «Could not find a valid tablespace file» MySQL error for an intentionally deleted database? 1 April 29, 2017
How to remove the «Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location» MySQL warning? 1 April 29, 2017
How to remove the «Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path» MySQL warning? 1 April 29, 2017
How to resolve the «'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' "sql modes should be used with strict mode» MySQL warning? 1 April 29, 2017
How to resolve the «TIMESTAMP with implicit DEFAULT value is deprecated» MySQL warning? 1 April 29, 2017