Mysql server has gone away - Fix

Mysql server has gone away – Fix

The MySQL server has gone away error can occur when you have an established connection to the MySQL server and for one reason or another, the connection times out or otherwise goes down. In the context of a Linux system, the error can sometimes be seen from the MySQL client. In this tutorial, we will show several solutions for dealing with and troubleshooting the MySQL error.

Read more

PostgreSQL installation on Ubuntu 22.04 Jammy Jellyfish

Ubuntu 22.04 PostgreSQL Installation

PostgreSQL is a database management system, similar to MySQL in many respects but with some key differences. Like MySQL, it’s commonly hosted on Linux. In this guide, we’ll show how to run a PostgreSQL server on Ubuntu 22.04 Jammy Jellyfish, as well as installing the client version in case you just need to connect to an external PostgreSQL database.

Read more

Allowing MySQL connections through firewall and creating a new user that allows connections from all hosts

MySQL: Allow all hosts

If you wish to access your MySQL server remotely, it will be necessary to configure one or more users to allow access from remote hosts. If you do not know all the IP addresses of the connecting hosts, then you can simply allow connections from all hosts.

Read more