Block MYSQL port for everyone except localhost

Here a code which we can block our mysql port for everyone except localhost.

Copy one field to another field in MYSQL

We can do update on any field from the table. But, many of times we had this question on our realtime life.Is there a way to copy one field to another field.

Here the below code will help you to make that funtionality happened.

Mysql alter Auto Increment field value

To Alter the table auto increment field. We can use below line of code.
This code is for only to alter. Not for intial set.