ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

Question

Level 1

4 points

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

I have installed LAMP using brew command on my MacBook. Installed Piwigo, and transferred my albums, and all works great. But, whenever I restart my MacBook, I would have this error

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

I have removed mysql and install it again with brew command and it all works again until the MacBook is restarted. I have search for solutions and found this

https://medium.com/@kjavaman12/error-20 … fb8d876af0

But it did not work, and I have to reinstall again. My technical ability was just to follow instructions. Any help will be much appreciated.

MacBook Pro (M3, 2023)

Posted on Jan 14, 2024 6:15 PM

Reply

Answer 1

MrHoffman

Level 10

149,281 points

Jan 14, 2024 6:48 PM in response to kit36

Easiest: Remove all that, and load and use MAMP. MAMP is a pre-packaged installation.

As for your issue here, I’d guess that MySQL isn’t starting. What’s in the MySQL logs?

Homebrew can unfortunately sometimes leave somewhat of a mess here, too. I do use it, but with caution.

Reply

Answer 2

kit36 Author

Level 1

4 points

Jan 18, 2024 8:55 PM in response to MrHoffman

Thanks MrHoffman for your help. I have looked at MAMPP and XAMPP. These are bottled applications. Since I have done so much work and understanding of creating LAMP and my Piwigo photo album, I have decided to continue this strategy. The Piwigo forum suggested using Mariadb. I was successful and now my database is working even after restart of my MacBook.

Reply

Answer 3

kit36 Author

Level 1

4 points

Jan 20, 2024 8:52 PM in response to kit36

I spoke too soon. Using Mariadb for Piwigo worked for a while and ended up with the same problem for some unknown reason. So I gave up and use XAMMP. I just put the Piwigo server in htdocs, load its Mariadb with Piwigo dump, and it is now working.

Reply

Answer 4

kit36 Author

Level 1

4 points

Jan 14, 2024 7:46 PM in response to MrHoffman

Sorry, I already reinstalled, and it is working again until the next restart. I will take your advise and use MAMP (which I was not aware of since I am pretty new to macOS).

Thanks. I'll report the outcome after I installed MAMP.

Do I have to get rid of my existing installing first? It seems the MAMP description says I can leave them there.

Reply

Answer 5

MrHoffman

Level 10

149,281 points

Jan 14, 2024 8:36 PM in response to kit36

So long as the stuff installed by homebrew is not started, it can be left.

If both environments start Apache for instance, only one gets TCP 80 and TCP 443, etc.

As for removal, homebrew can usually remove what it loads.

Reply

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

Similar questions