enter image description hereI've exhausted every resource I've found online. I'm a neophyte with MySQL (postgres seems a lot easier to connect to server but schema design and CRUD appears easier in MySQL so I'd prefer to get this up and running). I'm running this on windows machine and have terminal, bash, mysql shell tools but that's about it.
I'm trying to connect MySQL locally to a server. I've gone through the process of uninstalling and reinstalling MySQL via the mysql-installer-web-community-8.X.exe and manually adding what was necessary.
When I initialize the app(MySQL workbench 8.0) and select my server instance there I see there is 'no connection established'. I've selected (from the side nav) 'Startup/Shutdown' and attempted to 'Start Server' but have been unsuccessful and received the dreaded "unable to connect to localhost (2003).
Here's what I've tried so far:
- services >> mysql80 >> enabled/start running
- edit variables >> environment variables >> path >> edit >> new >> 'enter path to serverX.X\bin
- checking to see if the mysql my.cnf is in \serverX.X\bin
Screenshot: enter image description here
Please help as I am very close to losing what little hair I have left.
Here's what I've tried so far:
- services >> mysql80 >> enabled/start running
- edit variables >> environment variables >> path >> edit >> new >> 'enter path to serverX.X\bin
- checking to see if the mysql my.cnf is in \serverX.X\bin
I was expecting to get connected to server but still have 'no connection established' message and (2003) error