Homebrew MySQL install

clojure.local.err

101109 20:11:36 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
101109 20:11:36 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
101109 20:11:36  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
101109 20:11:36  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
101109 20:11:36  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
101109 20:11:36  InnoDB: Started; log sequence number 0 0
101109 20:11:36 [ERROR] Can't start server : Bind on unix socket: Address already in use
101109 20:11:36 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
101109 20:11:36 [ERROR] Aborting

101109 20:11:36  InnoDB: Starting shutdown...
101109 20:11:41  InnoDB: Shutdown completed; log sequence number 0 44233
101109 20:11:41 [Note] /usr/local/Cellar/mysql/5.1.51/bin/mysqld: Shutdown complete

101109 20:11:41 mysqld_safe mysqld from pid file /usr/local/var/mysql/clojure.local.pid ended
101109 20:13:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
101109 20:13:49 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
101109 20:13:49  InnoDB: Started; log sequence number 0 44233
101109 20:13:49 [ERROR] Can't start server : Bind on unix socket: Address already in use
101109 20:13:49 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
101109 20:13:49 [ERROR] Aborting

101109 20:13:49  InnoDB: Starting shutdown...
101109 20:13:54  InnoDB: Shutdown completed; log sequence number 0 44233
101109 20:13:54 [Note] /usr/local/Cellar/mysql/5.1.51/libexec/mysqld: Shutdown complete

101109 20:13:54 mysqld_safe mysqld from pid file /usr/local/var/mysql/clojure.local.pid ended
101109 20:14:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
101109 20:14:10 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
^G/usr/local/Cellar/mysql/5.1.51/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
101109 20:14:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
101109 20:14:10  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
101109 20:14:10 mysqld_safe mysqld from pid file /usr/local/var/mysql/clojure.local.pid ended

gistfile1.sh

[19:53:19][~ {rbx-1.0.1-20100603}]
$ brew install mysql
==> Downloading http://mysql.mirrors.pair.com/Downloads/MySQL-5.1/mysql-5.1.51.tar.gz
File already downloaded and cached to /Users/jabley/Library/Caches/Homebrew
==> Downloading patches
==> Patching
patching file scripts/mysqld_safe.sh
Hunk #1 succeeded at 384 (offset 1 line).
patching file scripts/mysql_config.sh
==> ./configure --without-docs --without-debug --disable-dependency-tracking --prefix=/usr/local/Cellar/mysql/5.1.51 --localstatedir=/usr/local/var/mysql --sysconfdir=/usr/local/etc --with-plugins=innob
==> make install
==> Caveats
Set up databases with:
    mysql_install_db

If this is your first install, automatically load on login with:
    cp /usr/local/Cellar/mysql/5.1.51/com.mysql.mysqld.plist ~/Library/LaunchAgents
    launchctl load -w ~/Library/LaunchAgents/com.mysql.mysqld.plist

If this is an upgrade and you already have the com.mysql.mysqld.plist loaded:
    launchctl unload -w ~/Library/LaunchAgents/com.mysql.mysqld.plist
    cp /usr/local/Cellar/mysql/5.1.51/com.mysql.mysqld.plist ~/Library/LaunchAgents
    launchctl load -w ~/Library/LaunchAgents/com.mysql.mysqld.plist

Note on upgrading:
    We overwrite any existing com.mysql.mysqld.plist in ~/Library/LaunchAgents
    if we are upgrading because previous versions of this brew created the
    plist with a version specific program argument.

Or start manually with:
    mysql.server start
==> Summary
/usr/local/Cellar/mysql/5.1.51: 220 files, 45M, built in 10.5 minutes
[20:04:12][~ {rbx-1.0.1-20100603}]
$ mysql_install_db 
Installing MySQL system tables...
ERROR: 1004  Can't create file '/var/folders/Sz/SzcwjI0UFPKPgrziYTl85U+++TI/-Tmp-/#sql55b7_1_0.frm' (errno: 9)
101109 20:11:04 [ERROR] Aborting

101109 20:11:04 [Note] /usr/local/Cellar/mysql/5.1.51/libexec/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/usr/local/var/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/Cellar/mysql/5.1.51/libexec/mysqld --skip-grant &

and use the command line tool /usr/local/Cellar/mysql/5.1.51/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/Cellar/mysql/5.1.51/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/var/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/local/Cellar/mysql/5.1.51/bin/mysqlbug script!

[exited with 1]
[20:11:05][~ {rbx-1.0.1-20100603}]
$ sudo mysql_install_db 
Password:
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/local/Cellar/mysql/5.1.51/bin/mysqladmin -u root password 'new-password'
/usr/local/Cellar/mysql/5.1.51/bin/mysqladmin -u root -h clojure.local password 'new-password'

Alternatively you can run:
/usr/local/Cellar/mysql/5.1.51/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local/Cellar/mysql/5.1.51 ; /usr/local/Cellar/mysql/5.1.51/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/local/Cellar/mysql/5.1.51/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/local/Cellar/mysql/5.1.51/bin/mysqlbug script!

[20:11:17][~ {rbx-1.0.1-20100603}]
$ ps -ef | grep mysql
[exited with 1]
[20:11:25][~ {rbx-1.0.1-20100603}]
$ mysql.server start
Starting MySQL
...... ERROR! Manager of pid-file quit without updating file.
[exited with 1]
[20:11:42][~ {rbx-1.0.1-20100603}]
$ mysqld_safe 
101109 20:13:48 mysqld_safe Logging to '/usr/local/var/mysql/clojure.local.err'.
101109 20:13:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
rm: /tmp/mysql.sock: Permission denied
101109 20:13:54 mysqld_safe mysqld from pid file /usr/local/var/mysql/clojure.local.pid ended
[20:13:55][~ {rbx-1.0.1-20100603}]
$ ps -ef | grep mysql
  501 22676 73939   0   0:00.00 ttys002    0:00.00 grep mysql
[20:14:04][~ {rbx-1.0.1-20100603}]
$ sudo mysqld_safe 
101109 20:14:10 mysqld_safe Logging to '/usr/local/var/mysql/clojure.local.err'.
101109 20:14:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
101109 20:14:10 mysqld_safe mysqld from pid file /usr/local/var/mysql/clojure.local.pid ended
[20:14:10][~ {rbx-1.0.1-20100603}]
$ ps -ef | grep mysql
  501 22963 73939   0   0:00.00 ttys002    0:00.00 grep mysql