$\u00a0 wget http:\/\/repo.mysql.com\/mysql57-community-release-el7-7.noarch.rpm<\/p>\n
$ rpm -ivh mysql57-community-release-el7-7.noarch.rpm<\/p>\n
[root@cluster1 ~]# rpm -ivh mysql57-community-release-el7-7.noarch.rpm
\nwarning: mysql57-community-release-el7-7.noarch.rpm: Header V3 DSA\/SHA1 Signature, key ID 5072e1f5: NOKEY
\nPreparing…\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ########################################### [100%]
\n1:mysql57-community-relea########################################### [100%]<\/p>\n
$\u00a0 yum install mysql-server<\/p>\n
So far, mysql57 has been successfully installed. Now try to log on to use the root mysql, an error ERROR 1045 (28000): Access denied for user ‘root’ @ ‘localhost’<\/p>\n
This problem occurs because the occurrence is estimated rpm mode after installing mysql default password used to initialize the root user.<\/p>\n
After the degree of your mother get Google solution for 5.7.x version is invalid. The official website to find some ideas https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/server-management-using-systemd.html<\/p>\n
mysql5.7.x version has some new changes, roughly<\/p>\n
1.mysqld_safe has been abandoned, rpm installation package is not installed by default mysqld_safe<\/p>\n
2.user table password column has been changed to authentication_string<\/p>\n
After many tests and finally solve the root login issues. Resolve as follows<\/p>\n
$\u00a0 systemctl stop mysqld.service<\/p>\n
$\u00a0 systemctl set-environment MYSQLD_OPTS=”–user=mysql –skip-grant-tables –skip-networking”<\/p>\n
$\u00a0 systemctl start mysqld.service<\/p>\n
$ mysql -u root mysql<\/p>\n
mysql > UPDATE mysql.user SET authentication_string=PASSWORD(“mohan123”)\u00a0 WHERE user=’root’ and host=’localhost’;<\/p>\n
mysql > flush privileges;<\/p>\n
mysql > quit<\/p>\n
$\u00a0 systemctl unset-environment MYSQLD_OPTS<\/p>\n
$\u00a0 systemctl restart mysqld.service<\/p>\n","protected":false},"excerpt":{"rendered":"
$ wget http:\/\/repo.mysql.com\/mysql57-community-release-el7-7.noarch.rpm<\/p>\n
$ rpm -ivh mysql57-community-release-el7-7.noarch.rpm<\/p>\n
[root@cluster1 ~]# rpm -ivh mysql57-community-release-el7-7.noarch.rpm warning: mysql57-community-release-el7-7.noarch.rpm: Header V3 DSA\/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing… ########################################### [100%] 1:mysql57-community-relea########################################### [100%]<\/p>\n
$ yum install mysql-server<\/p>\n
So far, mysql57 has been successfully installed. Now try to log on to use the root mysql, an error ERROR 1045 (28000): Access denied […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,1],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5607"}],"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=5607"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5607\/revisions"}],"predecessor-version":[{"id":5609,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5607\/revisions\/5609"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}