1.eclipse even MySQL database error: Nknown initial character Set index ' 255 ' received from server. Initial client Character set can is forced via the ' characterencoding ' property.
Workaround: String url = "Jdbc:mysql://localhost:3306/jdbcstudy? Useunicode=true&characterencoding=utf8";
2. Access error com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Client does not support authentication protocol requested by Server; Consider upgrading MySQL client
Workaround:
EXECUTE Statement Modification
Mysql> ALTER USER ' root ' @ ' localhost ' identified with Mysql_native_password by ' 66666 ';
Query OK, 0 rows affected (0.11 sec)
mysql> FLUSH privileges;
Query OK, 0 rows affected (0.01 sec)
Note:root is the user name,localhost is specifically native,Mysql_native_password is the old password authentication mechanism,66666 is the password
Eclipse Connection MySQL