Skip to content

Instantly share code, notes, and snippets.

@yano3
Created November 19, 2012 04:26
Show Gist options
  • 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
@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