MySQL 5.7をインストールする

パッケージのインストール

pkg install -y mysql57-server
sysrc mysql_enable=YES

起動

service mysql-server start

rootパスワードの変更

mysql -uroot -p`tail -1 /root/.mysql_secret | awk '{printf($0);}'`

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

rootの追加

CREATE USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'password';
CREATE USER 'root'@'::1' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1';
UPDATE mysql.user SET grant_priv='Y' WHERE user='root';
FLUSH PRIVILEGES;\n"