MySQL 8.0 安装

1.MySQL安装

1. 创建my.ini配置文件

[mysql]
default-character-set=utf8
[mysqld]
port=3306
basedir=E:\MySQL
datadir=E:\MySQL\data
character_set_server=utf8
default-time_zone=+8:00
default-storage-engine=InnoDB
default_authentication_plugin=mysql_native_password

2. 初始化数据库

mysqld --initialize

3. 在%datadir%下找到 *.err,查看初始密码

[Note] [MY-010454] [Server] A temporary password is generated for root@localhost: LuKpVJ=h;6P%

5. 授权

1. 登录MySQL
	mysql -u root -p
2. 选择mysql数据库
	use mysql;
3. 授权 root 用户的所有权限并设置远程访问
	GRANT ALL ON *.* TO 'root'@'%';
4. 刷新权限
	flush privileges;

6.重置密码

alter user user() identified by "新密码";

7. 安装服务

mysqld --install %service_name%