最近用到数据库,下载了一个mysql,但是发现修改my.cf里的mysql端口没有作用。
原因:
其它Linux(入ubuntu,openbsd)下配置mysql的文件是/etc/my.cf, 而mac的中是/Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist文件。
打开/Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist文件如下:
Labelcom.oracle.oss.mysql.mysqld
ProcessTypeInteractive
Disabled
RunAtLoad
KeepAlive
SessionCreate
LaunchOnlyOnce
UserName_mysql
GroupName_mysql
ExitTimeOut600
Program/usr/local/mysql/bin/mysqld
ProgramArguments
/usr/local/mysql/bin/mysqld
--user=_mysql
--basedir=/usr/local/mysql
--datadir=/usr/local/mysql/data
--plugin-dir=/usr/local/mysql/lib/plugin
--log-error=/usr/local/mysql/data/mysqld.local.err
--pid-file=/usr/local/mysql/data/mysqld.local.pid
--port=3307
WorkingDirectory/usr/local/mysql
直接修改端口重启就可以了:
--port=3306