Installed [email protected] using brew mysql.server not a command

Question

I installed [email protected] using brew. Below are the comands I ran

brew install [email protected]

sudo chmod -R 777 /usr/local/var/mysql

sudo ln -s /usr/local/Cellar/mysql\@5.6/5.6.41/bin/mysql /usr/local/bin/mysql

sudo cp /usr/local/Cellar/mysql\@5.6/5.6.41/homebrew.mxcl.mysql.plist /Library/LaunchAgents/

sudo chown root /Library/LaunchAgents/homebrew.mxcl.mysql.plist

sudo chmod 600 /Library/LaunchAgents/homebrew.mxcl.mysql.plist

sudo chmod +x /Library/LaunchAgents/homebrew.mxcl.mysql.plist

launchctl load -w /Library/LaunchAgents/homebrew.mxcl.mysql.plist

mysql.server start

sh: mysql.server: command not found

this is the output I am getting. mysql --version is giving output

mysql Ver 14.14 Distrib 5.6.41, for osx10.13 (x86_64) using EditLine wrapper

If I start service via brew its starting

brew services start [email protected]

But when I run mysql -uroot I am getting

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

There is NO reason for you to execute all those sudo commands. You are literally breaking your MySQL installation. Just brew install [email protected] then brew services start [email protected] - that's it. All the other commands you're doing in between those two steps is ruining everything. — dossy
I am getting the following errror that time too.. ERROR! The server quit without updating PID file (/usr/local/var/mysql/Jerrys-MacBook-Air.local.pid) — Jerry
Can you share the output of: (f=/usr/local/var/mysql; until [ "$f" = "/" ]; do ls -lda $f; f=$(dirname $f); done) — dossy
And, the output of: ls -lda $(/usr/local/bin/mysqld --verbose --help 2>/dev/null | grep -A1 'Default options are read' | tail -1) — dossy

Cyclonecode Cyclonecode · Accepted Answer · 2018-10-20T21:59:59

I think you need to start the service as well:

brew services start [email protected]

You can then check so the mysql service is running using:

brew services list

Now try to create symlinks for the mysql package:

brew link --force [email protected]

You might need to add the location to mysql to your path, to find the location of the package:

brew list [email protected]

Then add the location to the bin folder to the end of your ~/.profile or ~/.bash_profile file. For instance:

export PATH=$PATH:/usr/local/Cellar/[email protected]/5.6.41/bin

Then reload the file:

source ~/.bash_profile

Now you should be able to use the mysql and connect to the local running server.

Installed [email protected] using brew mysql.server not a command

2 Answers