2021-03-15

CentOS8 安装 m...

安装依赖
1
2
yum update
yum install ncurses-compat-libs
下载安装包
可以自行选择下载的版本 https://repo.mysql.com/yum/
1
2
3
4
wget https://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-libs-5.7.31-1.el7.x86_64.rpm
wget https://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-common-5.7.31-1.el7.x86_64.rpm
wget https://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-client-5.7.31-1.el7.x86_64.rpm
wget https://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-server-5.7.31-1.el7.x86_64.rpm
安装
1
2
3
4
rpm -Uvh mysql-community-libs-5.7.31-1.el7.x86_64.rpm
rpm -Uvh mysql-community-common-5.7.31-1.el7.x86_64.rpm
rpm -Uvh mysql-community-client-5.7.31-1.el7.x86_64.rpm
rpm -Uvh mysql-community-server-5.7.31-1.el7.x86_64.rpm
启动
1
systemctl start mysqld
查找默认密码
1
grep 'temporary password' /var/log/mysqld.log
使用默认密码登录
1
mysql -u root -p
更改默认密码
1
set password for 'root'@'%' = password('123456');
更改密码校验等级
1
set global validate_password_policy=0;
创建新用户密码
1
create user 'chutianshu'@'%' identified by 'XXXXXXXX';
授权
1
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' identified by '123456';
使生效
1
flush privileges;
更改端口
1
vim /etc/my.cnf
在文件中加入
1
port=63306