1.cd到自定好的文件夹中输入
wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm
2、安装数据源
yum install mysql80-community-release-el8-1.noarch.rpm
3、检查数据源
查看mysql源是否安装成功:yum repolist enabled | grep “mysql.-community.”
4、配置数据源(可不配置)
修改yum源,可不配置
配置yum源:cat /etc/yum.repos.d/mysql-community.repo
5、禁用CentOS8自带mysql模块
yum module disable mysql
6、安装数据库
真正安装mysql
安装语句:yum install mysql-community-server
7、启动mysql
输入:
service mysqld start
service mysqld status
8、显示mysql的随机密码
输入:grep ‘temporary password’ /var/log/mysqld.log
9、登录并修改mysql密码
登录:mysql -u root -p
然后输入上面生成的密码
修改密码:
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘Root_21root’;
查看密码策略:SHOW VARIABLES LIKE ‘validate_password%’;
修改密码长度:set global validate_password.length=1;(长度)
修改密码等级:set global validate_password.policy=0;(等级)
修改后再次查看
设置自己想要的密码
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘123456’;
10、Mysql8.0.22开放远程访问
真确写法:
1、先创建权限记录:create user ‘root’@’%’ identified by ‘root123’;
2、授权:grant all privileges on . to ‘root’@’%’ with grant option;
两句话分开写:
安装node
sudo yum install -y nodejs
安装cnpm
npm install -g cnpm --registry=https://registry.npm.taobao.org