: The MySQL server is running with the --skip-grant-tables option)
该报错同样适用于MariaDB一、报错信息ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement二、报错场景修改mysql密码出现的报错。三、解决方式先使用flush privileges;刷新命令再修改数据库密码set password for rootlocalhostpassword(你的密码); 【数据库】mysql-修改密码-error-1290 (HY000): The MySQL server is running with the --skip-grant-tables option
该报错同样适用于MariaDB一、报错信息ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement二、报错场景修改mysql密码出现的报错。三、解决方式先使用flush privileges;刷新命令再修改数据库密码set password for rootlocalhostpassword(你的密码);