mac下mysql的端口号3307修改

来源：互联网发布：nginx禁止域名访问编辑：程序博客网时间：2024/06/10 12:34

最近用到数据库，下载了一个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" "http://www.apple.com/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>

0 0