![]() This database connection is not used for production, and I would recommend against using it in this way. I am using this as a means to query my database from another server. This would prevent a loss of connection in the event of a server reboot. I would also recommend creating a script to run the command at boot time. Here is a good post on how to install autossh: This post also assumes you have autossh setup on the server that will have remote client access to the MySQL server. ![]() See here for a good post on getting this setup: Digital Ocean This post assumes you have an understanding of ssh-keygen and setting up passwordless SSH access to your MySQL remote server. THE QUOTATION MARKS IN THIS DOCUMENT WILL BREAK THESE COMMANDS ON THE COMMAND LINE ![]() The intent of this post is to jog my memory, share my process, and offer some helpful code snippets and resources. ![]() Part 1: Examples of Remote MySQL SSL Connections Using PHP: MySQLi and PDO ![]() TLDR tunneling is far more efficient then MySQL over SSL. There are some helpful links in my first post referencing speed over SSL versus ssh tunneling. This is the second part of an evaluation into connecting to MySQL remotely and securely. By Kevin Johnson on Novem(updated November 30, 2018) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |