mysql-5.7.32-win64安装及初始化

下载

• 官网： https://downloads.mysql.com/archives/community/
• 下载：mysql-5.7.32

解压

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.32-winx64.zip
unzip mysql-5.7.32-winx64.zip

当然解压工具有很多：winrar、360压缩等等

配置文件

• 配置文件my.ini新建到解压的根目录，与bin目录在同一级，写入以下内容

  [mysql]
  default-character-set=utf8 
  [mysqld]
  port = 3306 
  basedir=G:\mysql-5.7.32-winx64\mysql-5.7.32-winx64
  datadir=G:\mysql-5.7.32-winx64\mysql-5.7.32-winx64\data
  max_connections=200
  character-set-server=utf8
  default-storage-engine=INNODB
  [client]
  port=3306
  

初始化

• 把bin目录添加至环境变量
  
  
• 在bin目录的目录栏键入cmd并回车，进入dos命令
  
• 在dos命令行中键入以下内容

  mysqld --initialize-insecure --user=mysql
  mysqld install mysql
  net start mysql 
  mysql -uroot
  # 设置root密码
  SET PASSWORD=PASSWORD('123456');
  # 允许远程登陆
  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
  FLUSH PRIVILEGES;
  exit
  

  • 如果报缺少什么.dll文件，可以尝试安装Microsoft Visual C++ 2013 Redistributable (x64)，当然，具体情况需要具体分析
• 测试

  SET NAMES utf8;
  CREATE DATABASE IF NOT EXISTS gradesystem DEFAULT CHARSET utf8 COLLATE utf8_unicode_ci;
  USE gradesystem;
  CREATE TABLE IF NOT EXISTS student(
  s_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  s_name VARCHAR(60),
  s_sex ENUM('男', '女'),
  s_age INT(3)
  )ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT=1;
  
  CREATE TABLE IF NOT EXISTS course(
  c_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  c_name VARCHAR(60)
  )ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT=1;
  
  CREATE TABLE IF NOT EXISTS grade(
  s_id INT(11) NOT NULL REFERENCES Student(Sid),
  c_id INT(11) NOT NULL REFERENCES Course(Cid),
  g_score FLOAT,
  PRIMARY KEY(s_id, c_id)
  )ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci;
  
  INSERT INTO student(s_name, s_sex, s_age) VALUES('小红', '女', '18'), ('小王', '男', '19'), ('小花', '女', '17'), ('小明', '男', '18');
  INSERT INTO course(c_name) VALUES('语文'), ('数学'), ('英语');
  INSERT INTO grade(s_id, c_id, g_score) VALUES(1, 1, 80), (1, 2, 70), (1, 3, 90), (2, 1, 73), (2, 2, 91), (2, 3, 65), (3, 1, 89), (3, 2, 75), (3, 3, 83), (4, 1, 61), (4, 2, 59), (4, 3, 43);
  

注

• 参考博文：https://blog.csdn.net/gghhm/article/details/104987729