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 ```

Accepted Answer

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.

Limit MySQL to localhost only - xampp

Solution

Problem