MySQL 安装 - Windows

最新推荐文章于 2024-09-20 21:48:23 发布

程序员35

最新推荐文章于 2024-09-20 21:48:23 发布

阅读量138

点赞数

分类专栏： MySQL 教程合集文章标签： mysql

本文链接：https://blog.csdn.net/cxy35/article/details/104855162

版权

MySQL 教程合集专栏收录该内容

15 篇文章

订阅专栏

手把手带你在 Windows 上安装 MySQL-5.6 。

# 下载免安装版本的 MySQL
# https://downloads.mysql.com/archives/community/
# mysql-5.6.42-winx64.zip

# 解压并准备配置文件 my.ini 放到下列目录中
D:\mysql-5.6.42-3306

# 修改配置文件 my.ini
[client]
port = 3306
#socket = D:\mysqldata\tmp\mysql.sock
default-character-set = utf8

[mysql]
default-character-set = utf8
prompt = "\\u:\\d> "
auto-rehash

[mysqld]
port = 3306
basedir = D:\mysql-5.6.42-3306
datadir = D:\mysql-5.6.42-3306\data
#socket = D:\mysql-5.6.42-3306\tmp\mysql.sock
#tmpdir = D:\mysql-5.6.42-3306\tmp
#log_bin = D:\mysql-5.6.42-3306\log\mysql-bin.log
#relay_log = D:\mysql-5.6.42-3306\log\mysql-relay-bin.log
#log_error = D:\mysql-5.6.42-3306\log\alert.log
#slow_query_log_file = D:\mysql-5.6.42-3306\log\mysql_slow.log
default-time-zone = '+8:00'
character-set-server = utf8
collation-server = utf8_unicode_ci
init_connect = 'SET NAMES utf8'
max_connections = 1000
max_user_connections = 1000
max_connect_errors = 90000000
max_allowed_packet = 16M
back_log = 5000
wait_timeout = 120
interactive_timeout = 120
sort_buffer_size = 2M
join_buffer_size = 2M
server-id = 1
default-storage-engine = innodb
innodb-file-per-table = 1
......

# 初始化
d:
cd mysql-5.6.42-3306/bin
mysqld.exe --initialize

# 将 mysql 从 windows 服务中移除
mysqld.exe --remove MySQL-3306

# 将 mysql 添加到 windows 服务中
mysqld.exe --install MySQL-3306 --defaults-file="D:\mysql-5.6.42-3306\my.ini"

# 启动服务
net start MySQL-3306

# 登录并修改密码（有些时候需要初始密码）
cd d:/mysql-5.6.42-3306/bin
mysql -uroot
# mysql -uroot -p
update mysql.user set password = password('123456') where user='root';
# alter user 'root'@'localhost' identified by '123456';
flush privileges;

# 授权远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;

# 关闭服务
net stop MySQL-3306

# 根据端口查询 pid
netstat -ano|findstr "3306"

# 根据 pid 查询进程名
tasklist|findstr "9452"

# 杀进程
taskkill /f /pid 9452