How do I change the `bind-address` in MariaDB?

Responsive Ad Header

Question

Grade: Education Subject: Support
How do I change the `bind-address` in MariaDB?
Asked by:
46 Viewed 46 Answers

Answer (46)

Best Answer
(318)
To change the `bind-address`, edit the MariaDB configuration file (usually `my.cnf` or `my.ini`). Locate the `bind-address` line and change its value. After modifying the file, restart the MariaDB server for the changes to take effect. For example: `sudo systemctl restart mariadb` or `sudo service mariadb restart`.