How to move MySQL8.0 datadir on FreeBSD?

I tried to modify datadir where at /usr/local/etc/mysql/my.cnf to new path and restarted MySQL.
But when I showed variable of datadir, It was still at original path.
1.jpg


I tried those steps
1. stop MySQL
1. ee /usr/local/etc/mysql/my.cnf
2. datadir=/var/db/mysql ====> datadir=/newdir
3. cp -r /var/db/mysql /newdir
4. start MySQL
And It doesn't work

Can anyone help me?

Thanks.
 
Read /usr/local/etc/rc.d/mysql-server, you need to set mysql_dbdir in rc.conf.
 
Back
Top