Switching MySQL 5.x to MariaDB 10.x on Ubuntu 14.04

If you are going to use MariaDB to replace existing implementation of MySQL in production environment, then you will realize changing a DBMS to one another has never been easier considering the risks of incompatible supported features and functionalities, unpredictable development time and resources, migrating a huge amount of data and so on. MariaDB has already succeeded as a "drop-in" replacement  for MySQL and is truly open source and more optimized, faster and safer.

Though being mentioned that Migration might become difficult after 2015, below is a few steps which I believe is quite simple to install MariaDB replacing MySQL on Ubuntu 14.04.x as I came across the same requirement switching MySQL 5.5.5 to MariaDB 10.1.14.

Common Errors Importing DataBases in phpMyAdmin

If you have just installed XAMPP or WAMPP and going to use a vanilla phpMyAdmin, there are a few things you need to configure before you do something with the DataBase (especially when uploading / importing data to MySQL) and you might face some issues or errors as described below which are common to every novice.

---

Warning: POST Content-Length of xxxxxxxx bytes exceeds the limit of xxxxxxx bytes
You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit.

Creating a MySQL Database from Command Line

It seems easy but a bit dizzy one for a novice, so let me share a simple guide.
If you don't have MySql installed, you can download it from
http://dev.mysql.com/downloads/,
one should also read the documentation here http://dev.mysql.com/doc/.
During installation, you will have to configure the server instance, optionally the port number (default is 3306) and the root password.