Home IT Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MySQL root password reset under CentOS     - Linux systems use logwatch log file monitoring (Linux)

- Web cache basics: terminology, HTTP headers, and caching policies (Server)

- Oracle 11g new features and associated SQL TUNING (Database)

- About Samba certification process and permissions (Linux)

- Android SDK Manager can not update the domestic solutions (Linux)

- iOS development -Launch Image and Launchscreen (Programming)

- How to install and use the malware detection tool LMD and ClamAV antivirus engine on Linux (Linux)

- RHEL5.8 physical opportunities to Read-only file system (Linux)

- Java Foundation - Variables and data types (Programming)

- CentOS and RHEL to install IPython 0.11 (Linux)

- About Linux operating system security (Linux)

- OpenStack / Dev stack with neutron on Ubuntu 14.04 (Server)

- Ubuntu 12.04 installation DHCP Server (Server)

- Hackers is how the invasion and control of Things devices? (Linux)

- Let CentOS perform PPPoE dial-up, ADSL can be used in a network environment! (Linux)

- VMware Workstation + Ubuntu 10.04 Download the Android 2.2 source code (Linux)

- Linux, see picture not resolve the problem (Linux)

- Ubuntu terminal command - see the port occupied and off (Linux)

- 30 Practical Linux system administrators will learn the command (Linux)

- Git bulk delete remote tag (Linux)

  MySQL root password reset under CentOS
  Add Date : 2018-11-21      
  There are many under CentOS MySQL password reset method, the official website also provides a very convenient and efficient way to operate, may reference resetting permissions. In this paper, reset your password by following these steps:

First, stop MySQL (if running)

#service mysqld stop


Shutting down MySQL. [OK]

About #service mysqld stop command, refer to the CentOS 6.5 platform offline compile and install MySQL 5.6.22.

Second, start MySQL_safe, log on without a password so since MySQL can

# Mysqld_safe --skip-grant-tables &

Similar output

Starting mysqld daemon with databases from / var / lib / mysql
mysqld_safe [6025]: started

Third, login MYSQL

# Mysql -u root


Welcome to the MySQL monitor Commands end with;. Or \ g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
Type 'help;' or '\ h' for help Type '\ c' to clear the buffer..

Fourth, set a new password

mysql> use mysql;
mysql> update user set password = PASSWORD ( "NEW-ROOT-PASSWORD") where User = 'root';
mysql> flush privileges;
mysql> quit

Fifth, stop MySQL

# /etc/init.d/mysql Stop


Stopping MySQL database server: mysqld
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe [6186]: ended
[1] + Done mysqld_safe --skip-grant-tables

Sixth, start MySQL and test new password is correct

# /etc/init.d/mysql Start
# Mysql -u root -p
- Why do I prefer Git (Linux)
- Findbugs installation documentation (Linux)
- How to configure SNMPv3 on Ubuntu, CentOS and Cisco systems (Linux)
- Nginx server security configuration (Server)
- Linux uses the SMTP proxy to send mail (Linux)
- Hanoi problem Java Solution (Programming)
- Linux process scheduling opportunity (Programming)
- HTTP and FTP TCP-FLOOD CC Attacks Analysis and Prevention solutions under CentOS 6.5 (Linux)
- RHEL6.5 install the latest version of Vim and increase support for the Python2.7.5 (Linux)
- Linux file time Comments ctime mtime atime (Linux)
- Use custom backup plans for Debian backupninja (Linux)
- Spark source code compiler package (Linux)
- Linux distributed message queue RocketMQ deployment and monitoring - Dual Master (Server)
- Talk about Java in the collection (Programming)
- Difference LVS three scheduling modes (Server)
- Examples of safety testing system notes for RedHat Linux (Linux)
- CentOS 6.4 installation and configuration LNMP build PHP server runtime environment (Server)
- jobs command example (Linux)
- Install Oracle database error process of [INS-35172] (Database)
- ASM required disk format process in Solaris platforms (Linux)
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.