how can i disable remote access of mysql??

August 18, 2015 8.6k views
MySQL Security

i want to disable mysql access from any remote server
it should not be used externally and also suggest how can i increase the security of mysql database

1 Answer

Did you enable remote access previously? Remote access is disabled by default. Changing bind-address in your /etc/mysql/my.cnf file to 127.0.0.1 will ensure that the MySQL server is not listening on any public interfaces and is only accessible by localhost.

bind-address=127.0.0.1
Have another answer? Share your knowledge.