Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

WINSQL connecting to a MYSQL database

Posted on 2013-02-01
4
Medium Priority
?
1,060 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 84

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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

879 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