Skip to main content

Posts

Showing posts from June, 2021

Zip based MySQL setup on Win10

Grab the zip file from https://dev.mysql.com/downloads/mysql/ and unzip Add the mysql bin folder into your PATH mysqld --initialize-insecure --console see https://dev.mysql.com/doc/refman/8.0/en/option-files.html if you need override the default config. mysqld --install (Run as Admin) net start MySQL mysql -u root to login without password mysql>set password='rootpassword'; mysql>create user 'dev'@'localhost' identified by 'somepassword'; mysql>grant all privileges on *.* to 'dev'@'localhost'; mysql>FLUSH PRIVILEGES;

javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate).

The recent IntelliJ IDEA 2021.1.2 (Ultimate Edition Build #IU-211.7442.40, built on June 1, 2021) has disabled TLS 1.0 for security reason, so you will not be able to connect to the remote database. As a workaround, set specifically TLSv1.2 in MySQL DB connection.