WebServer

Fix “Remote Host Identification Has Changed” Error

While trying to connect to remote CentOS server through SSH from local CentOS server, I encounter the following error,

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
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
" ".
Please contact your system administrator.
Add correct host key in /root/.ssh/known_hosts to get rid of this message.
Offending key in /root/.ssh/known_hosts:1
RSA host key for yourserver.net has changed and you have requested strict checking.
Host key verification failed.

Prior to this I don’t have this issue. This problem happen because I re-install the OS of the remote server.

To fix the error simply editing “/root/.ssh/known_hosts” in the local server. You just need to remove the reference of the remote server. After saving the file the error should be gone.

Another method to fix is just by deleting “/root/.ssh/known_hosts” file

Working With MySQL Database and Microsoft Excel

Microsoft Excel is a very good software for working with a large amount of data. It has many powerful features for data manipulating.

It is very beneficial to work with MySQL database within Microsoft Excel. Fortunately, Oracle the creator of MySQL has Microsoft Excel plugin.

MySQL for Excel enables you to work with a MySQL database from within Microsoft Excel. MySQL data can be imported into Excel, Excel data can be exported into MySQL as a new table or appended to a current table, and MySQL for Excel enables you to edit the MySQL data directly from within Excel.

To use this plugins make sure you white-list your IP in remote MySQL option.

To download this FREE plugin browse to

http://dev.mysql.com/downloads/windows/excel/

Manual for MySQL for Excel can be found in this page

http://dev.mysql.com/doc/refman/5.5/en/mysql-for-excel.html