Limit MySQL to localhost only - xampp

Question

i'm hosting some smaller sites/gameservers on a windows server 2008 R2, and now i can see in my connection log that the database is used more than just local hosted stuff, so i want to limit my mysql to localhost only, and i know by doing that i will not be able to use my "Mysql Control Center" but that is why Xammp is here, there have been "PhpMyAdmin" on it from day one. But how do i make the settings so it is only localhost? and my www.mysqlhostsite.com/phpmyadmin.

Things i got:

Windows server 2008 R2
Mysql
Phpmyadmin
xampp

Solution

You can limit connections from a specific address (e.g. localhost) with the bind-address option. Configure this in your my.ini file:

[mysqld]
bind-address = localhost

Alternatively, you can force MySQL to use named pipes (a local-only method for connecting):

[mysqld]
bind-address = localhost
skip-networking
enable-named-pipe

Of course, restart the MySQL Service after editing my.ini.