MySql安装

1.MySql版本:mysql-8.0.19-winx64

2. 需要在mysql-8.0.19-winx64 目录下添加my.ini文件,内容为:

[mysql]
default-character-set=utf8

[mysqld]
port=3306
basedir="E:Pythonaaamysql-8.0.19-winx64"
datadir="E:Pythonaaamysql-8.0.19-winx64data"
character-set-server=utf8
default-storage-engine=INNODB
max_connections=200

3.注意内容:

data目录不要手动创建,需要执行命令时自动创建;

4. 修改root账号密码

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

参考内容:

a) https://blog.csdn.net/shinny195/article/details/82319218 

b) https://blog.csdn.net/qq939782569/article/details/87344602 

原文地址:https://www.cnblogs.com/jiguanghover/p/12323191.html