一键mysql windows10_【开发环境】10分钟丝滑安装Mysql8.0 For Windows10

更多文章，请关注微信公众号：“Python数据运营“特别说明：本文永远处于Beta版，内容会根据反馈或者新思路发生变化。

1.安装Mysql Server

下载

解压

解压至E:\mysql8

创建 my.ini

my.ini 是 MySQL 安装的配置文件，并放置到安装包解压的目录

[mysqld]

# 安装目录

basedir=E:\\mysql8

# 数据存放目录

datadir=E:\\mysqlData

#修改身份验证方式

default_authentication_plugin=mysql_native_password

初始化Mysql Server

进入解压目录

bin\mysqld.exe --defaults-file=my.ini --initialize --console

2020-03-26T02:39:32.219431Z 0 [System] [MY-013169] [Server] E:\mysql8\bin\mysqld.exe (mysqld 8.0.19) initializing of server in progress as process 6300

2020-03-26T02:39:42.735613Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: u.iVwsjf1V3m

启动Mysql Server

bin\mysqld.exe --console

2020-03-26T02:43:50.394581Z 0 [System] [MY-010116] [Server] E:\mysql8\bin\mysqld.exe (mysqld 8.0.19) starting as process 11612

2020-03-26T02:43:52.311427Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2020-03-26T02:43:52.829746Z 0 [System] [MY-010931] [Server] E:\mysql8\bin\mysqld.exe: ready for connections. Version: '8.0.19' socket: '' port: 3306 MySQL Community Server - GPL.

2020-03-26T02:43:53.047158Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060

一键快捷启动Mysql Server

创建start_mysql.bat文件，内容如下

@echo off

if "%1" == "h" goto begin

mshta vbscript:createobject("wscript.shell").run("%~nx0 h",0)(window.close)&&exit

:begin

::

e:\mysql8\bin\mysqld.exe --console

登陆Msyql Sever

bin\mysql.exe -u root -p #使用刚才初始化生成的密码

修改root用户的密码

需要修改身份验证，navicat等客户端才能连接

#ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY'123456';

FLUSH PRIVILEGES;

2. 常用命令

授予账号访问数据库权限

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'useranme'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;

显示账号及权限相关信息

SHOW GRANTS FOR 'username'@'localhost';

SHOW CREATE USER 'username'@'localhost';

创建数据库

create database log_db;

导出数据库

bin\mysqldump.exe -u root -h 127.0.0.1 --port=3306 --password log_db > log_db.sql

导入数据库

bin\mysql.exe -u root -p log_db < log_db.sql

更多文章，请关注微信公众号：“Python数据运营“