Asked By
webexptpro
10 points
N/A
Posted on - 01/25/2012
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?
I would like to know how to install MySQL from a source
1) Installer ( .exe file if windows )
2) Mysql server instance configuration wizard to configure the instance of MQsql running.
3) MSQL Server
4) Mysql Client
5) C Header/Libraries
6) Scripts & Examples
You can choose for only Essential or Complete download while downloading from the website.
Essentials contains only server and Client components along with installation.
Additional components that will be required are below:
ODBC
ODBC Connector for client application programs to access database
You can choose the binary according to the platform under which you are planning to configure Mqsql
PHP
If you are planning to use MySql with PHP you can download the PHP API from the website
Anitvirus Restriction
If your using a antivirus software on your system , then it is recommended to disable the antivirus software
to search the MYSQL installation directories for Virus , as they would cause damage to the Mysql functioning.
Answered By
kairi
0 points
N/A
#116256
I would like to know how to install MySQL from a source
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 https://www.oracle.com/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 https://dev.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 https://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 https://www.navicat.com/en/. 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.
