If you have ssh service running, make sure you disable the root login. If you didnt disable the ssh root login, you are prone to brute force attack and once it breaks in, your server is owned. To prevent this happen, you can disable the root login thru the ssh. No worry, it’s not a very difficult task, just edit a line of configuration and restart the service then you are done.
Continue reading How to disable ssh root login? »
Tried to import a mysql innodb from a sql dump file, but it keep show me there is an foreign key constraint error. Due to innodb has foreign key check validation, it does not allow me to continue n show me foreign key constraint error. Ya! I know my data having some foreign key constraint problem, but what i need to do now is to import my sql dump file!
Here’s the error message “#1452 – Cannot add or update a child row: a foreign key constraint fails…”
After going thru the mysql documentation, finally i found the solution! This solution not only allow me to import my innodb, but also improve the import speed tremendously!
Continue reading How to import mysql innodb with foreign key constraint error? »
For Mac Keynote user to share their slide with Power Point user, you need to convert the keynote to Power Point. Luckily, Keynote come with the conversion feature that allow export the file to power point, pdf, quick time, flash, images and others. Just few clicks away, your keynote file will be easily converted to Power Point.
Continue reading How to convert Keynote (.key) to Power Point (ppt) »