Posts Tagged ‘update’


Aida saya dah jumpa cara senang nak recover root password utk freebsd @ Linux :
Step 1 = Stop mysql
Freebsd = /usr/local/rc.d/mysql-server stop
Ubuntu / Debian = /etc/init.d/mysql stop
Step 2 = start mysql data 
Freebsd : /usr/local/rc.d/mysql-server –skip-grant-tables &
Ubuntu / Debian = /usr/sbin/mysqld –skip-grant-tables –skip-networking &
Step 3 = Login Mysql
Freebsd = mysql -u root mysql
Ubuntu / Debian = mysql -u root
Step 4 : Change Password
** Utk root yg bleh access database online i.e.:  Muamalat
mysql> UPDATE mysql.user SET Password=PASSWORD(‘newpwd’) WHERE User=‘root’;
** Utk Mysql biasa i.e: Arrahn
mysql> SET PASSWORD FOR root@‘localhost’ = PASSWORD(‘password’);
Step 5 : kill mysql
killall mysqld 
issue command ni “ps aux | grep mysql”
dapatkan PID kemudian kill PID “killall PID”
CTH : 

msyamsuris-iMac:~ msyamsuri$ ps aux | grep mysql

msyamsuri        2866   0.0  0.0  2432772    664 s000  S+    8:08PM   0:00.00 grep mysql

2866 <– PID No

Step 6 : hidupkan semula mysql

Freebsd = /usr/local/rc.d/mysql-server strt
Ubuntu / Debian = /etc/init.d/mysql start

OK sekian utk Tutorial . 

** Email to mysq X-staff fine simple solutions for mysql root recovery.

I have install and test Endian Firewall…

For almost 5 year I’am using pfsense than for this coming years I wanted to change to new firewall. But I have promlem with dnsmasq on Endian Firewall.

I’am googeling and found something that similar to my problem.

if you having that problem try this ways.

ssh to endian firewall

hackintosh$ ssh root@

1. cp /etc/dnsmasq/resolv.conf /etc/dnsmasq/resolv.conf.old.

2. pico /etc/dnsmasq/resolv.conf


CHANGE THE nameserver value. 

nameserver ## your firewall ip

namserver ## google dns 

3. /etc/init.d/dnsmasq reload

4. /etc/init.d/dnsmasq restart