Skip to main content


Showing posts from June, 2021

Zip based MySQL setup on Win10

Grab the zip file from and unzip Add the mysql bin folder into your PATH mysqld --initialize-insecure --console see 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; 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.