Progress no. 1748893165
Last Friday, May 30, 2025, after work, I wanted to see if I could create an MySQL outside my network and connect to that server securely using SSL/TSL. I was only partially successful and abandoned the project due to I ran out of time set for the project (Sunday, June 1, 2025, 6:00 PM PDT). I do not know if the issue was due to the different versions of MySQL I was using, but I could not establish a connection between the two MySQL servers. When I tried to connect using SSL, the command prompt would show the OS prompt after entering my MySQL password, and would not complete the log in process to the MySQL prompt. I was able to log in locally using the user I was using for testing with “REQUIRE SSL” on the user account. Also, I read that any application using the user using SSL will also require to be updated, or else the connection will fail. So I have a lot of testing to do to verify everything is working before implementing for production, so for now, this project will go on the future project queue.
In the future, I will try using identical systems. For now, I will keep my Web server and DB server within the same network, so no unencrypted traffic will traverse over the Internet.