http://yjph83.iteye.com/blog/2205063 (mysql5.x 在windows下安装)
1、从官网下载MySQL5.7.21解压版64位
2、解压(我的解压路径为:H:\mysql-5.7.21-winx64,我将其改名去掉-,并移动到此位置H:\develop\mysql5.7.21。
3、添加环境变量(系统变量):
变量名:MYSQL_HOME
变量值:H:\develop\mysql5.7.21
修改系统变量path,在path原有值后添加路径:%MYSQL_HOME%\bin。
以管理员身份运行命令行工具:
H:\>mysqld --version
mysqld Ver 5.7.21 for Win64 on x86_64 (MySQL Community Server (GPL))
4、在H:\develop\mysql5.7.21路径下新建配置文件:my.ini,在my.ini中保存以下内容:
[mysqld]
#### database configure
basedir=H:\develop\mysql5.7.21
datadir=H:\develop\mysql5.7.21\data\
user=mysql
symbolic-links=0
#### skip configuration
# skip-name-resolve
#### innodb_configuration
innodb_file_per_table=1
innodb_open_files=4096
innodb_buffer_pool_size=1024M
innodb_log_group_home_dir=H:\develop\mysql5.7.21\mysqllog
#### character set
character-set-server=utf8
collation-server=utf8_general_ci
lower-case-table-names=1
#### log configure
pid-file=H:\develop\mysql5.7.21\mysqllog\mysqld.pid
log-error=H:\develop\mysql5.7.21\mysqllog\mysql01.err
log-bin=H:\develop\mysql5.7.21\mysqllog\mysql01-bin
slow-query-log=1
long-query-time=2
slow-query-log-file=H:\develop\mysql5.7.21\mysqllog\mysql01-slow.log
socket=H:\develop\mysql5.7.21\mysqllog\mysql.sock
relay-log=H:\develop\mysql5.7.21\mysqllog\mysql01-relay-bin
#### replication configure
server-id = 1
replicate-wild-ignore-table = mysql.%
replicate-wild-ignore-table = information_schema.%
replicate-wild-ignore-table = performance_schema.%
replicate-wild-ignore-table = sys.%
binlog-format=ROW
binlog-row-image=full
binlog-rows-query-log-events=1
sync_binlog=1
log-slave-updates=true
gtid-mode=on
enforce-gtid-consistency=true
#### time configure
explicit_defaults_for_timestamp=true
# [client]
#socket=H:\develop\mysql5.7.21\mysqllog\mysql.sock
5、命令行运行
H:\>mysqld --initialize --basedir=H:\develop\mysql5.7.21 --datadir=H:\develop\mysql5.7.21\data
H:\>mysqld --install
Service successfully installed.
H:\>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
6、在H:\develop\mysql5.7.21\mysqllog\mysql01.err 日志中找到
2018-06-15T01:57:06.631815Z 1 [Note] A temporary password is generated for root@localhost: Ha)w-V0&P5ta
初始密码
7、登录mysql
H:\>mysql -u root -p"Ha)w-V0&P5ta"
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.21-log
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
登录后修改密码并刷新,再退出:
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password8');
Query OK, 0 rows affected, 1 warning (0.04 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)
mysql> exit;
Bye
再用新密码登录并显示数据库;
H:\>mysql -u root -p
Enter password: *********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.21-log MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql>
create database workbook default character set utf8 collate utf8_general_ci;
create database workbook default character set utf8mb4 collate utf8mb4_general_ci;
#以上命令是创建数据库 workbook ,设置字符集和排序;
create user workbook@'%' identified by 'password8';
#创建用户 workbook@'%', 因mysql是 用户名+主机名 才是完整的用户名;
grant all privileges on workbook.* to workbook@'%';
#给用户workbook@'%' 赋所有权限
grant select on workreport.* to workbook@'%';
#给用户workbook@'%' 读取权限
grant replication client on *.* to workbook@'%';
#给用户workbook@'%' 赋主从复制权限
flush privileges;
相关推荐
主要为大家详细介绍了win10下mysql5.7.21安装的详细过程,以及安装Mysql 5.7.21遇到的问题,具有一定的参考价值,感兴趣的小伙伴们可以参考一下
主要为大家详细介绍了win10下mysql5.7.21解压版安装教程,具有一定的参考价值,感兴趣的小伙伴们可以参考一下
oracle database mysql-5.7.21 may be installed in win7 etc.
本文记录了mysql 5.7.21 安装配置方法,分享给大家。 1.下载安装包 下面是官网windows系统的mysql下载地址 Mysql下载地址 点进去页面如下 根据你电脑的系统选择对应的mysql数据库下载即可。 下载完毕后点击下载的...
mysql-5.7.21-winx64 数据库 mysql-5.7.21-winx64 数据库
主要为大家详细介绍了win10下mysql 5.7.21解压版安装配置方法图文教程,具有一定的参考价值,感兴趣的小伙伴们可以参考一下
主要介绍了MySql 5.7.21免安装版本win10下的配置方法,本文图文并茂给大家介绍的非常详细,需要的朋友可以参考下
window环境安装mysql5.7.21,具体内容如下 1. 从MySQL官网下载免安装的压缩包mysql-5.7.21-winx64.zip 2. 解压到相应的目录(此处解压到F:\mysql-5.7.21-winx64) 3. 配置环境变量,将MySQL的启动目录(F:\mysql-...
由于本人经常装系统,每次装完系统之后都要重新安装一些软件,安装软件的时候又要上网查找安装的教程,比较麻烦,所以自己整理了MySQL5.7.21解压版的安装方法,以便查看。 1.首先,你要下载MySQL解压版,下载地址:...
主要介绍了Win7x64下Mysql5.7.18解压版的安装方法,需要的朋友可以参考下
mysql 5.7.21 winx64免安装版配置方法,供大家参考,具体内容如下 ...# 设置mysql的安装目录 basedir=D:\Program Files\mysql-5.7.21-winx64 # 设置mysql数据库的数据的存放目录 datadir=D:\Program Files\mysql-5.
1.从官网下载mysql-5.7.21-windowx64.zip mysql下载页面 2.解压到合适的位置(E:\mysql) 这名字是我改过的 3.配置环境变量,将E:\mysql\bin 添加到PATH中 4.在mysql目录下(E:\mysql) 创建 my.ini文件,内容如下: ...
1 下载 地址是:https://dev.mysql.com/downloads/mysql/ ...# 设置mysql的安装目录 basedir=D:\Program Files\mysql-5.7.21-winx64 # 设置mysql数据库的数据的存放目录 datadir=D:\Program Files\mysql-5
mysql 下载安装配置 5.7.20 / 5.7.21,供大家参考,具体内容如下 1、下载mysql,下载地址 选择操作系统和版本,我是64位win10,点击 Download 后会跳到Oracle登录页面要求登录后才能下载: 登录后下载: 2、下载...
setup.bat ,clear.bat放在 mysql-5.7.21-winx64 目录下与bin,data同级目录 即可一键便携式安装部署mysql(注册服务型mysql)如需要免安装mysql请看其他文章
Qt发布,在别的电脑无法连接MySQL数据库时,需要用到的libmysql.dll(测试环境为Qt的版本号是Qt5.4.0(32位),MySQL的版本号是mysql-5.7.21-win32)