Solved

WINSQL connecting to a MYSQL database

Posted on 2013-02-01
4
948 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 82

Expert Comment

by:Dave Baldwin
Comment Utility
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
Comment Utility
WinSQL works with MYSQL and multiple other databases
0
 

Author Comment

by:pclarke7
Comment Utility
Moved from MYSQL to MS SQL
0
 

Author Closing Comment

by:pclarke7
Comment Utility
Moved to MS SQL database
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Creating and Managing Databases with phpMyAdmin in cPanel.
This is an article about Leadership and accepting and adapting to new challenges. It focuses mostly on upgrading to Windows 10.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…

762 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

11 Experts available now in Live!

Get 1:1 Help Now