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.

    • Official Post

    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'.