CentOS7 64-bit installation mysql graphic tutorial

Prerequisites for installing MySQL: Install CentOS 7 64-bit, and the CentOS 7 system can connect to the network <br /> After completion, open the terminal and check whether MySQL has been installed:

Type in the terminal

yum list installed | grep mysql

As shown below:

This shows that mysql has been installed. If it has been installed, uninstall it first and enter in the terminal:

yum -y remove mysql-libs.x86_64

Remove the installed mysql
After deleting, enter in the terminal:

yum install mysql-community-server

As shown below:

This is the beginning of the installation. As long as the system can connect to the network, it will automatically download and install. Yum will automatically handle the dependencies between MySQL and other components. During the automatic installation process, you will be asked to choose whether to continue downloading, etc. Enter y and press Enter as shown below:

Until the end, it will prompt that the installation is complete and all the dependencies that have been installed are as follows:

This means that the installation is complete. The reason why there is a replacement in mine is that I did not delete the installed mysql before.
After the installation is complete, enter in the terminal: systemctl start mysqld
Restart the mysql service, set the initial username and password, and enter in the terminal: mysql_secure_installation

As shown above: Generally, after installation, the user name is root and the password is empty, so just press Enter after the above picture appears, as shown below:

Type y and press Enter

You will then be prompted to enter the new password to confirm it, then enter y and press Enter to complete it.

After installing MySQL, if you want to access MySQL remotely , you need to open the default port number 3306 .
Type in the terminal: systemctl start mysqld
Restart the mysql service, then enter:

firewall-cmd –permanent –zone=public –add-port=3306/tcp 
firewall-cmd –permanent –zone=public –add-port=3306/udp 

These two commands can open port 3306, as shown below:

When executing the yum command, I got the error: /var/run/yum.pid is locked and another program with PID xxxx is running. If this occurs, then

rm -f /var/run/yum.pid

After deleting the file, run yum again to make it available.

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.