Menu
I have installed mysql 8.0.13 server with mysql community edition on Mac OS (10.14.1) Mojava.
Next day i was unable to connect with mysql server. I start mysql instance and it turned to OFF mode as shown in figure.
I tried multiple solutions like;
Update file com.oracle.oss.mysql.mysqld.plist keepAlive attribute to true
change connection timeout from 180 to 280.
No port is listening to 3306
Firewall disable
Kindly tell what could be the issue?
210
The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. In this case, you normally get one of the following error codes (which one you get is operating system-dependent). The client couldn't send a question to the server.
Windows – Start and Stop Server Now search for MySQL service based on the version that is installed. Click on 'stop', 'start' or 'restart' the service option.
systemd, the mysqld_safe and mysql. server scripts, Solaris SMF, and the macOS Startup Item (or MySQL Preference Pane) can be used to start the server manually, or automatically at system startup time.
This worked for me in MAC...
open Terminal and write the following
This will check all the instances that are currently running.
1) ps -ef | grep mysql
If you found any process Id with the above command.
2) sudo kill -9 [PID]
Where [PID] is the process id next to username like 5098
so it will be kill 5098
now you will restart again using the mysql server pane or by command
mysql.server start
181
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
