linux(centOs7)腾讯云部署mysql(8.0.20)数据库,在腾讯云上面已经部署成功
环境配置:
腾讯轻量应用服务器,使用的是centos
下载链接
wget https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar
先在local创建mysql文件夹
cd /usr/local
mkdir mysql
解压
tar -xvf mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql
如果报错:
warning: mysql-community-libs-8.0.20-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
mariadb-libs is obsoleted by mysql-community-libs-8.0.20-1.el7.x86_64
解决方法:
#先卸载mysql-libs
yum remove mysql-libs
解压好文件按以下顺序安装
rpm -ivh mysql-community-common-8.0.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.20-1.el7.x86_64.rpm
yum install net-tools
rpm -ivh mysql-community-server-8.0.20-1.el7.x86_64.rpm
查看mysql状态systemctl status mysqld
启动mysql systemctl start mysqld
开机自启 systemctl enable mysqld
查看已经启动的服务(yum install net-tools)
netstat -tunlp
netstat -tunlp|grep mysql
查看mysql进程 ps -ef|grep mysql
Rpm安装固定路径
查阅数据库的临时密码
查看内容 cat /var/log/mysqld.log
查看临时密码 cat /var/log/mysqld.log|grep password
使用临时密码登录
mysql -uroot -p
设置密码最短长度
set global validate_password.length=4;
set global validate_password.policy=0;
这两种都可以试一下,忘记那个可以了
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY 密码(要引号);
查看密码长度和验证策略
SHOW VARIABLES LIKE ‘validate_password%’;
设置mysql远程访问
use mysql
update user set host = ‘%’ where user = ‘root’;
flush privileges;
select user,host from user’;