华为云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