Step 1: Login to your server via SSH as root user. Step 2 Use below command to create / export […]
How to find mysql root password of a cPanel server via SSH
Login to your server as root via SSH. Step 2 By default, MySQL root password is saved in the /root/.my.cnf […]
How to Install LAMP (Linux, Apache, MySQL, PHP) on CentOS RedHat 6 Server
In this tutorial I will explain how to install and setup LAMP on a RHEL/CentOS Linux 6.x server. Before I […]
How To Install MySQL on a CentOS Server
Following command will install MySQL on a CentOS server / VPS. Login to your server as root via SSH, and […]
How to Start, Stop and Restart MySQL from SSH
Using below commands you can start, stop and restart MySQL from SSH. Login to your server as root via SSH, […]
How to find MySQL Error logs
If you want to see the list of MySQL errors on your server, please follow below steps. You can use […]
How to run MySQLTuner on a cPanel server
MySQLTuner is great script to optimize mysql database of a server. It reports a large number of statistics and settings […]
How to change or move MySQL /tmp directory
This tutorial explains how you can change or move MySQL /tmp directory to a new location on a server / […]
How to move MySQL directory to /home
By default all MySQL database on a server is saved in /var/lib/mysql directory. If you don’t have enough space left […]
How to find MySQL root password
Server root MySQL password can be different from server root password. Here is how you can get root MySQL password. […]