MariaDB Addon DBeaver Connection

worjef · July 17, 2020 at 8:35 PM

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.

**chewitt** · July 18, 2020 at 7:26 AM Official Post

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

**Klojum** · July 18, 2020 at 1:16 PM Official Post

Quote from worjef

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