Tutorial on installing MySQL on Alibaba Cloud Centos 7.5

It seems that the mysql-sever file for installing MySQL normally is not available in the yum source of CentOS 7. You need to download it 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 the mysql service

# service mysqld restart

When you first install MySQL, the root account has no password.

The method statement for setting the password ends with a semicolon

#mysql -uroot 
mysql> set password for 'root'@'localhost' = password('mypasswd');

Create a database and specify utf-8 encoding

mysql> CREATE DATABASE xxxx DEFAULT CHARSET utf8 COLLATE utf8_general_ci

Importing a database

mysql>use database -- Then use the source command, followed by the script file (such as the .sql file used here) 
mysql>source dbname.sql

The above is the tutorial on installing MySQL on Alibaba Cloud Centos 7.5. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!