I would like to know how to install MySQL from a source

Asked By 10 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by kairi
Answered By 0 points N/A #116255

I would like to know how to install MySQL from a source

qa-featured
Mysql package from https://www.mysql.com/ should contain all the below components
 
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
ODCB conncetors for Mqsql can be downloaded from https://dev.mysql.com/downloads/connector/odbc/
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.
Best Answer
Best Answer
Answered By 0 points N/A #116256

I would like to know how to install MySQL from a source

qa-featured

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.

Related Questions