HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlModerate

mysqld keeps automatically restarting

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
automaticallyrestartingkeepsmysqld

Problem

I am running mysqld on Mac OSX Al Capitan. After boot up, I ran mysql.server start to start mysqld server.

But when I ran mysql.server stop, or sudo mysql.server stop, it just stopped for a while, later it will automatically restart itself again.

I also tried mysqladmin -uroot -p -hlocalhost shutdown for no avail.

It just keeps restarting again and again.

I guess it's maybe related to mysql_safe process, but I don't know how to properly stop mysqld, and force it not to restart again, until I myself run mysql.server start manually. Thanks!

Solution

If you used homebrew to install mysql, mysqld will keep on restarting unless you use following brew command:

brew services list


Get the name of service to stop and then run the following command:

brew services stop mysql@5.5


From: https://stackoverflow.com/a/57169447/2670370

Code Snippets

brew services list
brew services stop mysql@5.5

Context

StackExchange Database Administrators Q#124974, answer score: 14

Revisions (0)

No revisions yet.