1. 查看mysql-workbench配置
1.1 点击INSTANCE标签右边的扳手进入配置界面:
→ Manage Server Connections 配置界面
→ System Profile
→ System Type选Linux,Installation Type 是Custom
1.2 Configuration File 要选择对mysql的配置有具体内容的文件:
- windows对应配置文件:
my.ini,在C:/ProgramData文件夹的mysql相关文件夹里
- ubuntu对应配置文件:
/etc/mysql/my.cnf
- my.cnf 的确是mysql的配置文件,但打开后内容只有如下内容:
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
- 你会发现,/etc/mysql/mysql.conf.d/mysqld.cnf 才是真正的配置文件。
2. 配置mysql-workbench
- Configuration File中填写:
/etc/mysql/mysql.conf.d/mysqld.cnf
- Configuration File Section:
mysqld
- Start MySQL:
sudo /etc/init.d/mysql start
- Stop MySQL:
sudo /etc/init.d/mysql stop