MySQL免安装版下载及安装

1.下载安装包

Mysql官网下载地址.

解压

2.安装

1.以管理员身份打开

2.切换到mysql的解压目录

3.执行安装命令

• mysqld --install
  
• mysqld --initialize --console
  
• 在bin下面执行 net start MySQL
  
• 登录 mysql -u root -p
  

4.修改密码

• ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
  
• prior MySQL 5.7.5:
  SET PASSWORD FOR root@localhost=PASSWORD(‘12345’);
  
• after MySQL 5.7.6:
  ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘12345’;
  
• UPDATE mysql.user
  SET authentication_string = PASSWORD(‘newPass’), password_expired = ‘N’
  WHERE User = ‘root’ AND Host = ‘localhost’;
• FLUSH PRIVILEGES;
  
  

3.配置环境变量