Detailed steps for installing MySQL Workbench under CentOS

STEP0: Installing MySQL

Before you follow Workbench, install MySQL first. Directive is

Yum install MySQL mysql-server mysql-libs mysql-server

The features of the MySQL packages are:

"MySQL for the client tools, Mysql-server for the server and associated tools, and mysql-libs for the libraries. The libraries is required if you want to provide connectivity from different languages and environments such as Perl, Pyt Hon and others. "

The benefits of installing with the Yum command are more convenient, and the downside is that the General Yum command installs a bit less than the latest version ...

Terminal prompts complete, the installation is finished. The MySQL configuration file is installed into the /etc/my.cnf,mysql server startup script that is installed to /etc/init.d/mysqld

Official Note:

"A Sample configuration file is installed into /etc/my.cnf. An init script, to start and stop the server, 'll has been installed into /etc/init.d/mysqld. ”

The commands to start MySQL server are:

Root-shell> Service mysqld Start

If you want to start MySQL server automatically when the CentOS boot, you can use the instructions

root-shell> chkconfig--levels 235 mysqld on

MySQL and mysq lserver can be installed after the workbench.

Step1: Download Workbench installation file to MySQL's official website

http://dev.mysql.com/downloads/mirror.php?id=412155

Step2: After downloading, click Install

Double-click the downloaded file to install

You will be prompted for a package that requires additional installation, just click Install.

Prompt to enter a password, enter the root password is good

It will then download the package it depends on.

Step3: Open Port 3306

Because MySQL uses 3306 ports by default, and CentOS does not open this port by default, you must first open it, and the command is

/sbin/iptables-i input-p TCP--dport 3036-j ACCEPT

Save Settings

/etc/rc.d/init.d/iptables Save

Step4: Find the installed program and run MySQL Workbench

You can see MySQL Workbench under Application->programming.

Create a new connection

Click Store in keychain to save your password

Then always OK until you create this connection.

You can see that we have created a new connection, double-hit the connection.

As you can see, the whole library is still empty and nothing is present.

You can create a new database at this point, or select Import.

Http://www.cnblogs.com/elaron/archive/2013/03/19/2968699.html

Detailed steps for installing MySQL Workbench under CentOS