腾讯云centos7.6安装mysql

发布时间 2024-01-03 17:24:56作者: huim
# 禁用原生mysql
yum module disable mysql
# 删除mariadb
rpm -qa | grep mariadb
rpm -e mariadb-libs --nodeps
# 下载mysql压缩包
mkdir /opt/mysql
cd /opt/mysql/
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar
# 解压并安装
tar -xvf mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar
yum -y install mysql-community-common-*
yum -y install mysql-community-libs-5.7.30-1.el7.x86_64.rpm
yum -y install mysql-community-client-5.7.30-1.el7.x86_64.rpm
yum -y install mysql-community-server-5.7.30-1.el7.x86_64.rpm
# 启动mysql
systemctl start mysqld.service
# 查看初始密码
cat /var/log/mysqld.log |grep password
# 连接mysql,输入初始密码
mysql -u root -p

## mysql界面
# 修改新密码
alter user user() identified by "「新密码」";
# 允许远程登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '「新密码」' WITH GRANT OPTION;
FLUSH PRIVILEGES;

腾讯云放开防火墙即可