Solved

MySQL Install Help

Posted on 2013-07-01
7
348 Views
Last Modified: 2013-07-02
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
0
Comment
Question by:Xbradders
  • 4
  • 2
7 Comments
 
LVL 6

Expert Comment

by:Vijay Pratap Singh
Comment Utility
Please check login crediantials and also shutdown the firewall
0
 
LVL 82

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 260 total points
Comment Utility
Don't shutdown the firewall.  Go to the command line and type:
mysql -u root

Open in new window

and tell us what you get.

Also did you install 'mysqld' as a service?  If you didn't, you won't be able to connect until it is running.
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
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.
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:Xbradders
Comment Utility
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.
0
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 260 total points
Comment Utility
Go to the Control Panel where you can remove programs and remove MySQL if it is listed there.  Then redo the installation.  Download a new copy if you suspect the one you have may be corrupted.
0
 

Author Closing Comment

by:Xbradders
Comment Utility
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.
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
You're welcome, thanks for the points.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Database restore 8 66
Importing and exporting data Magento 1.x ? 4 30
Display multiple images in the row in PHP 11 66
null value 14 56
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now