MySQL Open Port 3306 on Ubuntu

1. The default form MySQL Server is to be binding to localhost (127.0.0.1), which means it only accepts connections from local applications.

2. To change it, open up your terminal. Find port 3306.

 

3. Change to root user and edit the below file.

4. Place a hash (#) at the beginning of the line.

 

5. Restart your MySQL Server.

 

6. Test remote connection.

Linux Crontab

Overview

Crontab is the program used to install, deinstall or list the tables used to drive the cron daemon in Vixie Cron. Each user can have their own crontab, and though these are files in /var/spool/cron/crontabs, they are not intended to be edited directly.

Each user has their own crontab, and commands in any given crontab will be executed as the user who owns the crontab. Uucp and News will usually have their own crontabs, eliminating the need for explicitly running su as part of a cron command.

• To view crontab file:

$ crontab -l

• To edit crontab file:

$ crontab -e

• To remove crontab file:

$ crontab -r

• To display the last time you edited your crontab file:

$ crontab -v

(credit image: link)

Control Rhythmbox With SSH

1. Open terminal/putty.

2. Type this command line:

alias rc='env DISPLAY=:0.0 rhythmbox-client --no-start'

3. Screen below will be displayed.

4. You are able to control the playlist such below commands.

• rc –play
• rc –pause
• rc –volume-up
• rc –volume-down
• rc –mute

5. Refer to this link for details. [ link ]

6. Now you can use any of the rhythmbox-client controls in a SSH session with ease!