2 votes
Accepted

MySQL connections peak right after restart

Most likely this is due to the MySQL caches / buffer pool being empty after restart, and therefore the first queries go straight to the hard disk. This makes the queries last longer, and therefore ...
user avatar
1 vote
Accepted

Unable to log in to MySQL

If you can connect locally with something else like php then your credentials may not have remote access. What else you can do: - Make sure that there is no firewall blocking access to MySQL. Make ...
user avatar
  • 2,920
1 vote

MySQL database name with hyphen

Specifically to your question about using a different name while restoring: with mysqldump you can either do mysqldump databasename or mysqldump --databases databasename. The former doesn't put a ...
user avatar
  • 7,791
1 vote

mysql doesn't start after relocating data dir

In case if there is no AppArmor search for selinux because on most of the rpm based linux you will see selinux. Just disable it. #setenforce 0 #getenforce Getenforce command will give you permssive....
user avatar
  • 11

Only top scored, non community-wiki answers of a minimum length are eligible