A fresh installation of MySQL – Workbench in ubuntu at times does not reflect the mysql configuration file which is being used by the server. To set it up we first need to know the configuration files used at start up.
Following are the steps to determine which configuration file is used.
Determine mysql process from where it is initiated
user@Sys-201:/etc/mysql/conf.d$ ps aux | grep mysql
mysql 22272 0.1 1.2 1509844 198076 ? Ssl 14:51 0:01 /usr/sbin/mysqld
user 22312 0.0 0.0 12548 3024 ? S 14:51 0:00 /bin/bash /usr/bin/mysql-workbench
user 22315 0.0 0.0 4508 860 ? S 14:51 0:00 /bin/sh /usr/bin/catchsegv /usr/lib/mysql-workbench/mysql-workbench-bin
user 22317 1.5 1.0 1506344 164356 ? SLl 14:51 0:11 /usr/lib/mysql-workbench/mysql-workbench-bin
user 22514 0.0 0.0 14224 932 pts/1 S+ 15:04 0:00 grep –color=auto mysql
besides the mysql row, it should indicate the configuration file which mysql is using when it starts off
If no file found, double check which instance of mysqld is running by issuing
user@Sys-201:/etc/mysql/conf.d$ which mysqld
The one with the above matches the one listed, issue the following command to detect the order of loading the configuration files.
user@Sys-201:/etc/mysql/conf.d$ mysqld –verbose –help | grep -A 1 “Default options”
mysqld: Can’t change dir to ‘/var/lib/mysql/’ (Errcode: 13 – Permission denied)
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
Once you know for certain that the configuration file used, the same can be associated with MySQL – Workbench by
Database-ManageConnections-> Select Connection in the Left hand pane-> The right hand side pane is enabled, select System Profile Tab-> Configuration File, specify the config file