https://dev.mysql.com/downloads/mysql/
requires to update the my.cnf to access the local sql setup. however there is non. Hence the solution is to open MySQLWorkbench and enter the password to connect.
the workbench will create it automatically.