MySQL Basics Practice Test: Secure Connections — Flashcards

MySQL uses SSL/TLS to secure connections, and you can also use self-signed certificates.

Here are some steps you can take to secure a MySQL connection:
Configure the database with best practices for securing a MySQL database
Add --ssl-mode to the MySQL Login
Create a new remote user
Allow remote connections
Restrict remote connections
Test remote SSL connections 

Here are some best practices for securing a MySQL database:
Remove default accounts, port mappings, and other settings
Restrict remote access
Grant users only the privileges they need
Use non-root accounts
Keep the server physically secure
Make sure you keep proper auditing and monitoring
Assess your database security regularly
Authenticate and encrypt both local and remote connections
Use the latest TLS protocols
Use secure authentication methods
Encrypt binary log files and relay log files
Do not permit the use of symlinks to tables