MySQL免安装版 配置
-
MySQL官方网址:https://dev.mysql.com/downloads/mysql/
-
将下载文件解压到一个文件夹:
D:\AZ\
-
配置环境变量:
Path:D:\AZ\mysql-8.0.18-winx64\bin
-
创建
my.ini
文件,放在:D:\AZ\mysql-8.0.18-winx64\
目录下 -
编辑
my.ini
文件,内容如下,注意修改里面的安装目录,并将此文件保存成 ASCII 格式(记事本-另存为-可以选择编码):
[mysqld]
bind-address = 0.0.0.0
basedir = D:\AZ\mysql-8.0.18-winx64
datadir = D:\AZ\mysql-8.0.18-winx64\data
port = 3306
max_connections = 200
loose-default-character-set = utf8
explicit_defaults_for_timestamp = true
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
wait_timeout=315360000
interactive-timeout=315360000
[client]
port=3306
default-character-set = utf8
[WinMySQLadmin]
Server = D:\AZ\mysql-8.0.18-winx64\bin
-
管理员身份运行 cmd 命令提示符(不要用 powershell),进入D:\AZ\mysql-8.0.18-winx64\bin 目录下,运行:
mysqld –-initialize
-
上一步会产生一个
D:\AZ\mysql-8.0.18-winx64\data
文件夹 -
安装MySQL服务,在第6步的 cmd 窗口继续运行:
mysqld install
-
运行命令启动服务:
net start mysql
-
登陆:
mysql -u root -p
-
第10步会提示你输入密码,找到第7步生成的
data
文件夹,找到后缀.err
的文件,搜索password关键字,查看临时密码,输入 -
上面使用的是临时密码,我们修改密码为 123456:
set password for root@localhost = password('123456');
如果上面不行,运行下面修改密码的方式:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
FLUSH PRIVILEGES; # 刷新权限
-
退出登陆:
exit
-
停止服务:
net stop mysql
-
卸载服务:
- 注册表删除:
reg delete "HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\services\eventlog\Application\MySQL" /f
reg delete "HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\eventlog\Application\MySQL" /f # 可能没有
reg delete "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL" /f # 可能没有
reg delete "HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\services\MySQL" /f # 可能没有
net stop mysql
sc delete mysql
然后删除安装文件夹