2000字范文,分享全网优秀范文,学习好帮手!
2000字范文 > mac下mysql的端口号3307修改

mac下mysql的端口号3307修改

时间:2022-05-31 05:05:56

相关推荐

mac下mysql的端口号3307修改

最近用到数据库,下载了一个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>

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。