CODEWITHSUNDEEP
mysqlnode.jsdbeaver
soccerway
soccerway

Reputation: 12011

Unable to perform New Database connection to `Dbeaver`, throws `Unable to load authentication plugin

Unable to perform New Database connection to Dbeaver, throws Unable to load authentication plugin 'caching_sha2_password' Initially I have set a root user called admin and its password while setting the MySQl server which is different from below user soccertest
I have created soccertest user by running below query : 

CREATE USER 'soccertest'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'somepassword';

Query OK, 0 rows affected (0.02 sec)

I could see database available while running mysql > show databases from the command prompt 

Server Host: localhost:
Port: 3306
Database: soccerreact
Username : soccertest
Password:  somepassword
Local Client: MySQL Server 8.0

enter image description here enter image description here

Upvotes: 0

Views: 3565

Answers (1)

Ganesh Chandrasekaran
Ganesh Chandrasekaran

Reputation: 1936

Try creating with mysql_native_password option.. 

ALTER USER 'soccertest'@'localhost' IDENTIFIED WITH mysql_native_password BY 'somepassword'; 

Grant all privileges on soccerreact.* to soccertest@localhost;

Upvotes: 1

Related Questions