简介

针对 5.7.19 , windows

卸载mysql

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

my.ini

[mysqld]
basedir=F:\windowsinstall\mysql-5.7.19\
datadir=F:\windowsinstall\mysql-5.7.19\data\
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后面加上空格

posted on 2021-04-11 11:34  HDU李少帅  阅读(41)  评论(0编辑  收藏  举报