- 新建my.ini
[mysqld]
port=3306
basedir=D:\Mylargeprogram\Mysql\mysql-8.0.12-winx64
datadir=D:\Mylargeprogram\Mysql\mysql-8.0.12-winx64\data
max_connections=200
max_connect_errors=10
character-set-server=utf8
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
[mysql]
default-character-set=utf8
[client]
port=3306
default-character-set=utf8
- 打开cmd命令行,进入mysql-5.7.20-winx64/bin
执行mysqld --initialize-insecure - mysqld --install
- net start mysql
- 如有意外可以删除mysql,使用msqld --remove命令
- 使用cmd到bin目录下执行mysql -uroot,无需密码即可进入
- 修改密码
use mysql;
update user set authentication_string="123456";
exit;
net stop mysql;
net start mysql;
mysql -u root -p
然后输入密码即可进入