<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/platform.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d32370122\x26blogName\x3d.%3EGhufron+Aje%3E%3E%3E\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttps://guf-t.blogspot.com/search\x26blogLocale\x3den_US\x26v\x3d2\x26homepageUrl\x3dhttp://guf-t.blogspot.com/\x26vt\x3d-848752436076766533', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>
Tuesday, October 19, 2010
Recovery Password ROOT di MySql
Cari-cari di google cara untuk recovery password root di mysql untuk linux, ternyata susah juga yah, sudah banyak situs-situs atau blog orang yang tidak aktif lagi, untuk nya masih bisa nemu 1 situs yang memberikan informasinya secara lengkap. http://www.cyberciti.biz/tips/recover-mysql-root-password.html

Biar gampang carinya lagi terpaksa gw tulis di blog gw.

Step # 1: Stop the MySQL server process.

Step # 2: Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for password.

Step # 3: Connect to mysql server as the root user.

Step # 4: Setup new mysql root account password i.e. reset mysql password.

Step # 5: Exit and restart the MySQL server.

Here are commands you need to type for each step (login as the root user):

Step # 1 : Stop mysql service

# /etc/init.d/mysql stop

Output:

Stopping MySQL database server: mysqld.
Step # 2: Start to MySQL server w/o password:

# mysqld_safe --skip-grant-tables &

Output:

[1] 5988
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6025]: started
Step # 3: Connect to mysql server using mysql client:

# mysql -u root

Output:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
Step # 4: Setup new MySQL root user password

mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit

Step # 5: Stop MySQL Server:

# /etc/init.d/mysql stop

Output:

Stopping MySQL database server: mysqld
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[6186]: ended

[1]+ Done mysqld_safe --skip-grant-tables
Step # 6: Start MySQL server and test it

# /etc/init.d/mysql start
# mysql -u root -p

Moga saja membantu.
 
posted by ghufron at 4:01 PM | Permalink | 0 comments
Thursday, October 14, 2010
merubah hosts di windows
Kalo di linux ga begitu susah untuk merubah hosts, tapi klo di windows mungkin sebagian orang ada yang blum mengetahui letak hosts file tersebut,

C:\Windows\System32\drivers\etc\hosts
 
posted by ghufron at 11:05 AM | Permalink | 0 comments
Tuesday, October 12, 2010
SSH Error
Akhirnya gw ngalamin juga ketika mau ssh ke server sendiri dari linux, di tolak karena
RSA key nya sudah berganti, atau server nya berganti dengan ip atau hostname yang sama,

berikut ini pesan error yang keluar
" IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that the RSA host key has just been changed. The fingerprint for the RSA key sent by the remote host is 31:f8ab:c5:24:6d:922:eb:63:87:f7:15:1b:67. Please contact your system administrator. Add correct host key in /home/ghufron/.ssh/known_hosts to get rid of this message. Offending key in /home/ghufron/.ssh/known_hosts:7 RSA host key for www.gufy.web.id has changed and you have requested strict checking. "

Setelah tanya2 teman ASWIN HADINATA (yang insya allah akan dpat RHCE) dapat solusi untuk menghapus data2 base RSA key yang pernah ke simapan, caranya.
echo " " >/home/ghufron/.ssh/known_hosts

Akhirnya server bisa di SSH kembali dengan RSA yang baru.
Thanks to Aswin Hadinata
 
posted by ghufron at 6:01 PM | Permalink | 0 comments