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;
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.