MySQL Troubleshoting

# jika merubah lokasi folder data mysql, saat restart service error, di system viewer log Could not open file '.\KPBVDC98.err' for error logging: Bad file descriptorFor more information, solusi: tambahkan user NETWORK SERVICE di folder yang baru.

# Error: In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column
# hapus ONLY_FULL_GROUP_BY di sqlmode

# ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
# fix: edit vi /etc/my.cnf, kemudian uncomment atau hapus bind-address=127.0.0.1
# jika ada konfigurasi bind-address=<IP>, silahkan login menggunakan IP tersebut