Remote MySQL Connection on Ubuntu

Enable Remote Connection Edit /etc/mysql/my.cnf Basic Editing Options: 1. Less secure, most accessible: Comment out bind-address 2. More secure, less accessible: change bind to your server’s IP address Save and exit. $ sudo service mysql restart Grant Access to your … Continued

MYSQL Dump from Command Line

Back up your database from the command line using mysqldump. This works in most Linux based terminals / SSH.

  [uname] Your database username [pass] The password for your database (note there is no space between -p and the … Continued