mysql端口号为0
mysql端口号为0
修改mysql端口号:
1.sudo vim /etc/my.cnf (注意sudo提权);
2.注释skip-networking及skip-grant-tables;
3.执行:sudo vim /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist ,并在ProgramArguments下新增一行:–port=3306;
4.关闭mysql服务:sudo /usr/local/mysql/support-files/mysql.server stop ;
5.开启mysql服务:sudo /usr/local/mysql/support-files/mysql.server start;
6.登陆mysql客户端:sudo /usr/local/mysql/bin/mysql -u root -p;
7.查mysql端口号是否修改为3306,执行:show global variables like ‘port’;
8.用datagrip连mysql:成功~