How do I change the MySQL data folder path in a Mac?

Question

I think in MacOS, mysql uses the default values, without a config file. You just need to create a /etc/my.cnf file and restart MySQL. — ypercubeᵀᴹ, Commented May 12, 2015 at 14:06

Community · Accepted Answer · 2017-05-23 12:40:37Z

2

First shutdown mysql

mysqladmin -uroot -p shutdown

Then, launch mysqld by hand

mysqld --defaults-file=...

or if MySQL is running with all defaults and you are just changing datadir, do this

mysqld --datadir=/path/to/mysql/data

Here is a StackOverflow question (MySQL 'my.cnf' location?) with multiple suggestions on where my.cnf might be for Mac OS when installed .

CommunityBot

1

answered May 12, 2015 at 14:07

RolandoMySQLDBA

184k33 gold badges323 silver badges531 bronze badges

Thanks how can install a Service in mac like in windows mysqld --install myService --defaults-file=my.ini
– ARASHz4
Commented May 12, 2015 at 14:13
Go to command line, and run mysqld --help --verbose > mysqld.txt. Look inside mysqld.txt. Do you see --install as a parameter option ?
– RolandoMySQLDBA
Commented May 12, 2015 at 14:57
no i do not see --install i think this command is just for windows
– ARASHz4
Commented May 13, 2015 at 4:20

Add a comment |

1 Answer 1