Skip to content

Instantly share code, notes, and snippets.

@andredublin
Created March 11, 2012 19:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save andredublin/2017873 to your computer and use it in GitHub Desktop.
Save andredublin/2017873 to your computer and use it in GitHub Desktop.
brew mysql errors
/*--- from home ---*/
$ mysql.server start
Starting MySQL
.. ERROR! The server quit without updating PID file (/usr/local/var/mysql/andre.local.pid).
$ mysql_install_db --verbose --user=andredublin --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp 1 ↵
FATAL ERROR: Could not find my_print_defaults
The following directories were searched:
/usr/local/Cellar/mysql/5.5.20/bin
/usr/local/Cellar/mysql/5.5.20/extra
If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.
If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.
/*--- from work ---*/
╭─@andres-imac.home ~
╰─ unset TMPDIR
╭─@andres-imac.home ~
╰─ mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
Installing MySQL system tables...
/usr/local/bin/mysql_install_db: line 434: 58180 Done { echo "use mysql;"; cat $create_system_tables $fill_system_tables; }
58181 Done(141) | eval "$filter_cmd_line"
58182 Segmentation fault: 11 | $mysqld_install_cmd_line > /dev/null
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.5.20/bin/mysqld --skip-grant &
and use the command line tool /usr/local/Cellar/mysql/5.5.20/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/local/Cellar/mysql/5.5.20/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.5.20/scripts/mysqlbug script!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment