liunx rpm方式安装mysql

liunx mysql安装过程

1. 下载mysql-5.7.25-1.el7.x86_64.rpm-bundle.tar.gz压缩包
2. 解压到指定目录：tar -zxvf mysql-5.7.25-1.el7.x86_64.rpm-bundle.tar.gz -C /root/Environment/mysql(根据自己选择)
3. 按顺序安装rpm软件包
   • rpm -ivh mysqlmysql-community-community-5.7.25-1.el7.x86_64.rpm
   • rpm -ivh mysqlmysql-community-libs-5.7.25-1.el7.x86_64.rpm
   • rpm -ivh mysqlmysql-community-devel-5.7.25-1.el7.x86_64.rpm
   • rpm -ivh mysqlmysql-community-libs-compat-5.7.25-1.el7.x86_64.rpm
   • rpm -ivh mysqlmysql-community-client-5.7.25-1.el7.x86_64.rpm
   • yum install net-tools (后面包需要依赖此包)
   • rpm -ivh mysqlmysql-community-server-5.7.25-1.el7.x86_64.rpm
4. 启动mysql
   • systemctl status mysql 查看mysql服务状态
   • systemctl start mysql 启动mysql服务
   • systemctl enable mysql 开机启动mysql服务
   • netstat -tunlp 查看已经启动的服务
   • netstat -tunlp | grep mysql
   • ps -ef | grep mysql 查看mysql进程
5. 查询临时密码，登录mysql数据库
   • cat /var/log/mysqld.log 查看文件
   • cat /var/log/mysqld.log | grep password 查看文件中包含password的行信息
   • mysql -uroot -p 登录MySQL
6. 修改mysql密码
   • set global validate_password_length=4; 设置密码长度最低位数
   • set global validate_password_policy=LOW; 设置密码安全等级底，便于密码可以修改成root
   • set password=password(‘root’); 设置密码为root
   • grant all on . to ‘root’@‘%’ identified by ‘root’; 开启外部访问权限
   • flush privileges; 立即生效