Freshly installed MySQL server keeps switching between active and not active; MacBook Pro OS 14 Sonoma M2

[Peter Pine]

Tried twice to install MySQL server. The community server from the mSyQL site. 8.4.0 ARM64. Both times I get as result that the server's status is switching on and off (active / not active); see attached image. The two dots switch from red to green and back. And the button "Start mySQL server" back to "Stop MySQL Server". I have a MacBook Pro OS Sonoma 14.1.1 with M2. switching active/not active

I also installed MySQL Workbench which gives the message that there is no MySQL server running.

Uninstalled the first attempt and reinstalled for a second time. Searched for more info on the internet but could not find solution. Checked via Terminal with the following command I found on internet: /usr/local/mysql/bin/mysql -u root -p I got a prompt that asked for my password. The result was "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)".
I also tried sudo less /var/log/mysql/error.log to learn more however after entering the password I get the message "Sorry try again". I am 100% convinced that I use the right pw.

What magic trick is need to het Apple's OS working with MySQL?
Thanks for the help.