VPS Guide: Your Go-To for VPS, Ubuntu & Command Line Success

Restrict MySQL Access on Debian VPS

Category: Security

Secure MySQL—a database engine—on a Debian VPS—edit /etc/mysql/my cnf:

bind-address = 127.0.0.1

restart:

systemctl restart mysql

On Hetzner test with

mysql -u root -p -h 127.0.0.1

—expect local-only access Ensures security—locks phpMyAdmin DB in VPS hosting to localhost