MySQL server startup error ‘The server quit without updating PID file’

by

Try to find your log file with suffix “.err”. There should be more information. It might be in:

/usr/local/var/mysql/your_computer_name.local.err

It’s probably a problem with permissions

  1. Check if any MySQL instance is running

    ps -ef | grep mysql

    If yes, you should stop it, or kill the process:

    kill -9 PID

    where PID is the number displayed next to the username on the output of the previous command

  2. Check ownership of /usr/local/var/mysql/

    ls -laF /usr/local/var/mysql/

    If it is owner by root, you should change it to mysql or your_user

    sudo chown -R mysql /usr/local/var/mysql/

More Related Contents:

  1. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. How to reset mysql root password?
  4. Binary Data in MySQL [closed]
  5. Select mysql query between date?
  6. MySQL COUNT DISTINCT
  7. mysql -> insert into tbl (select from another table) and some default values [duplicate]
  8. Convert MySQL schema to Github Wiki?
  9. mysql select from n last rows
  10. Install MySQL on Ubuntu without a password prompt
  11. Capitalize first letter of each word, in existing table
  12. A constraint to prevent the insert of an empty string in MySQL
  13. Search all columns of a table using a single where condition with single keyword in mysql
  14. MySQL trigger to update a field to the value of id
  15. How to get a list of MySQL views?
  16. MySQL: Inner join vs Where [duplicate]
  17. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  18. Selecting from two tables with inner join and limit [duplicate]
  19. MySQL substring extraction using delimiter
  20. Convert Unix timestamp into human readable date using MySQL
  21. Why the order of evaluation for expressions involving user variables is undefined?
  22. MySQL : retrieve a large select by chunks
  23. MySQL – insert data from another table merged with constants
  24. MySQL matching unicode characters with ascii version
  25. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  26. Execute INSERT if table is empty?
  27. MySQL: Querying for unicode entities
  28. undefined method `eq’ for nil:NilClass with rails 3 and ruby enterprise on ubuntu hardy
  29. MySQL data directory location
  30. INSERT INTO fails with node-mysql

Leave a Comment