linux Debian和CentOS忘记MySql8.0修改root密码;报错:1130-host ... is not allowed to connect mysql远程连接错误
linux 忘记MySql8.0修改root密码跳过权限登录:vim /etc/my.cnf[mysqld]skip-grant-tables ##my.cnf文件[mysqld]追加此行,跳过权限表无密码登录重启mysqlsystemctl restart mysqld知识来源于这位博主修改MySQL密码:mysql> use mysql; #选择用户表mysql> update user set authentication_string='' wh