MySQL8.0.23安装
1)下载:https://dev.mysql.com/downloads/mysql/
2)下载后解压,创建my.ini文件(无则创建)
3)在my.ini文件中添加内容
[mysqld] port=3306 basedir=D:\Program Files\MySQL datadir=D:\Program Files\MySQL\Data max_connections=200 max_connect_errors=10 character-set-server=utf8mb4 default-storage-engine=INNODB #mysql_native_password default_authentication_plugin=mysql_native_password [mysql] default-character-set=utf8mb4 [client] port=3306 default-character-set=utf8mb4
确认:D:\Program Files\MySQL,D:\Program Files\MySQL\Data目录是否存在,不存在则手动创建
4)打开cmd命令窗口,进入到D:\Program Files\MySQL\bin目录下,执行 mysqld --initialize --console
记住临时密码
A temporary password is generated for root@localhost: o0M=9hCmMl)f
5)安装mysql服务
mysqld --install mysql
6)启动服务
net start mysql
7)登录 mysql
mysql -u root -p
输入刚才的临时密码
更改root密码:ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
此时就可以使用Navicat来连接本地数据库了