Jackie Jackie - 2 years ago 45
SQL Question

I can't start MySQL Server and Workbench error

I have just installed MySQL and MySQL Workbench.

After installing both, I can see the "MySQL" icon in System Preferences. But if I try to start MySQL Server it asks me the password, but then nothing happens.
So I tried to start MySQL Server from the terminal with the following command:

sudo /usr/local/mysql/support-files/mysql.server start

But it gave me this error:

Starting MySQL
.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/MBP.local.pid).

Can anyone help me please?

Before all this I've not had any problems starting and stopping MySQL, but I forgot the MySQL password so I had to uninstall MySQL and install it again because I needed to use Workbench. But obviously without the MySQL password it didn't work. Is there a way for me to recover the password?

Answer Source
  1. Check if a mysql process already exists or not ps -ef | grep mysql

  2. If yes, Kill the process kill -9 PID or killall -9 mysql mysqld

  3. Check the owner ship of the mysql data directory is mysql:mysql
  4. Then try to start mysql server sudo mysql.server start
  5. If this do not resolve the issue. Then have a look in the mysql .err file

Check out: MySql ERROR! The server quit without updating PID file

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download