I'm sorry, yeah I know, I spend whole day digging how to do it. Unfortunately It is very hard to help you remotely. The worst thing also that I have Linux, and not Mac.
So if you have anyone that can help you locally, that would be the best solution. I would you recommend you to remove MySQL and try to re-install it. Here for example instructions to remove MySQL i found After doing that, install MySQL using following Guide on official MySQL page According to it, at the step 7, temporary password will be shown Try to follow those instructions, may be that will work. They look pretty straightforward to me.
1) We have installed MySQL 5.0 on WIndows 2003 server 2) Service is running and in automatic mode. Even I am able to restart the service. 3) When I try at command prompt: mysql -h localhost mysql -u root -p I am getting both 'Access denied for user 'root'@'localhost' (using password: NO)' & Access denied for user 'root'@'localhost' (using password: YES).
Of course you also can write me exactly what commands are you writing and its output, and we can try to debug where the problem is, but because Mac has such a nice GUI installator, I think you should to try to reinstall. I understand. But before you go, I wanted to advice you one more thing. MySQL workbench is not the only tool around to create Databases. Check out this site There plenty of SQL programs out there.
If I were you I would have tried others For example I really like JetBrains company, and if I ever need database creation tool, I'm going to try 'DataGrip' solution. It has 30-day trial, but still is a definitely a thing to try. I know it will be a bit more complicated to follow the course, but still. MySQL it is just a tool, nothing else. And if a tool does not work, you use another one that does.