VNCServer – Steps to start session, set password & enlarge/re-size VNC session window.

Step 1:  Login to host server using a putty terminal. Enter Host Name and click the Open button

Step 2: Enter username/password to get authenticated through command line interface.

Step 3: In order to start a VNC session, type in the following…

vncserver :<displayNumber>

For example, the statement will look like this..  

$ vncserver :10

This will start the VNC session.

Please note: The use of displayNumber is optional. If you have specified a number, then that number will be used as displayNumber when opening the VNC session. If the above command is run without any displayNumber, then in this case it will choose the first available display number, usually 1.

Enter the following command to set a new password.

$ vncpasswd

After the command is executed, there will a request to enter the following.

Password: <enter your password here>

Verify: <enter it again to verify the password >

Step 4: Now go to your client desktop and launch VNC viewer client.

Enter VNC Server name, and click the connect button.

The launch will prompt for VNC password. Enter the newly set password to login and start using the session.

Step 5:  If you want to increase the dimension of the viewing area, then try the following command.

vncserver :30 –geometry 1000x1500

This will create a vnc session at port 30 with the above mentioned dimensions.

Step 6: When you decided to terminate the session, just  run the following command

vncserver –kill :30

This will terminate the session immediately.

Step 7: Enjoy, and have fun!

 

Steps to setup MySQL Client(Sequel Pro) for Mac OS

Step 1: Download & Install mysql for Mac OS.

http://www.mysql.com/downloads/mysql/

Step 2: To set up Sequel Pro mysql client,  go to http://www.sequelpro.com/ and download Sequel Pro, MySQL database management for Mac OS X.

Step 3: Download and install Sequel Pro.

Step 4: Navigate to Applications -> Sequel Pro. Double click it to open it.

Step 5: 

Enter 127.0.0.1 as host and click the connect button to login to mysql database. Use "Test connection" button to test the user login connectivity. 

Ps Note: you are connecting as a "test" user.  The "test" user login do not have db privilege to create database. This user can only be used to check out existing sample database.

For creating database, login as root user. Check the below screenshot for details.

Ps Note: When installing the MySQL database, I created the root username with no password.  Due to this setup, I was able to login to root user account without entering password. If you have provided the password during the install time, you need to provide the same password to login to root user account.

Step 6: After login, click the "Choose Database" drop down to check out the available options.

Step 7: Select 'Add Database' option to proceed with database creation. Enter Database Name, select Database Encoding option from the drop down and click the Add button to complete the database creation step.

Step 8: Next step is to proceed further by creating database tables. Click the + icon on the bottom left hand side to get to the table creation wizard. Enter the table name, table encoding and table type details to proceed with the table creation wizard.

Step 9: Click the "+" icon to create columns. Use "-" icon to delete columns.  Check out the below screenshot for details.

Step 10: Continue with your work. Good luck.