Mysql-workbench modifying MySQL configuration considerations

MySQL Workbench provides the environment for a comprehensive tool for DBAs and developers:

Database design and Modeling

SQL Development

Database management

Database migration

Recently tested Workbench, found to be very useful, especially in support of MySQL configuration file management.

Installation is also very simple, directly on the official website to download the installation of the corresponding system version.

http://dev.mysql.com/downloads/workbench/

If you are a Windows system, be aware of the installation run environment. NET4 and VC2013

• Microsoft. NET Framework 4 Client profile

• Visual C + + Redistributable for Visual Studio 2013

The following screen appears after successful operation

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/88/A1/wKioL1f969rAZFwEAADDkpioF-c418.png "title=" Workbench-en.png "width=" 640 "height=" 393 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:640px;height:393px; "alt=" Wkiol1f969razfweaaddkpiof-c418.png "/>

The configuration of MySQL under Linux can be managed remotely by configuring MySQL's system information and adding SSL information in link management.

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/88/A1/wKioL1f97RzyCYJGAAC8zC9fMr4669.png "title=" Workbench-en.png "alt=" Wkiol1f97rzycyjgaac8zc9fmr4669.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/88/A4/wKiom1f97ZqxtS4tAAEpSTqLIK4350.png "title=" Workbench-en.png "width=" 640 "height=" 427 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:640PX;HEIGHT:427PX; "alt=" Wkiom1f97zqxts4taaepstqlik4350.png "/>

After opening the admin link, click Options file in instance to view the admin profile

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/88/A4/wKiom1f97qCgmnQlAAeTfikO-5k611.jpg "title=" 11.jpg "Width=" 640 "height=" 398 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:640px;height:398px; "alt=" Wkiom1f97qcgmnqlaaetfiko-5k611.jpg "/>

Here is a small bug, after modifying the configuration file, restart the MySQL service and find all the configurations restored to the default configuration.

After the check, found that the/etc/my.cnf permissions to only root read and write permissions, the MySQL service by default is a MySQL user, you need to modify the MY.CNF permissions for other users to read.

# ls-l/ETC/MY.CNF-RW-------. 1 root root 986 Oct 15:11/etc/my.cnfchmod 644/etc/my.cnf# ls-l/etc/my.cnf-rw-r--r--. 1 root root 1019 Oct 15:12/etc/my.cnf

After restarting the MySQL service, it is normal and the configuration of the changes takes effect successfully.

Currently 6.3.7 version of Workbench Modifying the MySQL configuration file in Linux will change the file permissions to the user linked to SSH, this should be noted.

This article is from the "focus on drilling 100 years" blog, please be sure to keep this source http://titandeng.blog.51cto.com/823817/1861150

Mysql-workbench modifying MySQL configuration considerations