01.mysql_install_db

Installing MySQL system tables...2014-06-26 22:27:26 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-06-26 22:27:26 68704 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-06-26 22:27:26 68704 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-26 22:27:26 68704 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-06-26 22:27:26 68704 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-26 22:27:26 68704 [Note] InnoDB: Using CPU crc32 instructions
2014-06-26 22:27:26 68704 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-06-26 22:27:26 68704 [Note] InnoDB: Completed initialization of buffer pool
2014-06-26 22:27:26 68704 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2014-06-26 22:27:26 68704 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2014-06-26 22:27:26 68704 [Note] InnoDB: Database physically writes the file full: wait...
2014-06-26 22:27:26 68704 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2014-06-26 22:27:26 68704 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2014-06-26 22:27:26 68704 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2014-06-26 22:27:26 68704 [Warning] InnoDB: New log files created, LSN=45781
2014-06-26 22:27:26 68704 [Note] InnoDB: Doublewrite buffer not found: creating new
2014-06-26 22:27:26 68704 [Note] InnoDB: Doublewrite buffer created
2014-06-26 22:27:26 68704 [Note] InnoDB: 128 rollback segment(s) are active.
2014-06-26 22:27:26 68704 [Warning] InnoDB: Creating foreign key constraint system tables.
2014-06-26 22:27:26 68704 [Note] InnoDB: Foreign key constraint system tables created
2014-06-26 22:27:26 68704 [Note] InnoDB: Creating tablespace and datafile system tables.
2014-06-26 22:27:26 68704 [Note] InnoDB: Tablespace and datafile system tables created.
2014-06-26 22:27:26 68704 [Note] InnoDB: Waiting for purge to start
2014-06-26 22:27:26 68704 [Note] InnoDB: 5.6.17 started; log sequence number 0
2014-06-26 22:27:26 68704 [Note] RSA private key file not found: /usr/local/var/mysql//private_key.pem. Some authentication plugins will not work.
2014-06-26 22:27:26 68704 [Note] RSA public key file not found: /usr/local/var/mysql//public_key.pem. Some authentication plugins will not work.
2014-06-26 22:27:27 68704 [Note] Binlog end
2014-06-26 22:27:27 68704 [Note] InnoDB: FTS optimize thread exiting.
2014-06-26 22:27:27 68704 [Note] InnoDB: Starting shutdown...
2014-06-26 22:27:28 68704 [Note] InnoDB: Shutdown completed; log sequence number 1625977
OK

Filling help tables...2014-06-26 22:27:28 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-06-26 22:27:28 68705 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-06-26 22:27:28 68705 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-26 22:27:28 68705 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-06-26 22:27:28 68705 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-26 22:27:28 68705 [Note] InnoDB: Using CPU crc32 instructions
2014-06-26 22:27:28 68705 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-06-26 22:27:28 68705 [Note] InnoDB: Completed initialization of buffer pool
2014-06-26 22:27:28 68705 [Note] InnoDB: Highest supported file format is Barracuda.
2014-06-26 22:27:28 68705 [Note] InnoDB: 128 rollback segment(s) are active.
2014-06-26 22:27:28 68705 [Note] InnoDB: Waiting for purge to start
2014-06-26 22:27:28 68705 [Note] InnoDB: 5.6.17 started; log sequence number 1625977
2014-06-26 22:27:28 68705 [Note] RSA private key file not found: /usr/local/var/mysql//private_key.pem. Some authentication plugins will not work.
2014-06-26 22:27:28 68705 [Note] RSA public key file not found: /usr/local/var/mysql//public_key.pem. Some authentication plugins will not work.
2014-06-26 22:27:28 68705 [Note] Binlog end
2014-06-26 22:27:28 68705 [Note] InnoDB: FTS optimize thread exiting.
2014-06-26 22:27:28 68705 [Note] InnoDB: Starting shutdown...
2014-06-26 22:27:29 68705 [Note] InnoDB: Shutdown completed; log sequence number 1625987
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.6.17_1/bin/mysqladmin -u root password 'new-password'
  /usr/local/Cellar/mysql/5.6.17_1/bin/mysqladmin -u root -h rafes-mbp password 'new-password'

Alternatively you can run:

  /usr/local/Cellar/mysql/5.6.17_1/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.6.17_1/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

  cd mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

  http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

WARNING: Found existing config file /usr/local/Cellar/mysql/5.6.17_1/my.cnf on the system.
Because this file might be in use, it was not replaced,
but was used in bootstrap (unless you used --defaults-file)
and when you later start the server.
The new default config file was created as /usr/local/Cellar/mysql/5.6.17_1/my-new.cnf,
please compare it with your file and take the changes you need.

WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server

01.mysqld

2015-11-18 23:28:29 -0500

/usr/local/Cellar/mysql/5.7.9/bin/mysqld
--initialize
--user=rrosen
--basedir=/usr/local/Cellar/mysql/5.7.9
--datadir=/usr/local/var/mysql
--tmpdir=/tmp

2015-11-19T04:28:29.645432Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-19T04:28:29.647428Z 0 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2015-11-19T04:28:29.760627Z 0 [Warning] InnoDB: New log files created, LSN=45790
2015-11-19T04:28:29.779247Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2015-11-19T04:28:29.835994Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: fc35a3d0-8e75-11e5-a4ad-eb632db81540.
2015-11-19T04:28:29.856273Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2015-11-19T04:28:30.233002Z 0 [Warning] CA certificate ca.pem is self signed.
2015-11-19T04:28:30.294145Z 1 [Note] A temporary password is generated for root@localhost: t0k9Iq5rQi/b

config.out

HOMEBREW_VERSION: 0.9.5
ORIGIN: https://github.com/Homebrew/homebrew
HEAD: 7714fc0c93115d6cd9b3373e754f1c06e7dfaf09
Last commit: 2 hours ago
HOMEBREW_PREFIX: /usr/local
HOMEBREW_REPOSITORY: /usr/local
HOMEBREW_CELLAR: /usr/local/Cellar
HOMEBREW_BOTTLE_DOMAIN: https://homebrew.bintray.com
CPU: 8-core 64-bit haswell
OS X: 10.11.1-x86_64
Xcode: N/A
CLT: 7.1.0.0.1.1444952191
Clang: 7.0 build 700
X11: N/A
System Ruby: 2.0.0-p645
Perl: /usr/bin/perl
Python: /usr/bin/python
Ruby: /Users/rrosen/.rbenv/shims/ruby => /Users/rrosen
Java: N/A

doctor.out

Please note that these warnings are just used to help the Homebrew maintainers
with debugging if you file an issue. If everything you use Homebrew for is
working fine: please don't worry and just ignore them. Thanks!

Warning: "config" scripts exist outside your system or Homebrew directories.
`./configure` scripts often look for *-config scripts to determine if
software packages are installed, and what additional flags to use when
compiling and linking.

Having additional scripts in your path can confuse software installed via
Homebrew if the config script overrides a system or Homebrew provided
script of the same name. We found the following "config" scripts:
    /Users/rrosen/.rbenv/shims/passenger-config

Warning: Your XQuartz (2.7.5) is outdated
Please install XQuartz 2.7.8:
  https://xquartz.macosforge.org