1 ) Stop MySql Server Service
\n[root@naitinoi ~]# \/etc\/init.d\/mysqld stop
\nStopping mysqld: [ OK ]<\/p>\n
2) Start MySQL server w\/o password:
\n[root@naitinoi ~]# mysqld_safe \u2013skip-grant-tables &
\n[1] 6462
\n[root@naitinoi ~]# 151105 08:47:32 mysqld_safe Logging to \u2018\/var\/log\/mysqld.log\u2019.
\n151105 08:47:32 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql<\/p>\n
3) Login as root
\n[root@naitinoi ~]# mysql -u root
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 1
\nServer version: 5.x.xx MySQL Community Server (GPL) by Remi<\/p>\n
Copyright (c) 2000, 2015, Oracle and\/or its affiliates. All rights reserved.<\/p>\n
Oracle is a registered trademark of Oracle Corporation and\/or its
\naffiliates. Other names may be trademarks of their respective
\nowners.<\/p>\n
Type \u2018help;\u2019 or \u2018\\h\u2019 for help. Type \u2018\\c\u2019 to clear the current input statement.<\/p>\n
mysql> use mysql;
\nReading table information for completion of table and column names
\nYou can turn off this feature to get a quicker startup with -A<\/p>\n
Database changed
\nmysql> update user set password=PASSWORD(\u201cnew password here\u201d) where User=\u2019root’;
\nQuery OK, 3 rows affected (0.01 sec)
\nRows matched: 3 Changed: 3 Warnings: 0<\/p>\n
mysql> flush privileges;
\nQuery OK, 0 rows affected (0.01 sec)<\/p>\n
mysql> quit
\nBye<\/p>\n
4) Stop MySQL server w\/o password:
\n[root@naitinoi ~]# \/etc\/init.d\/mysqld stop
\n151105 08:49:26 mysqld_safe mysqld from pid file \/var\/run\/mysqld\/mysqld.pid ended
\nStopping mysqld: [ OK ]
\n[1]+ Done mysqld_safe \u2013skip-grant-tables<\/p>\n
5) Start MySql Server Service
\n[root@naitinoi ~]# \/etc\/init.d\/mysqld start
\nStarting mysqld: [ OK ]<\/p>\n
6) Login
\n[root@naitinoi ~]# mysql -u root -p
\nEnter password:<\/p>\n","protected":false},"excerpt":{"rendered":"
1 ) Stop MySql Server Service [root@naitinoi ~]# \/etc\/i […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-69","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/posts\/69","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/comments?post=69"}],"version-history":[{"count":1,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/posts\/69\/revisions"}],"predecessor-version":[{"id":70,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/posts\/69\/revisions\/70"}],"wp:attachment":[{"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/media?parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/categories?post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/tags?post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}