mysql> use mysql
\nERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql'
\nmysql> exit
\nBye
\n[root@testtest ~]# service mysqld stop
\nStopping mysqld: [ OK ]
\n[root@testtest ~]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking & <\/p>\n
[root@testtest ~]# mysql -u root -p -hlocalhost
\nEnter password: <\/p>\n
mysql> use mysql<\/p>\n
mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;<\/p>\n
mysql> UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';<\/p>\n
mysql> FLUSH PRIVILEGES;<\/p>\n
mysql> GRANT ALL PRIVILEGES ON .<\/em> TO 'root'@'localhost' identified by '' WITH GRANT OPTION;<\/p>\n mysql> GRANT ALL PRIVILEGES ON .<\/em> TO 'root'@'cn.cn.cn.cn'identified by '';<\/p>\n mysql> GRANT ALL PRIVILEGES ON .<\/em> TO 'root'@'245.245.245.245'identified by '';<\/p>\n mysql> GRANT ALL PRIVILEGES ON .<\/em> TO 'root'@'127.0.0.1' identified by '';<\/p>\n mysql> FLUSH PRIVILEGES;<\/p>\n mysql> quit mysql> use mysql ERROR 1044 (42000): Access denied for user ‘root’@’localhost’ to database ‘mysql’ mysql> exit Bye [root@testtest ~]# service mysqld stop Stopping mysqld: [ OK ] [root@testtest ~]# mysqld_safe –user=mysql –skip-grant-tables –skip-networking & [root@testtest ~]# mysql -u root -p -hlocalhost Enter password: mysql> use mysql mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user; mysql> UPDATE mysql.user SET Grant_priv=’Y’, Super_priv=’Y’ WHERE User=’root’; mysql> FLUSH PRIVILEGES; mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’localhost’ identified by ” WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’cn.cn.cn.cn’identified by ”; mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’245.245.245.245’identified by ”; mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’127.0.0.1’ identified by ”; mysql> FLUSH PRIVILEGES; mysql> quit Bye [root@testtest ~]# service mysqld start<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[83],"tags":[],"class_list":["post-1401","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1401"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1401\/revisions"}],"predecessor-version":[{"id":1402,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1401\/revisions\/1402"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nBye
\n[root@testtest ~]# service mysqld start <\/p>\n","protected":false},"excerpt":{"rendered":"