Search code examples
mysqlpid

.PID file gets deleted when running mysql.server start


I installed mysql through brew install mysql and when I run mysql.server start, I get the error ERROR! The server quit without updating PID file (/usr/local/var/mysql/User-Macbook-Pro.local.pid). After creating the .pid file, I run mysql.server start and get the same error. I've tried deleting the .err file but it just keeps removing my .pid file. Any ideas on what I'm doing wrong?


Solution

  • run these commands during install...

    unset TMPDIR
    mysql_install_db
    

    also ensure that you're running mysql as the root user once you do have it installed...

    sudo mysql.server start