Solved

MySQL and  MySQL Workbench (GUI Tool) on Win 7 64 bit instalation and usage questions

Posted on 2011-02-16
2
4,655 Views
Last Modified: 2012-05-11
Hi,
I am new to Mysql,

1) Can I install MySQL Workbench (GUI Tool)  on Win 7 64 bit?
It seems to show only 32 bit options?
http://dev.mysql.com/downloads/workbench/5.2.html

2) I have installed tbe MySQL Cluster on the Win 7  64 bit and I want to work with it from visual C++ 2010

3) Is  Mysql cluster harder to configure than the  MySQL Workbench?
Will the  MySQL Workbench work fast although its 32 bit binaries on a 64 bit machine?

4) Where can I find a  VC++ example to connect to the database?
Can you please supply an example, what do II need to write in Visual C++ and in the command line in Win 7 (or at least the steps ) to build the Database from Visual C++

5) How do I start the MySQL cluster each time I boot the computer ? do I need to write a script and is there a Mysql command to read a script?

6) Do I need to install the Xampp? will it help me?
Both my Visuall C++ and the Mysql are on the same machine.

Thanks
0
Comment
Question by:star90
2 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 34911358
1) Can I install MySQL Workbench (GUI Tool)  on Win 7 64 bit?
It seems to show only 32 bit options?
Yes, I have installed on my machine that is running Windows 7 64bit.  It will install under Program Files (x86) as it is still a 32bit application.

2) I have installed tbe MySQL Cluster on the Win 7  64 bit and I want to work with it from visual C++ 2010
You may just need the connector.  Not sure what your question here is.
http://www.mysql.com/downloads/connector/cpp/

3) Is  Mysql cluster harder to configure than the  MySQL Workbench?
Will the  MySQL Workbench work fast although its 32 bit binaries on a 64 bit machine?
MySQL workbench works just fine for me.  The workbench is just a management tool.  MySQL itself is what you need to run quickly and that will depend on hardware and configuration, etc.  As far as which is easier, the tool is merely that.   Configuration of the server will need to be addressed properly.  Again, not sure I understand where you are heading with comparison of the cluster and the workbench.  

4) Where can I find a  VC++ example to connect to the database?
Can you please supply an example, what do II need to write in Visual C++ and in the command line in Win 7 (or at least the steps ) to build the Database from Visual C++
Read: http://dev.mysql.com/tech-resources/articles/mysql-connector-cpp.html

5) How do I start the MySQL cluster each time I boot the computer ? do I need to write a script and is there a Mysql command to read a script?
Read: http://downloads.mysql.com/tutorials/cluster/GetMySQLClusterRunning-Windows.pdf
You can always place the command into a startup script for Windows.

6) Do I need to install the Xampp? will it help me?
Both my Visuall C++ and the Mysql are on the same machine.
Not sure you need XAMPP.  It is an Apache, MySQL and PHP/Perl stack; is that what you are developing for?
0
 

Author Comment

by:star90
ID: 34911871
Hi mwvisa1,
Thanks for the answers.
I need to use the Mysql from Visual C++ so I suppose I don´t need an Apache.
I understood from your answer about the Workbench, I will install it.
Thanks.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

911 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

21 Experts available now in Live!

Get 1:1 Help Now