I am running a local MySQL database on my Macbook, and when it works it works. But every once in awhile, it will have turned itself off. Then when I start it again, it will repeatedly stop and start itself every few seconds or so. If I stop it manually and start it again, it repeats the cycle.

How can I get it to stay on? What could be causing this? I have connected to it through Python and also use my terminal to access it, could that be causing the issue?

  • That should not be happening. Anything in the logs? How much RAM? What is in my.cnf?
    – Rick James
    Aug 24, 2019 at 18:15
  • @RickJames Hm... I don't see logs or my.cnf in the mysql-8 folder. I have 4GB of RAM and MySQL appears to be using about 310MB of it. Aug 24, 2019 at 18:42
  • Perhaps mysqld.err or mysql.log.
    – Rick James
    Aug 24, 2019 at 18:44
  • @RickJames Hm... it doesn't look like it. When I came back to my laptop, MySQL was running consistently, but then I kept getting error Access denied for user 'root'@'localhost' (using password: YES) And when I tried to restart the server, it is turning itself off and on again. Aug 25, 2019 at 13:41


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.