Enable Remote Access To Mysql Database Server Or On VPS Ubuntu

If you want to make application with remote database, you will need to grant database on your server to be accessed by your application. Now I will tell you how to grant access so your application can use mysql from your server.

Backup and Restore Database MySQL

For backup all databases

  mysqldump -u username -ppassword --all-databases > /tmp/alldatabases.sql

For backup spesific database

 mysqldump -u username -ppassword --databases databasename > /tmp/filename.sql

For restore

mysql -u username -ppassword databasename < /tmp/filename.sql