1、查看数据文件存储目录
1 | mysqladmin -u root -p variables | grep datadir |
/usr/local/etc/my.cnf
1 | bind-address = 127.0.0.1 // 只允许本地访问 |
2、重启mysql(brew 安装的)
launchctl unload -w /usr/local/Cellar/mysql/5.7.18_1/homebrew.mxcl.mysql.plist
launchctl load -w /usr/local/Cellar/mysql/5.7.18_1/homebrew.mxcl.mysql.plist
mysql.server restart
mysql.server stop/mysql.server start
3、mysql 5.7 + ssl 需要配置
安装时需要运行
1 | bin/mysql_ssl_rsa_setup |
会在datadir 里新建ssl证书
4、mysql 授权命令
1 | grant all privileges on pipe.* to yyyyyy@'%' identified by 'xxxxxx'; |