You can create them using the mysql_ssl_rsa_setup script. Next, you will need to generate SSL/TLS certificate and key file in your server. Now, exit from the MySQL shell with the following command: Threads: 2 Questions: 15 Slow queries: 0 Opens: 147 Flush tables: 3 Open tables: 66 Queries per second avg: 0.137Īs you can see, the SSL connection is not in use in the current connection. You can also verify the current connection status with the following command: | performance_schema_show_processlist | OFF |Īs you can see, both have_openssl and have_ssl values are disabled. Once you are logged in, run the following command to check the SSL/TLS status: To do so, log in to MySQL with the following command: Check MySQL SSL/TLS Statusįirst, you will need to verify whether the SSL/TLS is enabled in MySQL. Reload privilege tables now? (Press y|Y for Yes, any other key for No) : YĪt this point, MySQL is secured, and the root password is set. Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y Remove anonymous users? (Press y|Y for Yes, any other key for No) : Yĭisallow root login remotely? (Press y|Y for Yes, any other key for No) : Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 0ĭo you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : Y You will be asked several questions as shown below: Press y|Y for Yes, any other key for No: Y Run the following command to set the MySQL root password: So it is recommended to set the MySQL root password for security reasons. Systemctl enable mysql Set a MySQL Root Passwordīy default, the MySQL root password is not set. Next, start the MySQL service and enable it to start at system reboot: systemctl start mysql Run the following command to install it.Īfter the installation, verify the installed version of MySQL using the command below: Install MySQL 8 Serverīy default, MySQL server version 8 is included in the Ubuntu 20.04 default repository. Ě root password is set up on your server.This tutorial will show you how to secure MySQL connections with SSL/TLS on Ubuntu 20.04.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |