This article is written not to forget how to install MySQL to mac laptop and connect to IntelliJ Idea. I know that in future i will forget how to do it and not to google again wrote it as an instructions for myself. If it helped you, i would be very glad.
2. Choose MySQL Community Server:
3. Download macOS 11 (x86, 64-bit), DMG Archive:
4. Install downloaded file:
5. GoTo System Preferences:
should appear MySQL icon click on it
6. Be sure that it is running, if not click start
8. install it
9. run the MySQLWorkbench in Applications:
10. Check connection:
BONUS:
Let’s create database for development purposes and connect to IntelliJ IDEA
11. Open Connection
12. Go Users and Privileges and click Add Account
13. Enter login, host, password and click Apply
14. Add Roles to the newuser to let him/her e.g. create database
15. create new mydb connection
16. Open connection -> goto Schemas -> Create Schema
17. GoTo IntelliJ IDEA
18. Enter username, password and scheme (in our case it is “new_schema”) ->click OK
19. in application.properties add this code, by changing username password and url
20. That’s it, just launch the app, and everything should be connected. if not, don’t ask questions in comment, just google :)
Utils:
kill server via terminal
netstat -vanp tcp | grep 8080
tcp46 0 0 *.8080 *.* LISTEN 131072 131072 71329 0 0x0000 0x00000006
kill -9 71329
