Solved

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

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

726 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