MySQL

In this tutorial I’ll provide you the steps to reset root password for MySQL 8.0 and MariaDB 10.4 easily and efficiently. Since this are latest version of MySQL and fork mariadb you should do some extra caution during root password…

In this tutorial we’ll learn how to import large mysql databases via ssh terminal command line interface. Large mysql database is the issue when you import it via phpMyAdmin and its limit for uploading is lower then your initial mysql…

In this tutorial I’ll guide you on how to upgrade/install MariaDB to latest Mariadb10.4 on Centos 7 this tutorial will also work with CWP and VestaCP or any other compatible control panel. MariaDB 10.4 is now very stable and many…

In this tutorial we’ll upgrade/install to Mariadb 10.3 on Centos 7 running Vesta CP, by default vesta cp will install old base version of Mariadb 5.5 when installing on Centos 7. This tutorial will also work without vestacp installed i.e.…

Under CWP you can easily upgrade phpMyadmin to latest version without too many configuration, phpMyAdmin is a PHP script which gives users the ability to interact with their MySQL server along with easy to use GUI to manage your databases. In…