Problem with MySQL

[pmaechler]

System: Windows 8.1 64-Bit
Vagrant: 1.7.4
VirtualBox: 4.3.30

Steps to reproduce:

1. Clone the repository
2. vagrant up
3. Waiting the box has been downloaded
4. Already there the MySQL can not be started
5. vagrant provision
6. Error that the MySQL can not be started
7. Open http://foobar.dev/phpmyadmin
8. Try to login with root and vagrant

Expected result:
Everything starts properly. Login to MySQL works.

Result:
The MySQL service is not started and can not even been started via vagrant ssh 'service mysql start'.

Solution:
The solution for me was to reinstall the mysql server. This manual helped me: http://askubuntu.com/questions/392438/mysql-job-failed-to-start
See the second answer.

[mrimann]

Thanks for the detailed bug report - ah would it be nice if all reports would be like this one :-)

Unfortunately I was not able to reproduce this issue, even with throwing away my existing box and starting over completely with a fresh box...

[lorenzulrich]

I had the same problem and turned out that /etc/mysql/my.cnf was world-writable:

Warning: World-writable config file '/etc/mysql/my.cnf' is ignored

After changing it to 644, mysql could be started. Because this problem also appeared at the initial puppet run, the root password wasn't set to vagrant so I had to reset it manually.

I have no puppet knowledge but I guess that the file permission should be set when adding the my.cnf file.