mysql 重置root密码

    技术2022-07-15  72

    vi /etc/my.cnf [mysqld] #添加跳过验证 skip-grant-tables

    2.执行:systemctl restart mysqld.service 3.执行:mysql mysql>use mysql; mysql>update user set authentication_string=PASSWORD(‘123456’) where User=‘root’; mysql>flush privileges;

    4.systemctl restart mysqld.service 5.mysql -uroot -p123456正常登陆

    Processed: 0.012, SQL: 9