Thursday, February 28, 2013

How to reset apple ID password ?

Go to this URL and type your apple ID

How to reset apple id password ?

How to view open ports in windows pc

Open Command prompt :

Step 1. Press these key-combination to open run dialog
Ctrl+R 

Step 2. Type "cmd" (without quotes) command to open command prompt [DOS prompt]
cmd 

Step 3. Type "netstat -a" (without quotes)
netstat -a

To get help about this command type netstat /? or netstat help






Wednesday, February 20, 2013

Install MySQL In Ubuntu On VMware And Connect Through The Host Pc (windows or any host pc)

This article explain how to install MySql 5.5 with Ubuntu 12.04 on VMware (VMware Workstation 8.0.1) and connect through the virtual pc to access the MySql databases in Host pc (Windows or what ever os on host pc). 

1.Install MYSQL On Ubuntu 12.04

sudo apt-get install mysql-server  
(make sure you are log in as root user,fast internet connection help to download package's correctly.if network connection slow,then download packages may be corrupted!)

2.Install MYSQL Workbench
sudo apt-get install mysql-workbench 


sudo service mysql restart (this 'sudo' command not recommend if you are log in as root user.)

3.Host pc network connection parameters:

Disable other network connection as below.








figure 1.0



1.Goto VMware network adapter properties
2.Checked VMware Bridge Protocol.
3.Select appropriate ip range. VMware set default IP range
something like 192.168.###.### 
eg: 192.168.137.1 <- and="" be="" equal="" font="" guest="" ip="" must="" nbsp="" ost="" range="">

4.Guest(VMware - Ubuntu) pc network connection parameters:

1.Goto Network settings (top right corner)
2.Goto Edit Connections...
3.Select Wired Connection1 and click edit button
4.Select IPv4 Settings and Set Method as Automatic (DHCP)
5.Don't set DHCP client id or routes
6.Click available to all users ,then save.


Check whether ip address in a same range(first 9 digits must be same).(host ip range 192.168.137.###) guest must be 192.168.137.###)

To check above connection information's click network connection icon on top right corner of desktop(ubuntu) and select connection information as below.









figure 2.0


5.Create MySQL user (type these command in MYSQL command terminal)

open terminal and type mysql -u root -p
then type your root mysql password 

then type 


create user 'username'@'192.168.137.218' identified by 'your-new-password'



eg:

create user 'abc'@'192.168.137.218' identified by 'abc123'

create user 'abc'@'%' identified by 'abc123';



5.1 Replace username with your new user name to given and insert new password in to 'your-new-password'

5.2 Make sure your ip address is should be ubuntu-pc's IP address

eg: 192.168.137.218 in figure 2.0


5.3 Then grant privileges to above user
grant all privileges on *.* to 'abc'@'%' with grant option;

5.4 Then flush the privileges
flush privileges;

5.5 Restart mysql services

type this
service mysql restart;


5.6 Then goto host pc (your windows pc)
used any MySQL GUI or command line program and set the particular parameters.

eg:

mysql user: abc
host ip   : 192.168.137.218 (ubuntu-pc ip address)
password  : abc123

Thats all......Have FuN.....




------------ SOME USEFULLY COMMANDS ON UBUNTU -----------


(shell prompt type following command)

To login as root user in mysql
mysql -u root -p

To login with host name
mysql -u root -h myserver-sever.com -p

To Login with host ip address
mysql -u root -h 192.168.137.218 -p

To restart mysql services:
service mysql restart

To stop mysql services:
service mysql stop;

To start mysql service
service mysql start

create user ('%' mean any host )
CREATE USER 'freevbs'@'%' IDENTIFIED BY 'passpass';

Granted all the privileges to user freevbs
grant all privileges on *.* to 'freevbs'@'%' with grant option;

To flush privileges (alredy login in mysql )
flush privileges;

try login with freevbs
mysql -u freevbs -p;

onece you login you can check users
SELECT USER(),CURRENT_USER();

More MySQL Commands please visit below url:
http://manpages.ubuntu.com/manpages/lucid/man1/mysql.1.html


------------------------------------------------------

Vmware ubuntu 12.04 - windows 7 networking

Virtual machine settings :
-------------------------

Network adapter - Host Only
IPv4 Settings - Method Automatic DHCP
IPv6 Settings -  Method Automatic

Host-PC
---------
Select your network adapter 
eg: Celcome3G BroadBand

Right click - > properties ->goto Sharing-> select 
Allow to other network users to connect through this computer's internet connection.

Then select vmware network adapter VMNet1.

Then Press OK.







Reboot VMware -Ubuntu

sudo reboot

VMWare Tool Installation for Ubuntu

#Mount the CD drom 
sudo mkdir /mnt/cdrom

sudo mount /dev/cdrom /mnt/cdrom

#Run this command to find the exact name of the VMware Tools bundle; the file name varies depending on your version of Fusion:
ls /mnt/cdrom

#Extract contents of cdrom to tmp directory
tar -zxvf /mnt/cdrom/VMwareTools-.tar.gz -C /tmp/

Note: is the version discovered in the previous step which at the time of writing was VMwareTools-8.3.7-341836.tar.gz
#now move into the vmware tools directory in tmp directory. 
cd /tmp/vmware-tools-distrib/

#Run the installer  with the -d switch to accept defaults.
sudo ./vmware-install.pl -d

Enabling the root account in ubuntu

sudo -i
To enable the Root account (i.e. set a password) use:
sudo passwd root