I would like to know how to install MySQL from a source. What are the other MySQL requirements aside from libraries and header files? Can I find all of them on the MySQL tar files or do I need to look for them somewhere else? Where are they located?
- Login or Signup Now to post comments
To be able to use MySQL, there are components that you need to install first.
MySQL Server
Servers are the one that holds the databases. They can be downloaded from http://www.oracle.com/us/products/mysql/index.html. They come in many version depending on your needs.
1) Enterprise Edition;
2) Standard Edition;
3) ClassicEdition;
4) Cluster Edition;
5) Community Edition and
6) Embedded Edition.
MySQL ODBC Connector
Connectors allows you to connect to any specific server found in your network. They can be downloaded from http://www.mysql.com/downloads/connector/. Connectors just like the servers comes in many types.
1) Connector/ODBC - It is the standardized driver for Windows, Linux, Mac, OS X, and Unix Platform;
2) Connector/J - It is the standardized driver for Java Platform and development;
3) Connector/Net - It is the standardized driver for .Net platform and development;
4) Connector/MXJ - It is the standardized driver for Embedded Systems made in Java;
5) Connector/C++ - It is the driver for C++ development and
6) Connector/C - It is the driver used for C development.
Optional DBMS
You can use the MyManager 2010 for MySQL to manage you database using GUI. This can be downloaded from http://www.sqlmanager.net/products/mysql/manager/. This can help you create databases, create tables and manage permission easier. Alternatively, you can download similar DBMS like Navicat8 which can be downloaded from http://www.navicat.com/en/download/download.html. phpMyAdmin is also one of the DBMS used in managing MySQL. Usually, one may prefer the bundled software together with WAMP (Windows, Apache, MySQL, PHP) or LAMP (Linux, Apache, MySQL, PHP) Framework.