windows系统 mysql 解压版配置-优快云博客

本文链接：https://blog.youkuaiyun.com/javabaidu/article/details/84543063

本文指导您如何下载、配置并启动MySQL 5.6.17-Winx64数据库，包括解压、创建配置文件、设置路径、启动与关闭数据库以及修改root密码等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql下载
[url]http://dev.mysql.com/downloads/mysql/[/url]

mysql配置文档
[url]http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html[/url]

解压到目录
E:\mysql-5.6.17-winx64

在目录下新建配置文件
my.ini


[mysqld]
# set basedir to your installation path
basedir=E:\\mysql-5.6.17-winx64
# set datadir to the location of your data directory
datadir=E:\\mysql-5.6.17-winx64\\data


character-set-server=utf8
character_set_client=utf8

启动和停止



mysql-5.6.17-winx64\bin\mysqld --console

mysql-5.6.17-winx64\bin\mysqladmin -u root shutdown


error: Found option without preceding group in config file
缺少[mysqld]

必须要用命令行关闭，否则电脑不重启，系统无法再次启动

修改root密码
http://dev.mysql.com/doc/refman/5.6/en/default-privileges.html



shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'::1' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'%' = PASSWORD('newpwd');

MySQL启动和停止的脚本




@echo off

cd D:\mysql-5.6.10-winx64\bin
d:

echo 1、启动MySQL  2、关闭MySQL
SET /p action=请输入命令：
set /a action=%action%*1
if %action% equ 1 (goto start )else (goto shutdown)


:start
echo 启动MySQL。。。。。
start mysqld
goto :end


:shutdown
echo 关闭MySQL。。。。。
mysqladmin -uroot -proot shutdown
goto :end


:end

pause