mysql重置密码

a min to read post
  1. 停止mysql，/usr/local/webserver/mysql5.7/bin/mysqladmin -uouyang -p -S /mysql/mysql.sock shutdown
  2. 启动 /usr/local/webserver/mysql5.7/bin/mysqld_safe –defaults-file=/mysql/my.cnf –user=mysql –skip-grant-tables
  3. 连接 mysql -u root -S /mysql/mysql.sock
  4. 修改密码，update mysql.user set authentication_string=password(‘xxxxxx’) where user=‘root’ and Host =’%’;
  5. flush privileges;
Published At