MySQL Tips Allow root remote access GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '[root password]' WITH GRANT OPTION; MySQL Backup & Restore # Backup mysqldump --user=root -p [Db Name] > backup.sql # Restore mysql --user=root -p [Db Name] < backup.sql