January 2019
M T W T F S S
« Dec    
 123456
78910111213
14151617181920
21222324252627
28293031  

Categories

WordPress Quotes

Cherish your visions and your dreams as they are the children of your soul, the blueprints of your ultimate achievements.
Napoleon Hill

Recent Comments

January 2019
M T W T F S S
« Dec    
 123456
78910111213
14151617181920
21222324252627
28293031  

Short Cuts

2012 SERVER (64)
2016 windows (9)
AIX (13)
Amazon (34)
Ansibile (19)
Apache (133)
Asterisk (2)
cassandra (2)
Centos (209)
Centos RHEL 7 (261)
chef (3)
cloud (2)
cluster (3)
Coherence (1)
DB2 (5)
DISK (25)
DNS (9)
Docker (28)
Eassy (11)
ELKS (1)
EXCHANGE (3)
Fedora (6)
ftp (5)
GIT (3)
GOD (2)
Grub (1)
Hacking (10)
Hadoop (6)
horoscope (23)
Hyper-V (10)
IIS (15)
IPTABLES (15)
JAVA (7)
JBOSS (32)
jenkins (1)
Kubernetes (2)
Ldap (5)
Linux (189)
Linux Commands (167)
Load balancer (5)
mariadb (14)
Mongodb (4)
MQ Server (24)
MYSQL (84)
Nagios (5)
NaturalOil (13)
Nginx (31)
Ngix (1)
openldap (1)
Openstack (6)
Oracle (34)
Perl (3)
Postfix (19)
Postgresql (1)
PowerShell (2)
Python (3)
qmail (36)
Redis (12)
RHCE (28)
SCALEIO (1)
Security on Centos (29)
SFTP (1)
Shell (64)
Solaris (58)
Sql Server 2012 (4)
squid (3)
SSH (10)
SSL (14)
Storage (1)
swap (3)
TIPS on Linux (28)
tomcat (60)
Uncategorized (29)
Veritas (2)
vfabric (1)
VMware (28)
Weblogic (38)
Websphere (71)
Windows (19)
Windows Software (2)
wordpress (1)
ZIMBRA (17)

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

Who's Online

19 visitors online now
7 guests, 12 bots, 0 members

Hit Counter provided by dental implants orange county

CentOS 7 used rpm install MySQL 5.7

$  wget http://repo.mysql.com/mysql57-community-release-el7-7.noarch.rpm

$ rpm -ivh mysql57-community-release-el7-7.noarch.rpm

[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%]

$  yum install mysql-server

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’

This problem occurs because the occurrence is estimated rpm mode after installing mysql default password used to initialize the root user.

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

mysql5.7.x version has some new changes, roughly

1.mysqld_safe has been abandoned, rpm installation package is not installed by default mysqld_safe

2.user table password column has been changed to authentication_string

After many tests and finally solve the root login issues. Resolve as follows

$  systemctl stop mysqld.service

$  systemctl set-environment MYSQLD_OPTS=”–user=mysql –skip-grant-tables –skip-networking”

$  systemctl start mysqld.service

$ mysql -u root mysql

mysql > UPDATE mysql.user SET authentication_string=PASSWORD(“mohan123”)  WHERE user=’root’ and host=’localhost’;

mysql > flush privileges;

mysql > quit

$  systemctl unset-environment MYSQLD_OPTS

$  systemctl restart mysqld.service

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

  

  

  

Blue Captcha Image
Refresh

*

Protected by WP Anti Spam