Solved

WINSQL connecting to a MYSQL database

Posted on 2013-02-01
4
975 Views
Last Modified: 2013-03-20
Hello,
I am a complete novice to WINSQL and MYSQL. I have created a database using MYSQL and now I want to connect to this via WINSQL - however I am not sure how to do this. When I click on ODBC manager it shows user data sources of DBASE files, EXCEL & ACCESS but no reference to MYSQL.  When I click on Drivers I can see that I have WinSQL  Wire protocol driver installed. However I am being asked for Data source, Host name, port and dbname. The database and WINSQL are both on the same PC. If anyone can give me simple directions about how to set up a connection I would be very grateful.

MYSQL workbench 5.2
WINSQL trial edition 9.0.107.624
Windows 7

regards
Pat
0
Comment
Question by:pclarke7
  • 3
4 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 38846079
WinSQL appears to be for Microsoft SQL Servers, not MySQL.  They are two different database servers.  I don't think that will work for you.

http://www.winsql.com/2011/07/25/database-version-edition-and-compatibility/
0
 

Accepted Solution

by:
pclarke7 earned 0 total points
ID: 38846721
WinSQL works with MYSQL and multiple other databases
0
 

Author Comment

by:pclarke7
ID: 38990274
Moved from MYSQL to MS SQL
0
 

Author Closing Comment

by:pclarke7
ID: 39002275
Moved to MS SQL database
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

772 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