How to reset apple id password ? |
Thursday, February 28, 2013
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
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
------------------------------------------------------
------------ 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.
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
Subscribe to:
Posts (Atom)