华为云ECS下安装MySQL

华为云ECS安装MySQL-5.7.26

1. Download MySQL Linux version

MySQL download url

2. 下载完毕tar包

mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar

3. 解压tar包

tar xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar

mysql-community-client-5.7.26-1.el7.x86_64.rpm
mysql-community-common-5.7.26-1.el7.x86_64.rpm
mysql-community-devel-5.7.26-1.el7.x86_64.rpm
mysql-community-embedded-5.7.26-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.26-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.26-1.el7.x86_64.rpm
mysql-community-libs-5.7.26-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm
mysql-community-server-5.7.26-1.el7.x86_64.rpm
mysql-community-s>mysql-community-test-5.7.26-1.el7.x86_64.rpmerver-5.7.26-1.el7.x86_64.rpm

4. Install mysql-community

安装依赖

yum install libaio
yum install net-tools

安装rpm包

rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.23-1.el7.x86_64.rpm

5. 验证安装状态

验证安装，查看版本

mysqladmin --version

mysqladmin Ver 8.42 Distrib 5.7.26, for Linux on x86_64

6. Mysql 初始化并查看初始临时密码

MySQL服务初始化

mysqld --initialize

查看初始临时密码

grep ‘temporary password’ /var/log/mysqld.log | tail -1

2019-08-17T04:49:01.587345Z 1 [Note] A temporary password is generated for root@localhost: asdfghjkliop

7.修改mysql数据库目录的所属用户及其所属组

chown -R mysql:mysql /var/lib/mysql

8.启动MySQL服务

查看当前的mysqld服务状态

systemctl status mysqld

将mysqld服务设置为开机启动

systemctl enable mysqld

启动mysqld服务

systemctl start mysqld

9. 登录MySQL并设置允许远程登陆

mysql -uroot -p
Enter password:
mysql> set password=password(‘your pwd’);
mysql>use mysql;
mysql>update user set host=’%’ where user=‘root’;

10. 配置my.cnf

查看/etc/my.cnf

cat /etc/my.cnf

编辑/etc/my.cnf

bind-address=0.0.0.0

11. 配置防火墙firewalld

配置防火墙端口3306开放状态

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
firewall-cmd --complete-reload

12. 华为云控制台配置

验证是否能够ping通ECS对应的弹性公网IP

如果能正常ping，是可以进行直接链接的
如果不能正常ping，需要配置一下华为云的访问控制-安全组和网络ACL