Recover MYSQL Password

March 20, 2008

 Q: My root password lost?; can’t manage existing database can anyone help me?
A: Solution is simple just follow the steps below:
Recover MYSQL Password  
#/etc/init.d/mysql stop

Please wait until MySQL shuts down completely. Then run
 #/usr/bin/mysqld_safe –skip-grant-tables –skip-networking &

 then you will be able to login as root with no password.
 #mysql -uroot mysql

 In MySQL command line prompt issue the following command:
 mysql>UPDATE user SET password=PASSWORD(”letmein”) WHERE user=”root”;
 FLUSH PRIVILEGES;

 mysql>exit

  kill all the mysql processes
 #/etc/init.d/mysql stop

 Start MySQL again
 #/etc/init.d/mysql start

At this time your root password is reset to “letmein” and MySQL will now
know the privileges and you’ll be able to login with your new password:
 mysql -uroot -pletmein mysql

Congratulations you have sucessfully changed your new password :)

Step 1: Set up Netmeeting application:

1) Start > Run > type in conf and click OK

2) Follow instructions for setup

3) During setup, ignore request for directory server, leave default setting

Step 2: Disable Windows firewall:

1) Start > Control Panel > Network Connections

2) On left hand side, in box click on “Change Windows Firewall Settings”

5) Turn the firewall off

9) You are now done. Launch the netmeeting application and test it out.

10) To share a file, you must first give your participants your IP address. You can find this by clicking (in the netmeeting application window) Help > About Netmeeting. Your IP address will be listed at the bottom of the window.

11) Then click on Tools > Sharing and choose which file you want to share… or share your entire desktop if you want to make all open apps visible. Not that only the one that you see on your screen at any given time will be visible on the participant screens.

12) Experiment… it is a good tool for sharing, whiteboarding, etc… (note, you will need to mute your PC audio when using netmeeting, as it will transmit and receive audio, which is not necessary because we will use a landline conference bridge for audio).

Q. How  to fix ICMP Host Unreachable from gateway localhost (127.0.0.1)

A. People who are getting this kind of message in the server is b’cos your routing table is not set
to fix this issue follow the steps.

#ifconfig eri0 down
#ifconfig eri0 unplumb
#ifconfig eri0 plumb
#ifconfig eri0 192.168.0.12 netmask 255.255.255.0 broadcast 192.168.0.255
#ifconfig eri0 up
#/etc/init.d/inetinit start
#/etc/init.d/inetsvc start
#ping 192.168.0.1

Greetings!

February 17, 2008

Ninja!

baladmcpaper.jpg