MySQL


How to change a MySQL user's password via phpMyAdmin? (1)
How to create a new database via phpMyAdmin? (1)
How do I fix «The user specified as a definer ('<user>'@'%') does not exist»? (1)
How to fix the «Could not increase number of max_open_files to more than 1024» MySQL issue? (1)
How to fix «The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled» in MySQL 5.7? (2)
How to allow remote connects to a MySQL server? (1)
My my.ini for my localhost-only Windows machine (1)
How to fix the «'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled» Backupninja / Duplicity warning about backup a MySQL database? (2)
How to fix the «Function (archive, blackhole, federated, innodb) already exists» MySQL issue? (2)
How to split an all databases MySQL dump into separate files for each database? (1)
How to register a new user with the full administrative rights in MySQL (1)
How to workaround the «mysql_upgrade» freeze error? (1)
How to remove the «SSL context is not usable without certificate and private key» warning for a localhost-only MySQL server? (1)
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)
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)
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)
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)
How to resolve the «TIMESTAMP with implicit DEFAULT value is deprecated» MySQL warning? (1)