Xbradders
asked on
MySQL Install Help
I just installed MySQL Workbench and MySQL Server 5.6 but can't seem to get a Server Instance initiated. I went through the install and it all is up to date and seemed to go well, but when Workbench opens up, it does not show my localhost or MySQL56 instance. I try to add a default instance by selecting "New Server Instance", but it fails to connect (see attached screenshot for message).
I'm guessing it has something to do with the port or something... I choose the default 3306 when installing, but I'm not sure. Please advise.
ss.png
I'm guessing it has something to do with the port or something... I choose the default 3306 when installing, but I'm not sure. Please advise.
ss.png
Please check login crediantials and also shutdown the firewall
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I just fired up MySql Workbench on one of my machines. If you installed MySQL on that machine, you do not need (or want) to create a new instance. Go to the first column where it says 'Open a connection' and it will probably just 'automatically' bring up the MySQL server on that machine.
ASKER
Shutting down the firewall didn't help.
I ran "mysql -u root" from cmd and it says "mysql is not recognized as an internal or external command, operable program or batch file".
It seems like MySQL Server is not running. I look at Windows Services and don't see it there, and I should, right? How do I start it?
I go to programs | MySQL | MySQL Server 5.6 and just shows me the Command Line Client. When I open that, it just opens and closes right away.
I ran "mysql -u root" from cmd and it says "mysql is not recognized as an internal or external command, operable program or batch file".
It seems like MySQL Server is not running. I look at Windows Services and don't see it there, and I should, right? How do I start it?
I go to programs | MySQL | MySQL Server 5.6 and just shows me the Command Line Client. When I open that, it just opens and closes right away.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I uninstalled and reinstalled and am all good. I had downloaded Workbench and MySQL Server separately and they must not have been jiving... When I did it all from the Windows installer, it worked. Thanks for your suggestions.
You're welcome, thanks for the points.