Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

MacOS Can't start MySQL Server

Tags:

mysql

macos

I have MacOS Sierra. I have installed MySQL Server which has been working, however, after a reboot of the Mac Book, I cannot start the MySQL Server.

enter image description here

I have tried changing the port from 3306 to 3307 in the my.cnf file.

Question

I would appreciate any help on how to start the MySQL Server, and also have it so it starts automatically on MacOS Boot up.

(I am new to Mac, so apologies if this is a basic question).

UPDATE

Looking for error logs, I can't find anything with todays (2/2/2017) timestamp.

enter image description here

Nothing in the data dir:

enter image description here

No files with "mysql" have been modified since I've tried to start the MySQL Server (2/2/2017 after 09:00).

enter image description here enter image description here

like image 360
Richard Avatar asked Feb 02 '17 06:02

Richard

People also ask

Why is MySQL not opening on Mac?

The reason behind the MySQL Workbench client not working can be many. It can be because your macOS version is not compatible with the version of the Workbench that you downloaded, or maybe because the version of Python installed on your macOS is not compatible with the version of Workbench you have downloaded.

How do I start MySQL server on Mac?

Open macOS system preferences and select the MySQL preference panel, and then execute Start MySQL Server. The Instances page includes an option to start or stop MySQL, and Initialize Database recreates the data/ directory.

Why does MySQL server not start?

Even with correct ownership, MySQL might fail to start up if there is other security software running on your system that manages application access to various parts of the file system. In this case, reconfigure that software to enable mysqld to access the directories it uses during normal operation.

Video Answer

2 Answers

I suggest using Terminal commands.

Start MySQL

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

Stop MySQL

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

Restart MySQL

sudo /usr/local/mysql/support-files/mysql.server restart
like image 80
Ares Avatar answered Oct 06 '22 21:10

Ares

In my case, I had inadvertently transferred ownership of entire /usr/local directory to myself, which resulted in snatching-away of write permission of /usr/local/mysql-5.7.20-macos10.12-x86_64/data directory from the daemon user called "_mysql".

Restoring the ownership fixed the issue.

like image 29
y2k-shubham Avatar answered Oct 06 '22 21:10

y2k-shubham
Sign in to Comment

Related questions

MySQL select that returns a dummy column?
MySQL - Is it possible to get 'the difference' of two query results?
MYSQL: User - profile details table setup - best practice
Grouping WHERE clauses in Codeigniter
Recovering mysql database from data folder backup
mysql_upgrade failed - innodb tables doesn't exist?
Mysql Select Second Row
Check for database connection, otherwise display message
How to get rid of MySQL error 'Prepared statement needs to be re-prepared'
Is it possible to reference a Foreign Key in a different database in Laravel?
Where does Sequel Pro / MAMP store local databases?
MySQL - select data from database between two dates
pyMySQL set connection character set
PHP Check MySQL Last Row
This PDO prepared statement returns false but does not throw an error
mySQL SELECT timestamp(now()-3000);
Escape string for use in MySQL fulltext search
Opposite of MySQL FIND_IN_SET
How to detect UTF-8 characters in a Latin1 encoded column - MySQL
One to Many MySQL [duplicate]

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!