Ubuntu

Install MySQL Server on Ubuntu 16.04

How To Reset Root Password MySQL Server

By default, MySQL server will be installed with root account and password is blank. Have you ever forgotten the root password on one of your MySQL servers? If you have set the password for root and ...

Install MySQL Server on Ubuntu 16.04

How To Enable Slow Query Log for MySQL

MySQL has built-in functionality that allows you to log SQL queries to a file, You can enable the full SQL queries logs to a file or only slow running queries log. It is easy for us to troubleshoot/...

Install MySQL Server on Ubuntu 16.04

How To Backup and Restore MySQL Database Using Command Line

This tutorial guide will show you two easy ways to backup and restore the data in your MySQL database using mysqldump. You can also use this process to move your data to a new web server. We assume ...