Skip to content

Instantly share code, notes, and snippets.

@yano3
Created November 19, 2012 04:26
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yano3/4108957 to your computer and use it in GitHub Desktop.
Save yano3/4108957 to your computer and use it in GitHub Desktop.
brew upgrade mysql
$ brew upgrade mysql
Warning: Your Xcode (3.2.5) is outdated
Please install Xcode 3.2.6.
==> Upgrading mysql
==> Downloading https://downloads.sf.net/project/machomebrew/Bottles/mysql-5.5.28.snowleopard.bottle.tar.gz
######################################################################## 100.0%
==> Pouring mysql-5.5.28.snowleopard.bottle.tar.gz
==> Caveats
Set up databases to run AS YOUR USER ACCOUNT with:
unset TMPDIR
mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
To set up base tables in another folder, or use a different user to run
mysqld, view the help for mysqld_install_db:
mysql_install_db --help
and view the MySQL documentation:
* http://dev.mysql.com/doc/refman/5.5/en/mysql-install-db.html
* http://dev.mysql.com/doc/refman/5.5/en/default-privileges.html
To run as, for instance, user "mysql", you may need to `sudo`:
sudo mysql_install_db ...options...
Start mysqld manually with:
mysql.server start
Note: if this fails, you probably forgot to run the first two steps up above
A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.
To connect:
mysql -uroot
To launch on startup:
* if this is your first install:
mkdir -p ~/Library/LaunchAgents
cp /usr/local/Cellar/mysql/5.5.28/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/
launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
* if this is an upgrade and you already have the homebrew.mxcl.mysql.plist loaded:
launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
cp /usr/local/Cellar/mysql/5.5.28/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/
launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
You may also need to edit the plist to use the correct "UserName".
Warning: Non-executables were installed to "bin".
Installing non-executables to "bin" is bad practice.
The offending files are:
/usr/local/Cellar/mysql/5.5.28/bin/mysqlaccess.conf
Error: Will not overwrite /usr/local/Cellar/mysql/5.5.28/homebrew.mxcl.mysql.plist
brew upgrade mysql 2.31s user 3.44s system 32% cpu 17.845 total
@arturhoo
Copy link

Hi there @yano3!

I just came across this same error when upgrading MySQL through homebrew. Did you post this gist somewhere (maybe homebrew issues) so that some attention is drawn to the issue?

Despite the error, MySQL was installed correctly here.

Cheers,

Artur

@amccloud
Copy link

Same here.

@clifff
Copy link

clifff commented Nov 20, 2012

Thirded. I'm also trying to debug this issue

@lxyu
Copy link

lxyu commented Nov 21, 2012

Same here.

@jverb
Copy link

jverb commented Nov 24, 2012

I got the same error on a clean install of mysql.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment