最近用到数据库,下载了一个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文件如下:
<span style="color:#222222;"><?xml version="1.0" encoding="UTF-8"?><!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "/DTDs/PropertyList-1.0.dtd"><plist version="1.0"><dict><key>Label</key> <string>com.oracle.oss.mysql.mysqld</string><key>ProcessType</key> <string>Interactive</string><key>Disabled</key><false/><key>RunAtLoad</key> <true/><key>KeepAlive</key> <true/><key>SessionCreate</key><true/><key>LaunchOnlyOnce</key> <false/><key>UserName</key><string>_mysql</string><key>GroupName</key> <string>_mysql</string><key>ExitTimeOut</key> <integer>600</integer><key>Program</key> <string>/usr/local/mysql/bin/mysqld</string><key>ProgramArguments</key><array><string>/usr/local/mysql/bin/mysqld</string><string>--user=_mysql</string><string>--basedir=/usr/local/mysql</string><string>--datadir=/usr/local/mysql/data</string><string>--plugin-dir=/usr/local/mysql/lib/plugin</string><string>--log-error=/usr/local/mysql/data/mysqld.local.err</string><string>--pid-file=/usr/local/mysql/data/mysqld.local.pid</string></span><span style="color:#ff0000;"><string>--port=3307</string></span><span style="color:#222222;"></array><key>WorkingDirectory</key> <string>/usr/local/mysql</string></dict></plist></span>
直接修改端口重启就可以了:
<string>--port=3306</string>