Remote Access & Code articles

Remote Access & Code 293 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 338 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 261 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 298 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 236 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 250 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 229 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...