homebrew安装的mysql,一直无法通过远程访问,改表,改授权,都搞过了,不行。
找到的my.cnf里面什么都没有,原来他的配置文件是在/usr/local/Cellar/mysql/5.6.26/homebrew.mxcl.mysql.plist
去掉下面标红的,重启mysql就可以了.windows里的也是这个参数,不过他是在my.ini里面。花我两个小时,草草草
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>KeepAlive</key>
<true/>
<key>Label</key>
<string>homebrew.mxcl.mysql</string>
<key>ProgramArguments</key>
<array>
<string>/usr/local/opt/mysql/bin/mysqld_safe</string>
<string>--bind-address=127.0.0.1</string>
<string>--datadir=/usr/local/var/mysql</string>
</array>
<key>RunAtLoad</key>
<true/>
<key>WorkingDirectory</key>
<string>/usr/local/var/mysql</string>
</dict>
</plist>