Grant remote access of MySQL database If you try to connect to a remote MySQL database from your client system, you will get “ERROR 1130: Host is not allowed to connect to this MySQL server” message as shown below. $ mysql -h 192.168.1.8 -u root -p Enter password: ERROR 1130: Host ‘192.168.1.4’ is not allowed […]
See MoreTag: IP
20+ Switches of rsync in Unix/Linux
* Switches of rsync: 1) -v, –verbose Increase verbosity. 2) -r, –recursive Recurse into directories. 3) -l, –links Copy symlinks as symlinks. 4) -p, –perms Preserve permissions. 5) -t, –times Preserve modification times. 6) -g, –group Preserve group. 7) -o, –owner preserve owner (super-user only) 8) -D Same as –devices –specials. –devices : preserve device files […]
See MoreCommand for Rsync over SSH – Unix/Linux
Command for Rsync over SSH Common Syntax for Rsync: # rsync [options] Source Destinations. Set up a secure backup with rsync + SSH of one system to the other. backup.example.com# rsync -avz –numeric-ids –delete root@myserver.example.com:/path/ /backup/myserver/ To do the backup, you have to be root on the remote server, because some files are only root […]
See More