Answers for "java.sql.sqlexception: could not connect: client does not support authentication protocol requested by server; consider upgrading mysql client"

SQL

'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',

$ mysql -u root -p
Enter password: (enter your root password)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
mysql> FLUSH PRIVILEGES;
mysql> quit

Posted by: Guest on May-26-2020

Source

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client

the version of mysql in pom.xml should be same as the version of mysql installed (mine is 8.0.14)
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.14</version>

Posted by: Guest on June-12-2021

Source

Code answers related to "java.sql.sqlexception: could not connect: client does not support authentication protocol requested by server; consider upgrading mysql client"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "java.sql.sqlexception: could not connect: client does not support authentication protocol requested by server; consider upgrading mysql client"

Code answers related to "java.sql.sqlexception: could not connect: client does not support authentication protocol requested by server; consider upgrading mysql client"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us