macox mysql 5.5.10

[quote]
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 differnet 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...

To run as, for instance, user "mysql", you may need to `sudo`:

sudo mysql_install_db ...options...

Start mysqld manually with:

mysql.server start

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.10/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.5.10/com.mysql.mysqld.plist ~/Library/LaunchAgents/

launchctl load -w ~/Library/LaunchAgents/com.mysql.mysqld.plist

[/quote]


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.5.10/bin/mysqladmin -u root password 'new-password'

/usr/local/Cellar/mysql/5.5.10/bin/mysqladmin -u root -h racematoMacBook-Pro.local password 'new-password'

Alternatively you can run:

/usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation