Home Database Mysql Tutorial Linux下重置MySQL密码_MySQL

Linux下重置MySQL密码_MySQL

Jun 01, 2016 pm 01:35 PM
linux password material

bitsCN.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
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

deepseek web version entrance deepseek official website entrance deepseek web version entrance deepseek official website entrance Feb 19, 2025 pm 04:54 PM

deepseek web version entrance deepseek official website entrance

Android TV Box gets unofficial Ubuntu 24.04 upgrade Android TV Box gets unofficial Ubuntu 24.04 upgrade Sep 05, 2024 am 06:33 AM

Android TV Box gets unofficial Ubuntu 24.04 upgrade

How to install deepseek How to install deepseek Feb 19, 2025 pm 05:48 PM

How to install deepseek

BitPie Bitpie wallet app download address BitPie Bitpie wallet app download address Sep 10, 2024 pm 12:10 PM

BitPie Bitpie wallet app download address

BITGet official website installation (2025 beginner's guide) BITGet official website installation (2025 beginner's guide) Feb 21, 2025 pm 08:42 PM

BITGet official website installation (2025 beginner's guide)

Zabbix 3.4 Source code compilation installation Zabbix 3.4 Source code compilation installation Sep 04, 2024 am 07:32 AM

Zabbix 3.4 Source code compilation installation

Detailed explanation: Shell script variable judgment parameter command Detailed explanation: Shell script variable judgment parameter command Sep 02, 2024 pm 03:25 PM

Detailed explanation: Shell script variable judgment parameter command

Ouyi okx installation package is directly included Ouyi okx installation package is directly included Feb 21, 2025 pm 08:00 PM

Ouyi okx installation package is directly included

See all articles