I should have written this entrance before, because the original in spanish was published on September 2013, one year ago!
After installing MySQL and all the entrance related to MySQL upgrading versions, here for 5.6 and here for 5.7, I must try MariaDB.
Let’s try MariaDB 10
It has been on alpha state (in developing mode) for a long time, but now you can download it and give it a try. And, as you can see, the installation process is quickly, clean, and easy. I am using a vistual machine with Windows XP, so I download the 32 bits versions from downloads.mariadb.org/mariadb/10.0.4. (this is the version I tested when I created the original entrance. Now, you can try 10.0.12, that you can download here: https://downloads.mariadb.org/mariadb/)
Install MariaDB
After the initial windows, accept the licence:
Licencia de uso para MariaDB
Next, you are asked to create a new database instance, or upgrade existing instances. In my case, I create a new one:
Install MariaDB
Next, you need to select the path where everything will be install:
Install MariaDB
The next step is the root password, and some basic options. It is important to select the UTF8 coding as default!
Instalando MariaDB
Next step is to name the service, select the port (default port is 3306, the same used by MySQL), but in my case, I am using 3307 (basically because on this vistual machine I have installed also MySQL with the 3306 used).
Create a service for MariaDB
And last, you can enable feedback:
Install MariaDB
Everything is ready to start:
Install MariaDB
A few minutes lates, the new MariaDB server is ready to use:
MariaDB server is ready
Verifying that MariaDB is running
So, let’s open heidiSQL, selecte port 3307, and introduce the data to log in, verifying that the new MariaDB server is up and running.
MariaDB server running
So, by now, no errors during installation is very positive (after a few errors when installing MySQL). So, …
The match begins, and MariaDB 1 – MySQL 0
As you can imagine, it doesn’t worth anything, compared with new features of MySQL if you need to solve errors when installing, so I encourage Oracle to avoid this “important” details, becuase MariaDB is a very serious competitor for MySQL!
Have a nice day!