Solved

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

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

746 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

10 Experts available now in Live!

Get 1:1 Help Now