[root ~]# mysql -u root
\nERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password:NO)
\nStop the service\/daemon of mysql running
\n[root ~]# service mysql stop
\nmysql stop\/waiting
\nStart mysql without any privileges using the following option; This option is used to boot up and do not use the privilege system of MySQL.
\n[root ~]# mysqld_safe –skip-grant-tables &
\nenter the mysql command prompt
\n[root ~]# mysql -u root
\nmysql>
\nFix the permission setting of the root user ;
\nmysql> use mysql;
\nDatabase changed
\nmysql> select * from user;
\nEmpty set (0.00 sec)
\nmysql> truncate table user;
\nQuery OK, 0 rows affected (0.00 sec)
\nmysql> flush privileges;
\nQuery OK, 0 rows affected (0.01 sec)
\nmysql> grant all privileges on *.* to root@localhost identified by ‘YourNewPassword’ with grant option;
\nQuery OK, 0 rows affected (0.01 sec)
\n*if you don`t want any password or rather an empty password<\/p>\n
mysql> grant all privileges on *.* to root@localhost identified by ” with grant option;
\nQuery OK, 0 rows affected (0.01 sec)*
\nmysql> flush privileges;
\nQuery OK, 0 rows affected (0.00 sec)
\nConfirm the results:<\/p>\n
mysql> select host, user from user;
\n+———–+——+
\n| host | user |
\n+———–+——+
\n| localhost | root |
\n+———–+——+
\n1 row in set (0.00 sec)
\nExit the shell and restart mysql in normal mode.
\nmysql> quit;
\n[root ~]# kill -KILL [PID of mysqld_safe]
\n[root ~]# kill -KILL [PID of mysqld]
\n[root ~]# service mysql start
\nNow you can successfully login as root user with the password you set
\n[root ~]# mysql -u root -pYourNewPassword
\nmysql><\/p>\n","protected":false},"excerpt":{"rendered":"
[root ~]# mysql -u root ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password:NO) Stop the service\/daemon of mysql running [root ~]# service mysql stop mysql stop\/waiting Start mysql without any privileges using the following option; This option is used to boot up and do not use the privilege system of MySQL. [root ~]# […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6405"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6405"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6405\/revisions"}],"predecessor-version":[{"id":6406,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6405\/revisions\/6406"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}