mysql 配置

简介

针对 5.7.19 , windows

卸载mysql

https://blog.csdn.net/qq_41140741/article/details/81489531

my.ini

[mysqld]
basedir=F:windowsinstallmysql-5.7.19
datadir=F:windowsinstallmysql-5.7.19data
port=3306
skip-grant-tables

更改密码的命令

update mysql.user set authentication_string=password('123456') where user='root' and Host='localhost';

刷新权限

flush privileges;

windows

启停服务
net start mysql
net stop mysql

进入mysql

mysql -u root -p
不要在p后面加上空格