MySQL server start issues on Mavericks

Question

I am having difficulty using MySQL on my MacBook, I am trying to start my server using `sudo mysqld_safe` and this results in the following output: ``` 140131 00:03:02 mysqld_safe Logging to '/usr/local/var/mysql/david-mbp.err'. 140131 00:03:02 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql 140131 00:03:03 mysqld_safe mysqld from pid file /usr/local/var/mysql/david-mbp.pid ended ``` I had a look at this question and it has all the same issues and methods I have tried to resolve my issues. His fix was the upgrade to Lion but I am already on the latest version of Mavericks so this is not a viable solution for me. I have googled around and reinstalled numerous times but haven't managed to find why I get this issue. How can I fix this issue? Edit: ``` 140131 00:03:02 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql 2014-01-31 00:03:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_…

Accepted Answer

File permissions are definitely the cause of the issue. There are far better experts than me, but I recommend the following:

Ensure your entire data directory is owned by the `_mysql` user with permissions `drwxr-xr-x`.

In your case, it appears that your MySQL installation directory is your data directory. My data directory is in a subdirectory of the installation directory.

You can probably get up and running by changing permissions per the command:

```
sudo chown -R _mysql:admin /usr/local/var/mysql
sudo chmod -R u+rwX,g+rwX,o-rwx /usr/local/var/mysql
```

This may limit your `dave` account from accessing the mysql installation directory without `sudo`, so you may wish to tweak these permissions to include `g+rwx` if your `dave` user is a member of the `admin` group, which it appears to be. That tweak would be accomplished with:

```
sudo chmod -R g+rwx /usr/local/var/mysql
```

MySQL server start issues on Mavericks

Solution

Problem

Related problems