So i'm writing some internet software using C++ and MySQL. I realize that because of the flexability of MySQL, I can actually run the software as a distributed system with very few changes. The client programs will be communicating directly with the MySQL server. They will all log in under one username and will only be able to perform INSERT and UPDATE actions on the database. (I might change this policy later.) I'm using the MySQL C API and it works pretty well so far. I have a couple questions, however: 1.) Are passwords transmitted in plain text? This simply won't do because it would allow someone to use a console and log into my server. 2.) Is it even worth thinking about trying to write a distributed app with MySQL? What things can I do to secure the database and keep it from harm? What types of vulnerabilites are there? This is a side project for entertainment and nothing more. I code in my spare time. I'm willing to hear your input. Thanks.