December 2021Monthly Archives

Step:1 – Deny all hosts deny all incoming SSH connections Open file /etc/hosts.deny by using a text editor:  vi /etc/hosts.deny Add the following line to deny all incoming SSH connections to the server:  sshd: ALL Save and close the file. Step:2 – Allow IP Address Open the file /etc/hosts.allow file by using a text… Continue Reading Restrict SSH login to a specific IP or host

To disable foreign key constraints when you want to truncate a table: Use FOREIGN_KEY_CHECKS and remember to enable it when you’re done:

This website stores cookies on your computer. These cookies are used to provide a more personalized experience and to track your whereabouts around our website in compliance with the European General Data Protection Regulation. If you decide to to opt-out of any future tracking, a cookie will be setup in your browser to remember this choice for one year.

Accept or Deny