Change MYSQL Database Directory Path in Linux
Step 1: Stop MYSQL sudo service mysqld stop Step 2: Copy MYSQL data to new path sudo cp -R [old path] [new path] Note: By default we have /var/lib/mysql as [old path] Step 3 : Change user to mysql for new data directory sudo chown -R mysql:mysql [new path] Step 4 : Apply proper security context sudo chcon -R -t mysqld_db_t [new path] Step 5 : Edit /etc/my.cnf [mysqld] datadir=[new path] socket=[new path]/mysql.sock [mysql] socket=[new path]/mysql.sock