title: MariaDB - Cannot connect to MariaDB instance from Dbeaver using correct password
body: <p>I am trying to connect to a localhost instance of MariaDb on port 3306.
  I'm well aware that root cannot use localhost because of MariaDb specifications so I created
  another user from the command line with password 'root' and all privileges granted to my 'test' database:</p>
  
  <pre><code>CREATE USER 'myuser' IDENTIFIED BY 'root';
  GRANT USAGE ON *.* TO 'myuser'@localhost IDENTIFIED BY 'root';
  GRANT ALL privileges ON `test`.* TO 'myuser'@localhost;
  FLUSH PRIVILEGES;
  </code></pre>
  
  <p>When I try to open a connection from DBeaver with the correct password and username, an error appears:</p>
  
  <blockquote>
    <p>Access denied for user 'myuser'@'localhost' (using password: YES)
    Current charset is windows-1251. If password has been set using other
    charset, consider using option 'passwordCharacterEncoding'</p>
  </blockquote>
  
  <p>Why does it happen? Is it because of some password hashing algorithms mismatch between DBeaver and MariaDB's instance? How do I fix this and connect successfuly?</p>