离线安装单机版mysql

• mysql 网盘链接
  链接: https://pan.baidu.com/s/1Y1jhlXmHigTBvAgG8QzL3w 提取码: 3n2v

• 创建软件上传目录

  mkdir /export/software
  mkdir /export/server
  

• 进入上传目录并上传mysql

  cd /export/software
  

• 解压

  tar  -zxvf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz -C /export/server/
  

• 重命名

  cd /export/server
  mv mysql-5.7.29-linux-glibc2.12-x86_64  mysql-5.7.29
  

• 添加用户组

  groupadd mysql
  useradd -r -g mysql mysql
  

• 修改目录权限

  chown -R mysql:mysql /export/server/mysql-5.7.29/
  

• 配置mysql服务

  cp /export/server/mysql-5.7.29/support-files/mysql.server /etc/init.d/mysql
  

• 修改配置文件

  vim /etc/init.d/mysql
  #将该文件的basedir和datadir路径修改为以下内容
  basedir=/export/server/mysql-5.7.29
  datadir=/export/server/mysql-5.7.29/data
  

• 修改配置文件my.cnf

  vim /etc/my.cnf
  # 删除掉所有内容 使用下边内容
  
  [client]
  	port=3306
  	default-character-set=utf8
  	[mysqld]
  	basedir=/export/server/mysql-5.7.29
  	datadir=/export/server/mysql-5.7.29/data
  	port=3306
  	character-set-server=utf8
  default_storage_engine=InnoDB
  

• 初始化mysql

  /export/server/mysql-5.7.29/bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql --basedir=/export/server/mysql-5.7.29 --datadir=/export/server/mysql-5.7.29/data
  
  # 保存命令生成的临时密码
  

• 启动mysql

  service mysql start
  

• 登录mysql

  /export/server/mysql-5.7.29/bin/mysql -uroot -p
  # 再输入临时密码
  

• 修改密码

  set password=password('123456');
  

• 开启远程访问

  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456'; 
  flush privileges;
  

• 退出MySQL

  exit
  

• 配置环境变量

  vim /etc/profile
  #追加配置
  export MYSQL_HOME=/export/server/mysql-5.7.29
  export PATH=$PATH:$MYSQL_HOME/bin
  

• 刷新环境变量

  source /etc/profile