?
Solved

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

Posted on 2011-02-16
2
Medium Priority
?
4,756 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 60

Accepted Solution

by:
Kevin Cross earned 2000 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

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 …
In this article, we’ll look at how to deploy ProxySQL.
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…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

770 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