Snippets
Created by
spikeekips
last modified
Install and Running MySQL in OSX
Install MySQL
$ uname -a
Darwin bebop.local 14.3.0 Darwin Kernel Version 14.3.0: Mon Mar 23 11:59:05 PDT 2015; root:xnu-2782.20.48~5/RELEASE_X86_64 x86_64
$ xcode-select -v
xcode-select version 2339.
$ brew -v install mysql
$ mysql_config --version
5.6.24
Configure
create the data directory
$ mkdir mysqldb
$ cd mysqldb
$ pwd
/tmp/mysqldb
[mysqld]
log_bin = 1
basedir = /usr/local/Cellar/mysql/5.6.24/
datadir = /tmp/mysqldb
log_error = /tmp/mysqldb/error.log
port = 3306
socket = /tmp/mysqldb/my.sock
explicit_defaults_for_timestamp = 1
lower_case_table_names=2
Install Initial DB data
$ cd /usr/local/Cellar/mysql/5.6.24/
$ ./bin/mysql_install_db --basedir=$(pwd) --datadir=/tmp/mysqldb --defaults-file=/tmp/mysqldb/my.cnf
Running
$ mysqld_safe --defaults-file=$(pwd)/db/my.cnf
fin!
Comments (0)
You can clone a snippet to your computer for local editing. Learn more.