PID error on mysql.server start?

by

I ran into this same problem when installing via homebrew. Make sure you run these commands (which are listed during install but easy to miss):

unset TMPDIR
mysql_install_db

More Related Contents:

  1. brew install mysql on macOS
  2. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  3. Location of my.cnf file on macOS
  4. Setting the MySQL root user password on OS X
  5. MySQL user DB does not have password columns – Installing MySQL on OSX
  6. How do you uninstall MySQL from Mac OS X?
  7. Restoring deleted ‘root’ user and password for MySQL
  8. Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX
  9. Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT
  10. MySQL Install: ERROR: Failed to build gem native extension
  11. libmysqlclient15-dev on macs?
  12. rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib
  13. Connect to Docker MySQL container from localhost?
  14. How do you stop MySQL on a Mac OS install?
  15. Reset MySQL root password using ALTER USER statement after install on Mac
  16. How to start MySQL server from command line on Mac OS Lion?
  17. How to auto-load MySQL on startup on OS X Yosemite / El Capitan
  18. OSX ld: library not found for -lssl
  19. For homebrew mysql installs, where’s my.cnf?
  20. MySQL data directory location
  21. MySQL foreign key constraints, cascade delete
  22. How to transpose mysql table rows into columns
  23. Get total number of rows when using LIMIT? [duplicate]
  24. Table is specified twice, both as a target for ‘UPDATE’ and as a separate source for data in mysql
  25. MySQL: Many tables or many databases?
  26. How to create and insert a JSON object using MySQL queries?
  27. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  28. How to get the PID of a process by giving the process name in Mac OS X ?
  29. Select by Month of a field
  30. MySQL Illegal mix of collations

Leave a Comment