mysql - Setup SSL on remote MySQL server for mobile app
问题描述
I am new to setting up SSL certificates on servers and would need some help to secure a MySQL database connection. I have a simple mobile app (client) which needs to connect to a remote MySQL database (server) connection. I am using AWS EC2 for the remote server and I have installed Let's Encrypt SSL certificates on a domain that I am hosting there. The machine runs on Ubuntu 18.04 and NGINX.
The same server also runs a MySQL database and I want to connect to it securely using a mobile app client. How can I encrypt the connection between the mobile app aclient and the MySQL database server?
I do have a static ip address for the database server but I am unable to install SSL certificates on the ip address directly. Only the domain name has an associated SSL certificate.
I did some digging around but was unable to find anything that serves my purpose. Any suggestion or reference to an article would greatly help.
解决方案
本文提供了用于保护远程 MySQL 数据库服务器和客户端之间的连接的详细分步过程。
推荐阅读
- vue.js - vue mixin 在实例和组件之间共享
- javascript - Websocekt 连接在 Internet Explorer 11 中不起作用
- python - 在 boost::python::import("cv2") 上得到异常 boost::python::error_already_set
- react-native - 为什么 API 密钥身份验证在使用 Crypto-JS 的 Coinbase Pro 上不起作用？
- android - 使用改造显示 responsejavax.net.ssl.SSLHandshakeException 错误android
- c# - 当我为目录设置LastWriteTime 时，会发生异常，因为“文档正在由另一个进程处理”
- python - 如何使用 setText 设置和获取“评论”文本？
- python - 从 csv 文件中删除字母和符号 - python 3.7
- javascript - HexString 到 Base64 到 PDF 不适用于 Internet Explorer (JavaScript)
- python - 如何编辑 django 表单错误消息的 css？