MYSQL Dump from Command Line

Upated Instruction 1/31/2019 Basic mysqldump command. The -p flag will prompt you for your password later. Fill in the example_text with your info. mysqldump -u user_name -p database_name > desired_file_name.sql To dump a database from a remote database host you … Continued

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