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

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?

• Status: Open
• Question Views: 1209
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Networking

Best Answer by kairi

Go To Solution

Answered By Rocky Class 0 points N/A #116255

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

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.

About Rocky Class

Questions
4

Answers
15

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 01/25/2012
• Question Category: Networking

Best Answer

Best Answer

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.

About kairi

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 02/20/2012
• Question Category: Networking