← 返回文章列表
POST / 2024-11-21

mysql重置密码

1. 停止mysql，/usr/local/webserver/mysql5.7/bin/mysqladmin -uouyang -p -S /mysql/mysql.sock shutdown 2. 启动 /usr/local/webserver/mysql5.7/bin/my

by left2east ·
#技术相关#常用工具#mysql
  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(‘password’) where user=‘root’ and Host =’%’;
  5. flush privileges;