If the user who logs on to linux is the root user, if mysql-hIP is directly input, the error "ERROR1045 (28000): Accessdeniedforuser" is returned. & #39; root & #39; @ & #39; localhost & #39; (usingpassword: NO ). Then we will talk about permission issues. Then execute the authorization operation grantallprivilegeson *. * to & #39; root & #39; @ & #39; % & #39; identifiedby & #39; mysql & #39; g mysqllinux
The linux login user is root.
If data is directly input into mysql-hIP, an error is returned:
ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO ).
Then we will talk about permission issues.
Then perform the authorization operation.
Grant all privileges on.To 'root' @ '%' identified by 'mysql ';
Grant all privileges on.To 'root' @ 'localhost' identified by 'mysql ';
Flush privileges;
The connection is still unavailable. Please kindly advise.