Detailed explanation of how to install MySQL on Alibaba Cloud

As a lightweight open source database, MySQL is widely used in enterprise-level applications. I have used mssql, oracle, postgresql, mysql before. There is currently no Oracle on Alibaba Cloud. From my personal experience, I would choose MySQL first when creating a project.

Uninstall the existing mysql

The mysql database may already exist in the system, so we need to uninstall it before installation.

# rpm -qa|grep -i mysql

This command will display the installed MySQL software, and then you can uninstall the software one by one using the following commands. Note: This uninstall is not complete, but it is enough here.

# yum remove 'software name'

Today I will briefly introduce the steps to install MySQL on Alibaba Cloud. My personal operating system is CentOs of Alibaba Cloud ECS. First, download and install mysql-server from the official website:

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server

After successful installation, restart mysql:

service mysqld restart

There is no password for the first installation. We need to set a password for root. First, switch to the mysql command:

mysql -u root

Set password:

mysql>set password for 'root'@'localhost' =password('password');

Remote connection settings, by default, do not allow all IPs to allow remote connections:

mysql> grant all privileges on *.* to root@'%' identified by 'password';

The latest Alibaba Cloud intranet inbound direction does not need to be set up, and the default MySQL port 3306 is already allowed.

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.