VestaCP,  Linux

How to Upgrade MySQL and Install MariaDB 10.2 on Ubuntu 18.04 LTS and 16.04 LTS

In this tutorial we’ll upgrade/install to Mariadb 10.2 on Ubuntu 18.04 LTS, 16.04 LTS and with vestacp when you install MySQL version 5.7 will be install on Ubuntu 16 and 18. This tutorial will also work with vestacp installed soon 18.04 will be supported by vestacp. MariaDB is designed as a drop-in replacement of MySQL with more features, new storage engines, fewer bugs, and better performance. MariaDB is developed by many of the original developers of MySQL who now work for the MariaDB Foundation and the MariaDB Corporation, and by many people in the community. To upgrade follow this simple steps to upgrade it to latest version.

Login as root and follow the commands one by one.

First Add mariadb apt repository :

For 18.04 LTS :

For 16.04 LTS :

To Upgrade :

This is only for the upgrade and follow this commands :-

Stop and remove MySQL server :

Now we’ll Update/install

When the installer ask for the password just leave it blank it will ask to set the password 3-4 times for all time leave the password blank (imp when upgrading from mysql to mariadb only)

Well Mariadb is now installed and you just need to start mariadb server and upgrade the database :

Now upgrade the database :

To Install :

This is only for fresh installation don’t use it for the upgrade.

When it will ask you to enter root password please enter and remember the password, after successful installation start the mariadb server :

For VestaCP only extra config :

thats it you can login as root for the checks.

Nguồn

Tui là jamesblackvn!

Gửi phản hồi

Website này sử dụng Akismet để hạn chế spam. Tìm hiểu bình luận của bạn được duyệt như thế nào.