Nov 01

Build MySQL from source on Centos

There are plenty of methods available to install MySQL on Centos. Among those methods, most recommended way is, installing MySQL from standard source distribution, because it will allow to customize the installation as you wish and able to add other modules as well. This tutorial guide you how to build MySQL from source with few easy steps.

1) Download latest MySQL source.


2) Create user and group called “mysql”

3) Install depended software packages.

You may need following packages. it will totally depend on your Linux distribution.
Loot at how to install perl for MySQL from here.

4) build MySQL

Sometimes cMake give you errors. So don’t get panic, find the error and fixed it. Most of the time you need to install some missing package. After that DON’T FORGET to delete CMakeFiles content and, CMakeCache.txt before cMake again.

5) Configure MySQL

here assuming MySQL database directory as /opt/mysql/data. Otherwise it will goes to default location.

6) Start MySQL

Set MySQL up start script and then start the MySQL server.

7) Set MySQL root password

Wow, how cool it is. Comment here if you got any issue.

Note :- below is sample my.cnf file with basic configuration .


Leave Your Thought Here