Linux下重置MySQL密码_MySQL
Jun 01, 2016 pm 01:35 PMbitsCN.com
Linux下重置MySQL密码
据有关资料显示,人能记住的密码一般不多,很多时候人都是多账户同密码的办法来设置密码的。但一般来说,经常需要接触的账户密码是不会忘记的。但偏偏也有可能有忘记的时候,下面就介绍下在Linux环境下忘记MySQL密码的解决方法。其实很简单,只需要六个步骤就可以解决问的。不多说闲话,进入话题:
1、关闭MySQL服务:
service mysqld stop
2、执行下面命令,跳出安全模式,当然,这条命令大概只在localhost的时候有效。
/usr/local/mysql/bin/mysqld_safe –skip-grant
3、进入 MySQL
/usr/local/mysql/bin/mysql -u root -p 进入mysql
4、更改密码,执行下面语句:
use mysql;
UPDATE user SET Password=password(“XXX”) WHERE User=”root”; 其中,XXX是你要设置的密码
flush privileges;
exit;
5、去掉配置文件中的 skip-grant,修改配置文件,linux下配置文件为my.cnf ,windows下配置文件为my.ini,在[mysqld]下添加
skip-grant
6、启动 MySQL 服务:
service mysqld start
bitsCN.com
Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

deepseek web version entrance deepseek official website entrance

Android TV Box gets unofficial Ubuntu 24.04 upgrade

BitPie Bitpie wallet app download address

BITGet official website installation (2025 beginner's guide)

Zabbix 3.4 Source code compilation installation

Detailed explanation: Shell script variable judgment parameter command

Ouyi okx installation package is directly included
