Trying to connect to MySQL via DBeaver with Server Host: ‘localhost’ in settings but getting error:
Access denied for user 'user'@'127.0.0.1' (using password: YES)
localhost somehow changed to 127.0.0.1
Same error if trying to connect via ssh:
user@sl:~$ mysql -h 127.0.0.1 support -p
Enter password:
ERROR 1045 (28000): Access denied for user 'user'@'127.0.0.1' (using password: YES)
But it is ok, if using localhost:
user@sl:~$ mysql -h localhost support -p
Enter password:
Welcome to the MariaDB monitor.
So the question is how to force DBeaver (or driver) use not ‘127.0.0.1’ but ‘localhost’.