18.19 MySQL Remote Host Access

Network access to a MySQL server under Debian is disabled by default for security reasons. You can enable it by commenting out the skip-networking option in /etc/mysql/my.cnf.

If you don’t allow such access then your local MySQL client will report:

  ERROR 2003: Can't connect to MySQL server on 'festival' (111)


Your donation will support ongoing development and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2021 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0.