Installation and configuration tutorial of mysql workbench under centOS

This article shares the mysql workbench installation and configuration tutorial for your reference. The details are as follows.

Step0: installing mysql

Install mysql before following workbench. The instruction is

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

The functions of each package of mysql are:

Mysqlfor the client tools,mysql-serverfor the server and associated tools, andmysql-libsfor the libraries. The libraries are required if you want to provide connectivity from different languages and environments such as Perl, Python and others.

The advantage of using the yum instruction to install is more convenient, but the disadvantage is that the general version of the yum instruction installation lags slightly behind the latest version.

After terminal prompts complete, it means that the installation is complete. The configuration file of mysql is installed to / etc/my.cnf,mysql server and the startup script is installed to / etc/init.d/mysqld

Official statement:

"A sample configuration file is installed into/etc/my.cnf. An init script, to start and stop the server, will have been installed into/etc/init.d/mysqld."

The command to start MySQL server is:

Root-shell > service mysqld start

If you want to start centOS automatically when MySQL server boots, you can use the command

Root-shell > chkconfig-- levels 235 mysqld on

After mysql and mysq lserver are installed, you can install workbench.

Step1: download the workbench installation file from 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 additional installation of package, just click install.

Prompted to enter a password, just enter the password of root

Then it will download the dependent package on its own.

Step3: open port 3306

Because mysql uses port 3306 by default, and centOS does not open this port by default, open it first, the command is

/ sbin/iptables-I INPUT-p tcp-- dport 3306-j ACCEPT

Save Settin

/ 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 OK until the connection is created.

You can see that we have created a new connection. Double-click to open the connection.

As you can see, the whole warehouse is still empty and there is nothing.

At this point you can create a new database, or you can choose to import.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.