first > find this path
C:\WINDOWS\system32\drivers\etc
open LMHOSTS and HOST files, using notepad.
then find it in (LMHOSTS) ;
# The following example illustrates all of these extensions:
#
# 102.54.94.97 rhino #PRE #DOM:networking #net group's DC
# 102.54.94.102 "appname \0x14" #special app server
# 102.54.94.123 popular #PRE #source server
# 102.54.94.117 localsrv #PRE #needed for the include
#(add here any incorrect ip address followed by website name
what u want to block )
# #BEGIN_ALTERNATE# #INCLUDE \\localsrv\public\lmhosts# #INCLUDE \\rhino\public\lmhosts# #END_ALTERNATE
read BOLD letters carefully , after that save it.
then
find it in (HOSTS) ;
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
# (add here the same incorrect ip address followed by same website name what u want to block )
127.0.0.1 localhost
read BOLD letters carefully , afterthat save it.
after finish this process ,
try to access google.com
howwww ?
note : before editing this two files please backup it and continue
Wednesday, November 25, 2009
How To Change MySQL Root Password in linux
Question: How do I change MySQL root Password?
Answer: You can change MySQL root password using one of the following 3 methods.
These methods can be used on both Windows and Unix Environment including Ubuntu, Debian, CentOS, Fedora, RedHat, Arch Linux, SUSE etc.,
Method 1. How to Change MySQL Root Password Using mysqladmin Command?
You can change the mySQL root password using mysqladmin command as shown below. Please note that there is no space between -p and currentpassword.
Once you’ve changed it make sure you can login with your new password successfully as shown below.
Method 2. How to Change MySQL Root Password From MySQL Prompt Using UPDATE SQL Command?
You can also use the standard update SQL command combined with the MySQL password function to change the password as shown below.
Login to MySQL root account using old password
Use the UPDATE Command to change root password.
Once you’ve changed it make sure you can login with your new password successfully as shown below.
Method 3. How to Set MySQL Root Password Using mysqladmin Command?
This method works only if there is no password currently assigned for the root account. If you don’t have any password assigned to the root account, set the password without giving current password as shown below.
How to Change MySQL Regular User (non-root) Password Using mysqladmin Command?
You can use the same mysqladmin command to change password for a mySQL end-user account as shown below.
How to Change MySQL Regular User (non-root) Password From MySQL Prompt Using UPDATE SQL Command?
You can also use the standard update SQL command combined with the MySQL password function to change the password of a non-root user as shown below.
Answer: You can change MySQL root password using one of the following 3 methods.
These methods can be used on both Windows and Unix Environment including Ubuntu, Debian, CentOS, Fedora, RedHat, Arch Linux, SUSE etc.,
Method 1. How to Change MySQL Root Password Using mysqladmin Command?
You can change the mySQL root password using mysqladmin command as shown below. Please note that there is no space between -p and currentpassword.
# mysqladmin -u root -pcurrentpassword password 'newpassword'
Once you’ve changed it make sure you can login with your new password successfully as shown below.
# mysql -u root -pnewpassword
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.1.25-rc-community MySQL Community Server (GPL)
mysql>
Method 2. How to Change MySQL Root Password From MySQL Prompt Using UPDATE SQL Command?
You can also use the standard update SQL command combined with the MySQL password function to change the password as shown below.
Login to MySQL root account using old password
# mysql -u root -poldpassword
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.1.25-rc-community MySQL Community Server (GPL)
mysql>
Use the UPDATE Command to change root password.
mysql> UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';Verify the new MySQL root password
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Once you’ve changed it make sure you can login with your new password successfully as shown below.
# mysql -u root -pnewpassword
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.1.25-rc-community MySQL Community Server (GPL)
mysql>
Method 3. How to Set MySQL Root Password Using mysqladmin Command?
This method works only if there is no password currently assigned for the root account. If you don’t have any password assigned to the root account, set the password without giving current password as shown below.
# mysqladmin -u root password 'newpassword'[Note: There is no currentpassword for root in this example]
How to Change MySQL Regular User (non-root) Password Using mysqladmin Command?
You can use the same mysqladmin command to change password for a mySQL end-user account as shown below.
# mysqladmin -u jsmith -pcurrentpassword password 'newpassword'
How to Change MySQL Regular User (non-root) Password From MySQL Prompt Using UPDATE SQL Command?
You can also use the standard update SQL command combined with the MySQL password function to change the password of a non-root user as shown below.
mysql> UPDATE user SET password=PASSWORD('newpassword') WHERE user='ramesh';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Subscribe to:
Posts (Atom)