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 ...
- 33.3k
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 ...
- 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 ...
- 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....
- 11
Only top scored, non community-wiki answers of a minimum length are eligible