MariaDB Addon DBeaver Connection

  • So far I'm loving the MariaDB addon and everything is working great. Has anybody been able to connect from another workstation using DBeaver? When I try to connect I receive the following error.


    Access denied for user 'root'@'192.168.100.10' (using password: YES)

    Current charset is windows-1252. If password has been set using other charset, consider using option 'passwordCharacterEncoding'


    I'm able to SSH to the server and login to MariaDB without any issues using that method.


    UPDATE: I was able to successfully login using the kodi account however root still does not work.

  • Check whether the root allows access from anything other than localhost?

  • UPDATE: I was able to successfully login using the kodi account however root still does not work.

    'root' has no outside access by default in a MySQL/MariaDB for obvious reasons.

    You can try to alter the Host value into "%" in the 'users' table for the user 'root' , just like with the user 'kodi'.