1 ) Stop MySql Server Service
[root@naitinoi ~]# /etc/init.d/mysqld stop
Stopping mysqld: [ OK ]

2) Start MySQL server w/o password:
[root@naitinoi ~]# mysqld_safe –skip-grant-tables &
[1] 6462
[root@naitinoi ~]# 151105 08:47:32 mysqld_safe Logging to ‘/var/log/mysqld.log’.
151105 08:47:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

3) Login as root
[root@naitinoi ~]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.x.xx MySQL Community Server (GPL) by Remi

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set password=PASSWORD(“new password here”) where User=’root’;
Query OK, 3 rows affected (0.01 sec)
Rows matched: 3 Changed: 3 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> quit
Bye

4) Stop MySQL server w/o password:
[root@naitinoi ~]# /etc/init.d/mysqld stop
151105 08:49:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Stopping mysqld: [ OK ]
[1]+ Done mysqld_safe –skip-grant-tables

5) Start MySql Server Service
[root@naitinoi ~]# /etc/init.d/mysqld start
Starting mysqld: [ OK ]

6) Login
[root@naitinoi ~]# mysql -u root -p
Enter password:

Comments are closed.