Wednesday, September 25, 2013

how to change root password mysql

# /etc/init.d/mysqld stop
# /usr/bin/mysqld_safe --skip-grant-tables --skip-networking &
# mysql -u root
mysql> use mysql;
mysql> UPDATE user SET Password=PASSWORD("your password here") WHERE User="root";
mysql> exit

# /etc/init.d/mysqld stop
# /etc/init.d/mysqld start

Friday, September 6, 2013

Cisco switch port in err disabled , how to recover

go to the specific port configuration mode.

disable port security , disable and enable

 
 
show port 0/19                          will show state
 
Port  Name               Status     Vlan       Level  Duplex Speed Type
----- ------------------ ---------- ---------- ------ ------ ----- ------------
0/19              errdisable   1 normal   auto  auto 10/100BaseTX
 


acc-sw-2960-48p-svr-(config-if)#no switchport port-security

acc-sw-2960-48p-svr-(config-if)#shutdown

acc-sw-2960-48p-svr-(config-if)#no shutdown