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)

Solution

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.

Comments

[Jerry]

Error: Formula mysql is not installed.

[Cyclonecode]

sorry updated, start should be before the name of the service

[Jerry]

I have tried that, it says Formula mysql is not installed, maybe because i installed [email protected] ?

[Cyclonecode]

@Jerry - I added some more information that I think will solve your problem.

[Jerry]

. ERROR! The server quit without updating PID file (/usr/local/var/mysql/Jerrys-MacBook-Air.local.pid).

[Cyclonecode]

@Jerry - If I were you I would start by completely uninstalling the current mysql packages and remove any traces of it: brew uninstall [email protected] and rm -rf /usr/local/var/mysql /usr/local/etc/my.cnf and try again

[Jerry]

I did it multiple times :|

[Nico Haase]

You should add some explanation to that code. Why should adding something to the PATH variable solve a socket problem?

[Cyclonecode]

The problem is not that the command cannot be found, so the above solution would help very little in this case.

[wobsoriano]

Creating a symlink fixed mysql command not found on my mojave with [email protected]