Install mysql workbench in centOS

Install mysql workbench in centOS
Step 0: Install mysql before following workbench. The command is yum install mysql-server mysql-libs mysql-server. the functions of mysql packages are as follows: "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 versions and environments such as Perl, Python and others. "the advantage of using the yum command to install is that it is more convenient, and the disadvantage is that the version installed by the yum command is slightly behind the latest version ...... After terminal prompts complete, it indicates that the installation is complete. The mysql configuration file is installed in/etc/my. cnf, mysql server startup script 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, will have been installed into/etc/init. d/mysqld. "command to start MySQL server is: root-shell> service mysqld start if you want to automatically start MySQL server when centOS is started, you can run the command root-shell> chkconfig -- levels 235 mysqld onmysql and mysq lserver to install workbench. Step 1: Download the workbench installation file from the mysql official website. http://dev.mysql.com/downloads/mirror.php?id=412155step2 : After the package is downloaded, click install and double-click the downloaded file to install the package that requires additional installation. Click install. Prompt that you need to enter the password. after entering the root password, it will download the dependent packagestep3: Open Port 3306 because mysql uses port 3306 by default, centOS does not open this port by default. Therefore, you must first open it, the command is/sbin/iptables-I INPUT-p tcp -- dport 3036-j ACCEPT to save the setting/etc/rc. d/init. d/iptables savestep4: Find the installed program, run MySQL workbench under application-> programming, you can see that MySQL workbench creates a new connection, click store in Keychain, save the password, and then keep OK until the connection is created. We can see that a new connection is created and double-click to open the connection. We can see that the entire library is still empty and there is nothing. In this case, you can create a database or select import.