mysql workbench installation and configuration tutorial under centOS

This article shares the MySQL Workbench installation and configuration tutorial for your reference. The specific contents are as follows

Step 0: Install MySQL

Before following the workbench, install mysql first. The instruction is

yum install mysql mysql-server mysql-libs mysql-server

The functions of each mysql package are:

“mysql for the client tools, mysql-server for the server and associated tools, and mysql-libs for 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 command to install is that it is more convenient, but the disadvantage is that the version installed by the yum command is generally slightly behind the latest version...

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

Official description:

"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 the MySQL server is:

root-shell> service mysqld start

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

root-shell> chkconfig --levels 235 mysqld on

After mysql and mysqlserver are installed, you can install workbench.

Step 1: Download the workbench installation file from the official website of MySQL

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

step2: After downloading, click to install

Double-click the downloaded file to install it

You will be prompted for additional packages to be installed, just click install.

It prompts you to enter a password, just enter the root password

After that, it will download the dependent packages by itself

step3: Open port 3306

Because mysql uses port 3306 by default, and centOS does not open this port by default, so you need to open it first. The command is

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

Save settings

/etc/rc.d/init.d/iptables save

Step 4: 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 the password.

Then just keep pressing 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 entire library is still empty and there is nothing in it.

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

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.