Page 129 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

FLUSH PRIVILEGES;

5 Bind MySQL to LocalHost
Edit the MySQL configuration file (my.ini or my.cnf) to bind MySQL to localhost:
bind-address = 127.0.0.1
6 Enable the Firewall

Open the Windows Firewall and create an inbound rule to allow traffic on the MySQL port (default is 3306).

7 Install and Use SSL/TLS
For additional security, consider configuring MySQL to use SSL/TLS. This involves obtaining SSL certificates and
modifying the MySQL configuration.
8 Regularly Update MySQL
Stay updated with the latest MySQL releases to ensure that you have the latest security patches.
Questions
1 How do you secure the MySQL root account?

2 How do you grant SELECT privileges to a user for a specific database?

114
CITS : IT & ITES - Computer Software Application - Exercise 35