3

I'm trying to run MySQL server (Percona) by launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.percona-server.plist and I see the following message in /var/log/system.log:

Aug  9 01:36:14 xxx com.apple.launchd.peruser.501[253] (homebrew.mxcl.percona-server[37257]): Exited with code: 1
Aug  9 01:36:14 xxx com.apple.launchd.peruser.501[253] (homebrew.mxcl.percona-server): Throttling respawn: Will start in 10 seconds

If I run it manually it gives me

$ /usr/local/opt/percona-server/bin/mysqld_safe
130809 01:49:36 mysqld_safe Logging to '/usr/local/var/mysql/xxx.local.err'.
130809 01:49:36 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
/usr/local/opt/percona-server/bin/mysqld_safe: line 135: /usr/local/var/mysql/xxx.local.err: Permission denied
/usr/local/opt/percona-server/bin/mysqld_safe: line 172: /usr/local/var/mysql/xxx.local.err: Permission denied
130809 01:49:36 mysqld_safe mysqld from pid file /usr/local/var/mysql/xxx.local.pid ended
/usr/local/opt/percona-server/bin/mysqld_safe: line 135: /usr/local/var/mysql/xxx.local.err: Permission denied

Any ideas?

Improve this question

1 Answer 1

Reset to default
3

The log says it all: The script cannot write to the file /usr/local/var/mysql/xxx.local.err due to insufficient permissions.

I assume the log file belongs to a dedicated mysql user while you are starting the process using your user account.

Improve this answer
1
  • Well, it was stupid. I just didn't understand how to run it properly. Now it fails, but with another error. Thanks.
    – Misanthrope
    Commented Aug 11, 2013 at 21:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .