How can I auto start mysqld
I tried following https://stackoverflow.com/q/26476391/631619 but it didn't help
It seems like I have a ownership/permission problem, possibly related to from having installed mysql on this machine for a different user account.
I uninstalled and reinstalled but still get
$ brew install mysql ==> Downloading https://homebrew.bintray.com/bottles/mysql-5.6.27.yosemite.bottle.tar.gz Already downloaded: /Library/Caches/Homebrew/mysql-5.6.27.yosemite.bottle.tar.gz ==> Pouring mysql-5.6.27.yosemite.bottle.tar.gz ==> Caveats A "/etc/my.cnf" from another install may interfere with a Homebrew-built server starting up correctly. To connect: mysql -uroot To have launchd start mysql at login: ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents Then to load mysql now: launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist Or, if you don't want/need launchctl, you can just run: mysql.server start WARNING: launchctl will fail when run under tmux. ==> Summary 🍺 /usr/local/Cellar/mysql/5.6.27: 9883 files, 339M 16:55:49 pengo EQ-390 /Users/pengo $ ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents /Users/pengo/Library/LaunchAgents/homebrew.mxcl.mysql.plist -> /usr/local/opt/mysql/homebrew.mxcl.mysql.plist 16:56:36 pengo EQ-390 /Users/pengo $ launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist /usr/local/Cellar/mysql/5.6.27/homebrew.mxcl.mysql.plist: Operation not permitted $ sudo launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist /usr/local/Cellar/mysql/5.6.27/homebrew.mxcl.mysql.plist: Path had bad ownership/permissions $ l ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist lrwxr-xr-x 1 pengo staff 46 Nov 7 16:56 /Users/pengo/Library/LaunchAgents/homebrew.mxcl.mysql.plist@ -> /usr/local/opt/mysql/homebrew.mxcl.mysql.plist $
I can start mysqld manually however, ie..
$ mysqld 2015-11-07 17:02:22 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-11-07 17:02:22 0 [Note] mysqld (mysqld 5.6.27) starting as process 21472 ... 2015-11-07 17:02:22 21472 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive 2015-11-07 17:02:22 21472 [Note] Plugin 'FEDERATED' is disabled. 2015-11-07 17:02:22 21472 [Note] InnoDB: Using atomics to ref count buffer pool pages ...
and then in another window
$ mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.27 Homebrew Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
$ l /usr/local/bin/mysql lrwxr-xr-x 1 pengo admin 32 Nov 7 16:55 /usr/local/bin/mysql@ -> ../Cellar/mysql/5.6.27/bin/mysql
Do I perhaps need to
chown whoami for additional files?
I tried adding
.bashrc based on having
$ l /usr/local/Cellar/mysql/5.6.27/bin/mysqld -r-xr-xr-x 1 pengo admin 11948736 Nov 7 16:54 /usr/local/Cellar/mysql/5.6.27/bin/mysqld*
but I still got the same errors.