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