linux环境下mysql安装部署

linux环境下mysql安装部署

1. mysql官网：https://www.mysql.com/

   # 下载mysql
   wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.33-1.el8.x86_64.rpm-bundle.tar
   # 解压文件
   tar -xvf mysql-8.0.33-1.el8.x86_64.rpm-bundle.tar
   # 安装所需rpm包
   rpm -ivh mysql-community-client-plugins-8.0.33-1.el8.x86_64.rpm
   rpm -ivh mysql-community-common-8.0.33-1.el8.x86_64.rpm
   rpm -ivh mysql-community-libs-8.0.33-1.el8.x86_64.rpm
   rpm -ivh mysql-community-icu-data-files-8.0.33-1.el8.x86_64.rpm
   rpm -ivh mysql-community-client-8.0.33-1.el8.x86_64.rpm
   rpm -ivh mysql-community-server-8.0.33-1.el8.x86_64.rpm
   # 依赖检测失败：
   #	mariadb-connector-c-config 被 mysql-community-server-8.0.33-1.el8.x86_64 取代
   yum remove mariadb-connector-c-config.noarch
   # 数据库初始化
   mysqld --initialize
   # 赋予文件权限
   chmod -R 777 /var/lib/mysql
   # 重启数据库
   systemctl restart mysqld.service
   # 查看数据库状态
   systemctl status mysqld.service
   
   # 注意安装服务端，否则无法启动，安装后默认无密码
   yum install mysql-server
   

2. mysql安装后临时密码

   # 查询临时密码
   grep password /var/log/mysqld.log
   

3. mysql无客户端登录

   mysql -u root -p
   

4. mysql修改密码

   # 注意-u 和 -p后无空格
   mysqladmin -u用户 -p旧密码 password 新密码
   mysqladmin -uroot -p123456 password 123
   
   # set password
   mysql> set password for 用户名@localhost = password('新密码');
   mysql> set password for root@localhost = password('123');
   

5. 开通防火墙端口

   # 查看防火墙状态
   firewall-cmd --state
   # 防火墙添加redis端口
   firewall-cmd --permanent --add-port=3306/tcp
   # 查看端口
   firewall-cmd --permanent --query-port=3306/tcp
   firewall-cmd --permanent --list-ports
   # 重启防火墙
   firewall-cmd --reload
   

6. 设置访问权限

   # 数据库安装后默认只能本地访问，需修改用户访问地址
   -- use mysql;
   select host, user from user;
   update user set host='%' where user = 'root';
   # 刷新
   flush privileges;