Linux离线安装MySql5.7-源码方式

mysql

• 检查自带mariadb数据库 并删除

  #查看mariadb
  rpm -qa|grep mariadb
  
  #删除mariadb
  yum remove mariadb-libs
  

• 把下载好的 mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz 放到 /opt 目录下

• 解压，移动并重命名

• tar -zxvf /opt/mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz
  
  mv /opt/mysql-5.7.37-linux-glibc2.12-x86_64 /usr/local/mysql
  

• 递归修改权限为 mysql组 mysql用户

• useradd -g mysql mysql
  
  chown mysql.mysql -R /usr/local/mysql
  

• 在/usr/local/mysql/support-files/路径下创建 my.cnf

• vim /usr/local/mysql/support-files/my_default.cnf
  

• 粘贴复制以下内容

• [mysqld]
  #设置mysql的安装目录
  basedir =/usr/local/mysql
  #设置mysql数据库的数据存放目录
  datadir = /usr/local/mysql/data
  #设置端口
  port = 3306
  
  socket = /tmp/mysql.sock
  #设置字符集
  character-set-server=utf8
  #日志存放目录
  log-error = /usr/local/mysql/data/mysqld.log
  pid-file = /usr/local/mysql/data/mysqld.pid
  #允许时间类型的数据为零(去掉NO_ZERO_IN_DATE,NO_ZERO_DATE)
  sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  #ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  

• 拷贝覆盖 /etc/my.cnf

• cp /usr/local/mysql/support-files/my.cnf /etc/my.cnf
  

• 在 /usr/local/mysql/ 目录下 初始化mysql

• ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
  

• 初始化完成之后查看日志，获得初始密码

• vim /usr/local/mysql/data/mysqld.log
  

  

• 启动服务 (/mysql/support-files 目录下 )

• [root@seckill support-files]# ./mysql.server start
  

  

• 登录服务(/mysql/bin 目录下)

• [root@seckill bin]# ./mysql -uroot -p
  

• 修改初始密码，添加远程访问权限，刷新退出

• mysql>set password for root@localhost = password('123456');
  
  mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
  
  mysql>FLUSH PRIVILEGES;
  mysql>exit;
  

• mysql启动项目加入系统服务

• # 复制 mysql.server 至/etc/init.d/重命名为 mysqld
  cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
  
  # 添加系统服务(service)启动信息
  chkconfig --add mysqld     # 服务名字为mysqld
  

• 启动服务并查其状态

systemctl start mysqld
systemctl status mysqld

另外可参考：

linux离线安装mysql5.7_东皇太医的博客-CSDN博客_linux离线安装mysql5.7

Linux CentOS 7离线安装MySQL 5.7_PIG_先生的博客-CSDN博客_linux离线安装mysql