Mysql5.7 解压版安装全过程

[Mysql5.7](MySQL :: Download MySQL Community Server (Archived Versions))

MSVCR120.dll文件丢失 C++ 2013

mysql目录下新建my.ini

[mysqld]
basedir=D:\mysql-5.7.17-winx64
datadir=D:\mysql-5.7.17-winx64\data
port=3306

character-set-server=utf8
collation-server=utf8_general_ci

管理员运行CMD

mysqld --initialize --user=mysql --console

A temporary password is generated for root@localhost: wdu*Ye<vW25)

原始密码：wdu*Ye<vW25)

修改密码

mysqld --install MySQL
#......
net start MySQL
#......
mysql -u root -p
wdu*Ye<vW25)
#......
set password for root@localhost = password(‘123’);

忘记密码

net stop MySQL
#修改 my.ini 文件，加一条:	skip-grant-tables
net start MySQL
mysql -u root -p
#不需要输入密码，直接输入回车，进入 MySQL 的控制台
UPDATE user SET authentication_string=password(‘123456’) WHERE user=‘root’;
#修改 my.ini 文件	#skip-grant-tables
#重新启动 MySQL 服务
net stop MySQL
net start MySQL

mysql -u root -p
输入123456登录到 MySQL

开启远程访问

#登录MySQL
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
#刷新权限
FLUSH PRIVILEGES;
#重启服务

关闭远程访问

update user set host = "%" where user = "root";
flush privileges;

新建用户及授权

CREATE USER  'remote_user'@'%'  IDENTIFIED BY  'remote@hzcio';
--SELECT,INSERT,UPDATE,DELETE | ALL PRIVILEGES
GRANT SELECT,INSERT,UPDATE,DELETE ON hzcio.* TO 'remote_user'@'%';