Category: MySQL

Step 1: Login to your server via SSH as root user. Step 2 Use below command to create / export […]

Login to your server as root via SSH. Step 2 By default, MySQL root password is saved in the /root/.my.cnf […]

In this tutorial I will explain how to install and setup LAMP on a RHEL/CentOS Linux 6.x server. Before I […]

Following command will install MySQL on a CentOS server / VPS. Login to your server as root via SSH, and […]

Using below commands you can start, stop and restart MySQL from SSH. Login to your server as root via SSH, […]

If you want to see the list of MySQL errors on your server, please follow below steps. You can use […]

MySQLTuner is great script to optimize mysql database of a server. It reports a large number of statistics and settings […]

This tutorial explains how you can change or move MySQL /tmp directory to a new location on a server / […]

By default all MySQL database on a server is saved in /var/lib/mysql directory. If you don’t have enough space left […]

Server root MySQL password can be different from server root password. Here is how you can get root MySQL password. […]