MySQL is a popular database engine in LAMP environments. This guide shows how to install MySQL Server 5.7 on Ubuntu 16.04 and manage its service with systemctl.
MySQL is probably the most popular database engine and, together with Apache and PHP on Linux, forms what is commonly called a LAMP server.
In this post we will see how to set up a MySQL Server 5.7 database server on Ubuntu 16.04. Continue reading “Install MySQL 5.7 on Ubuntu 16.04 and derivatives”
The NVL function in Oracle returns an alternative value when an expression is NULL.
It is useful in queriis where we do not want to displaand emptand fields, for example in reports, lists, or simple calculations.
When a container fails or gets stuck, it is better to check its logs first and restart only the affected service, not the whole application.
Continue reading “View logs and restart a service with Docker Compose”
Ollama lets you run local AI models on the machine itself or expose its API so other computers on the network can use it.
Continue reading “Install Ollama on Ubuntu and allow connections from another machine”
To use an NVIDIA GPU inside a VM, Proxmox must be able to pass the whole card through to the guest by using PCI passthrough.
Continue reading “Pass an NVIDIA GPU to a VM in Proxmox 9 for local AI”
If you are going to run AI models locally on Ubuntu 22.04, 24.04 or 26.04, the first step is making sure the system detects the NVIDIA card correctly.
Continue reading “Prepare Ubuntu 22.04, 24.04 and 26.04 with NVIDIA for local AI”
