• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1093
  • Last Modified:

WINSQL connecting to a MYSQL database

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
Windows 7

  • 3
1 Solution
Dave BaldwinFixer of ProblemsCommented:
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.

pclarke7Author Commented:
WinSQL works with MYSQL and multiple other databases
pclarke7Author Commented:
Moved from MYSQL to MS SQL
pclarke7Author Commented:
Moved to MS SQL database
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now