Remote Access & Code articles

Remote Access & Code 1,354 Connecting to your MySQL database with MySQL Workbench MySQL Workbench is a program you install on your own computer to work on a database the way you would work in a...
Remote Access & Code 1,541 Remote access to PostgreSQL: what works and what does not PostgreSQL runs on our servers, cPanel carries its tools, and a PHP website can talk to it. There are two things to...
Remote Access & Code 1,185 Connecting to MySQL from PHP: mysqli and PDO, with a working example PHP has two ways of talking to the database: mysqli (MySQL and MariaDB only) and PDO (which also serves PostgreSQL...
Remote Access & Code 1,539 Connecting to your database from Python and Node.js In Python use PyMySQL (or mysql-connector-python); in Node.js use mysql2. In both the host is localhost, the...
Remote Access & Code 938 Letting an outside address reach your MySQL: Remote MySQL in cPanel cPanel has a tool called Remote MySQL, where you type the IP address of whoever may connect to your database. There...
Remote Access & Code 965 Reaching MySQL or PostgreSQL through an SSH tunnel, step by step The database ports (3306 for MySQL, 5432 for PostgreSQL) are not open from outside. An SSH tunnel solves that: it...
Remote Access & Code 1,073 Allowing remote PostgreSQL connections on a VPS, safely By default PostgreSQL listens only on 127.0.0.1. Accepting connections from outside takes three adjustments: tell it...