Try adding the following line to your .bash_profile file.
You can do this easily with the following command, which will append the line if the file already exists or create a new file with the line if it doesn't.
echo 'export PATH="/usr/local/mysql/bin:$PATH"' >> ~/.bash_profile
Open terminal, then:
sudo launchctl list | grep -i mysql
launchctl remove xxx.xxx.mysql
Where "xxx.xxx" is included in the output of the first command, for example "org.macports.mysql". The password for the "sudo" command is your own user account's password.
True, sudo isn't needed to "list" but because you already gave a sudo password for the first ...
mysql-utils is a different cask
brew cask install mysql-utilities
if you do a brew search mysql you can see the caskroom casks
$ brew search mysql
OK, so I found the culprit.
It is amazing that no error message was visible in console or in the error logs, but I found a site which helped me a lot.
In that post, the author, Josh, suggested restarting apache using the following command:
sudo bash -x /usr/sbin/...
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
near the end of the file to whatever you need it to be and reboot your Mac or restart the service.
You probably enabled the MySQL launch agent with brew services start mysql in the past and forgot to disable the brew service (before uninstalling mysql) which would remove the plist.
So unload and remove the agent from the launchd database manually with:
launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
launchctl remove ~/Library/...
The disadvantage is that you're installing stuff that you already have installed.
This can cause problems when - for example - you want to use PHP using the command-line. This will trigger the built-in PHP version by default instead of the one bundled with MAMP. If these are different the results can be unexpected.
I would recommend using the default OSX ...
The following assume your MySQL 5.1 is installed in /usr/local/mysql-5.1.46-osx10.6-x86_64 and that MySQL 5.6 will install in /usr/local/mysql-5.6.11-osx10.7-x86_64. The exact directory names might differ depending on the exact version number you are using.
Download the MySQL 5.6 installer, for instance in DMG format, and run mysql-5.6.11-osx10.7-x86_64.pkg
You can accomplish this by going to your .bash_profile file and adding these lines to it.
alias mysql.start="sudo /usr/local/mysql/support-files/mysql.server start"
alias mysql.stop="sudo /usr/local/mysql/support-files/mysql.server stop"
alias mysql.restart="sudo /usr/local/mysql/support-files/mysql.server restart"
alias mysql.status="sudo /usr/local/mysql/...
Actually, the #1 advantage to using MAMP is tremendous: Each time you upgrade your system, your environment won't break!
There were a couple of Snow Leopard updates (or maybe it was Leopard to Snow Leopard, I can't remember) that broke Mysql. One was by moving the mysql.socket file. There was another update the broke PHP. In both cases I had to hunt around ...
There is no way to make Numbers get data from a database. (It's more of a consumer tool.) https://discussions.apple.com/thread/1827581
A workaround: you can use Excel to grab the data, and import the XLS file to Numbers for prettier chart-making.
My favourite way to install and run MySQL is via the Homebrew package manager. With Homebrew installed it's as straightforward as:
brew install mysql
This gets you the server and the command line connection tool. It's setup to run with no password, so it's not suitable for production use, but it's perfect for developing with. Homebrew takes care of putting ...
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:
After opening .bash_profile with nano ~/.bash_profile add the lines:
alias iwanttostartmysqlwithareallyshortcommand='sudo /usr/local/mysql/support-files/mysql.server start'
Starting and stopping the MySQL server via Preferences Pane/launchd and on the other hand via sudo /usr/local/mysql/support-files/mysql.server start/stop are not really compatible.
After choosing "Launchd Support" in the MySQL installer the launch daemon com.oracle.oss.mysql.mysqld will be created and the MySQL preferences pane uses the launchd mechanism to ...
You have an extra character before mysql that looks like a space, but is not a space. You have to fix that before running the command. This problem occurs when you press the space bar while you are holding the Option key.
$ # Option + Space
$ unzip -p dump.sql.zip | mysql
zsh: command not found: mysql
$ # Regular Space
$ unzip -p dump.sql.zip | mysql
After quite a bit of frustration, I eventually found a simple solution that works.
The salient details are that you need to update the DYLD_LIBRARY_PATH to include /usr/local/mysql/lib. The easiest way of doing that is to add the following to your ~/.bashrc file:
I went into a little more ...
command not found just means that the executable you're trying to run is not found in any of the directories in your $PATH environment variable.
The documentation links include a platform guide where it tells you that MySQL gets installed into /usr/local/, and then a symlink is created at /usr/local/mysql that points to this ...
Following homebrew caveats, did you setup launchd?
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
Well, now using mysql.server is pointless. It basically doesn't work, because (from my poor understanding) ...
Since upgrade to Yosemite updated your Apache, you have to update phpMyAdmin.conf to use new Access control syntax.
Have a look at: http://httpd.apache.org/docs/2.4/upgrading.html
In my case I need changed /etc/apache2/other/phpMyAdmin.conf
Allow from all
Require all granted
More info here: http://www.zoubi.me/blog/you-dont-have-...
I like the alias answer. This is another route I found whilst looking.
sudo ln -s /usr/local/mysql/support-files/mysql.server /usr/bin/mysql.server
can now stop and start with
sudo mysql.server start
sudo mysql.server stop
To uninstall all files/packages installed by the shell script simply undo all commands executed in the script logged in with an admin account:
Open System Preferences -> MySQL and stop the service if it's running
Open the folder /Applications and drag SequelPro - if it was installed - to your trash.
Open Terminal and enter sudo rm -R /usr/local/mysql-5.6.26-...
To completely uninstall MySQL OS X it is necessary to remove numerous files and folders and edit one file.
To uninstall MySQL and completely remove it (including all databases) from your Mac do the following:
Open a Terminal window
Use mysqldump to backup your databases to text files!
Stop the database server
Remove files and folders:
rm -rf ~/Library/...
The arrow means it is an alias or link, but it could lead anywhere. To find the destination, select the alias and press ⌘I (or right-click and choose Get Info), then look at the ‘Original’ path (or just open it and see where it leads).
I solved it! When I finally got it to write an error log (needed to fix the permissions for that) and looked inside the error log, I saw it was missing the symbol _clock_gettime(). When I googled that, I discovered MacOS didn't add that symbol until OSX 10.12, and I'm running 10.11 (so as not to break Dreamweaver CS6).
I uninstalled MySQL 5.7.21 and looked ...
The answer to this superuser question and this stackoverflow question both say approximately the same thing, that you need to perform the following actions:
If you haven't yet rebooted your computer, the process could still be
running. First, reboot.
Then if MySQL is still showing up after a reboot, from the Terminal,
issue the following commands ...