Solved

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

Posted on 2011-02-16
2
4,690 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

821 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