Attempting to establish a connection with the database for testing purposes led to an error:
java.sql.SQLException: Client does not support authentication protocol requested by server; consider upgrading MySQL client at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
Is there a more effective method for upgrading the Mysql client?
Below is the code being used:
package DatabaseTesting;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import org.testng.annotations.Test;
public class TestDB
{
@Test
public void ConnectToSql() throws ClassNotFoundException, SQLException
{
String dburl = "jdbc:mysql://localhost:3306/selenium";
String user = "root";
String pass = "Admin@123";
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Driver Loaded");
DriverManager.getConnection(dburl,user,pass);
System.out.println("Connected to Database");
}
}
I have searched extensively for a solution but have been unable to find one. Any assistance in resolving this issue would be greatly appreciated.