Why is it impossible to connect programs to the database after setting the skip-name-resolve parameter in Mysql?

Question

linux

Hello.
I decided to optimize the database, through the mysqltuner.com program . Where one of the recommendations was to include the parameter: skip-name-resolve=1 .
I set it up, everything is fine, but the problem is that I can't connect using programs ( navicate, DBeaver ). Writes: Access denied for user: '[email protected]' (Using password: YES)
At the same time, if you disable this option, then everything is fine.
Any ideas what can be done? Also, to disable this option..

Answer 1

Because you have skip-name-resolve, then all hostnames are not resolved.
localhost is the name of the host. MySQL cannot resolve it to check the permissions of the [email protected] user.
For all users, you should replace hostnames with ip-addresses, for example:
[email protected] Do
not use hostnames in the database or during authorization.