Pada terminal kita bisa menggitikkan berikut Matikan dulu MySQL Server nya. sudo / etc / init.d / mysql stop Lanjut dengan konfigurasi mysqld. sudo mysqld – skip-grant-tables & Login sebagai root ke MySQL . mysql -u root mysql Ganti Password root dengan password baru. UPDATE user SET Password=PASSWORD(‘YOURNEWPASSWORD’) WHERE User=’root’; FLUSH PRIVILEGES; exit;
Category > Linux
Ubuntu server allow tcp Mysql connection from remote system
open /etc/mysql/my.cnf file Code: sudo vi /etc/mysql/my.cnf Make sure bind-address set to your server IP address (not to 127.0.0.1) Code: bind-address = 192.158.5.1 Also make sure line skip-networking is removed or commented out Code: # skip-networking Save and close the file; Restart mysql Code: sudo /etc/init.d/mysql restart Let us assume that you are always making [...]
WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! Dan Solusinya
Bila terjadi perubahan pada remote IP host yang diremote ssh biasanya akan tampil “WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!” sehingga kita tidak mengakses komputer yang kita tuju. Contoh tampilan warning: @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you [...]
