window环境配置Mysql 5.7.21 windowx64.zip免安装版教程详解

[mysql]  
# 设置mysql客户端默认字符集  
default-character-set=utf8  
[mysqld]  
#设置3306端口  
port = 3306  
# 设置mysql的安装目录  
basedir=E:\mysql
# 设置mysql数据库的数据的存放目录  
datadir=E:\mysql\data
# 允许最大连接数  
max_connections=200  
# 服务端使用的字符集默认为8比特编码的latin1字符集  
character-set-server=utf8  
# 创建新表时将使用的默认存储引擎  
default-storage-engine=INNODB  
"#"为注释

E:\mysql\bin> mysqld -install;
Service successfully installed.

E:\mysql\bin>cd ../
E:\mysql> mysqld --initialize-insecure --user=mysql ; 

E:\mysql\bin> net start mysql;

E:\mysql\bin> mysql -u root -p;
Enter password: //这里直接回车
Welcome to the MySQL monitor. Commands end with ; or \g. 
Your MySQL connection id is 2 
Server version: 5.7.21 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> 

mysql> show databases; 
+--------------------+ 
| Database      | 
+--------------------+ 
| information_schema | 
| mysql       | 
| performance_schema | 
| sys        | 
+--------------------+ 
4 rows in set (0.00 sec)
mysql> use mysql; 
Database changed 
mysql> set password for 'root'@'localhost'=password('新密码');
mysql> flush privileges;

mysql> quit;
E:\mysql\bin> mysql -u root -p;
Enter password: