MySQL 免安装教程
一、官网地址
官网地址:https://www.mysql.com/cn/
直达下载地址:https://dev.mysql.com/downloads/mysql/
下载页面引导
二、安装步骤
1、解压到文件夹
c:\dbserver\new\mysql-5.7.44-winx64\mysql-5.7.44-winx64
2、新建data文件夹
c:\dbserver\new\mysql-5.7.44-winx64\mysql-5.7.44-winx64\data
3、新建my.ini文件
c:\dbserver\new\mysql-5.7.44-winx64\mysql-5.7.44-winx64\my.ini
[mysqld]
character-set-server = utf8
bind-address = 0.0.0.0
port = 3306
basedir = c:/dbserver/new/mysql-5.7.44-winx64
datadir = c:/dbserver/new/mysql-5.7.44-winx64/data
max_connections = 2000
default-storage-engine = INNODB
[mysql]
default-character-set = utf8
[mysql.server]
default-character-set = utf8
[client]
default-character-set = utf8
4、安装服务
c:\dbserver\new\mysql-5.7.44-winx64\mysql-5.7.44-winx64\bin>mysqld --install
c:\dbserver\new\mysql-5.7.44-winx64\mysql-5.7.44-winx64\bin>sc description MySQL "服务描述"
5、mysql初始化
#不能有my.ini配置文件,否则会执行报错
c:\>mysqld --initialize --user=root --console
#执行过后得到随机密码:zefsF/nGV7jZ
6、开启服务
#以服务方式启动
c:\>net start mysql
#以命令行手动方式启动
c:\dbserver\new\mysql-5.7.44-winx64\mysql-5.7.44-winx64\bin>mysqld --console
6.1、延申语句
#关闭服务
c:\>net stop mysql
#删除服务
c:\>sc delete mysql
7、登录mysql
#-u后面跟用户名,-p后面跟密码
c:\>mysql -uroot -pzefsF/nGV7jZ
8、修改密码
mysql>set password=password('123');
#[允许从任何主机连接]
use mysql
UPDATE mysql.user SET host='%' WHERE user='root';
FLUSH PRIVILEGES;
#退出登录
mysql>exit;
9、配置环境变量
#系统变量
MYSQL_HOME="c:\dbserver\new\mysql-5.7.44-winx64\mysql-5.7.44-winx64"
PATH="%MYSQL_HOME%\bin"
#配置完成后,重启电脑生效