New answers tagged mysql
I like the alias answer. This is another route I found whilst looking. sudo ln -s /usr/local/mysql/support-files/mysql.server /usr/local/sbin/ can now stop and start with sudo mysql.server start sudo mysql.server stop
Just create an alias in your ~/.bash_profile or ~/.profile file. Check with ls -la0 ~/ if one of the files already exist, else create one with: touch ~/.bash_profile After opening .bash_profile with nano ~/.bash_profile add the lines: alias iwanttostartmysqlwithareallyshortcommand='sudo /usr/local/mysql/support-files/mysql.server start' alias ...
What worked for me was sudo chmod -R 777 /usr/local/mysql/ , I've had installed from brew.
You may change the port in the file com.oracle.oss.mysql.mysqld.plist file in /Library/LaunchDaemons by editing it with sudo nano /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist Change the port at <string>--port=3307</string> near the end of the file to whatever you need it to be and reboot your Mac or restart the service.
Preface: It's no problem to install MAMP, MAMP Pro or Bitnami MAMP Stack on OS X Server (Yosemite or older). All of them are self-containing stacks and get installed to the /Applications folder. They don't interfere with any original software like Oracle MySQL/PostgreSQL/OS X Server postgres provided you don't use their distinctive ports. All the MAMP ...
I found the homebrew version of mysql worked perfectly on OS X 10.10.3 and 10.10. running Server. brew install mysql and all was good - mysql.server start starts it and mysql.server stop does the reverse.
For what it's worth, I have OSX 10.10.4 and my installation of MySQL 5.6.26 for OSX 10.9 worked fine and I can start/stop it successfully through System Preferences. What didn't work well: the default connection method is to localhost via socket and all attempts to enable connections via TCP to 127.0.0.1 proved futile.
Top 50 recent answers are included