Mysql error access denied for user ' root ' using PA

Centos7 configuring MARIADB (MySQL), client logon

1045 Access denied for user ' root ' @ ' localhost ' using password Yes

mariadb [mysql]> select host,user,password from user;+-----------+------+--------- ----------------------------------+| host      | user |  password                                   |+------ -----+------+-------------------------------------------+| localhost | root | * 27732d6fb9c956e7d13ce8a983210aa5b1ff6c3c | |  127.0.0.1 | root | *27732d6fb9c956e7d13ce8a983210aa5b1ff6c3c | |  ::1       | root | * 27732d6fb9c956e7d13ce8a983210aa5b1ff6c3c | |  %         | root | * 81f5e21e35407d884a6cd4a731aebfb6af209e1b |+-----------+------+-------------------------------------------+4 rows in set  (0.00 SEC) 

Reset Password

%         | Root | *81f5e21e35407d884a6cd4a731aebfb6af209e1b

SET PASSWORD for ' root ' @ '% ' = PASSWORD (' xxxxx ');

Ok...

Can ' t connect to MySQL server on ' 192.168.1.101 ' (61)

A (61) error occurred while connecting to MySQL, the official explanation is:

OS error code 61:no data available

After the row plug think may be a firewall problem, because CENTOS7 firewall default is firewall not iptables, tune for a long time to open 3306 port authorization failed. Eventually rage shuts down the firewall, and this problem has to be resolved.

Mysql error access denied for user ' root ' using PA