Install MariaDB From Source

Installation

1. Install dependencies:

   apt-get install -y libmysqlclient-dev cmake libncurses5-dev libaio1 libaio-dev
   

2. Download, build & install MariaDB:

   wget https://downloads.mariadb.org/f/mariadb-5.5.31/kvm-tarbake-jaunty-x86/mariadb-5.5.31.tar.gz/from/http:/mirror2.hs-esslingen.de/mariadb -O - | tar zxf -
   cd mariadb-5.5.31
   cmake .
   make && make install
   

3. Add user & group:

   groupadd mysql
   useradd -g mysql mysql
   

Configuration

1. Set permissions:

   chown -R mysql /usr/local/mysql
   chgrp -R mysql /usr/local/mysql
   

2. Setup internal database:

   /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
   

3. Link mysqld_safebinary file:

   ln -s /usr/local/mysql/bin/mysqld_safe /usr/bin/
   

4. Create MySQL configuration:

   mkdir /etc/mysql
   cp /usr/local/mysql/support-files/my-medium.cnf /etc/mysql/my.cnf
   

5. Edit /etc/mysql/my.cnf

   [mysqld]
   bind-address = 127.0.0.1
   

6. Set root Password

   /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/mysql/my.cnf --user=mysql --datadir=/usr/local/mysql/data &
   /usr/local/mysql/bin/mysqladmin -u root password
   

7. Create init script:

   cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql 
   chmod +x /etc/init.d/mysql
   update-rc.d -f mysql defaults
   

8. Restart MySQL Service:

   service mysql restart