I'm not sure what's happening but it's since a while that I'm experiencing using my dev site (running on a VM) on the local Ubuntu machine. The site runs on a Wordpress instance using MySQL setup to use innodb table on a separate folder. I don't have permission problems, as far as I know.
It I try to use MySQL CLI I can query the database without problems; the same using phpmyadmin. But when it comes to access via the site it takes ages and more often than not I need to stop the service.
And that's again another symptom something doesn't work as it should.
Stopping the service via
sudo service mysql stop I can see it immediately stops (phpmyadmin can't log in anymore) but the command line prompt keep on hold like it is working.
The only way I have to get the CLI ready is to brutally stop the service with a CTRL+C.
Any idea of what's wrong? Thanks