MySQL

Host multiple web sites securely with nginx, PHP-FPM and MySQL 8 on FreeBSD 12

October 31, 2020

This article focuses on providing security and isolation on a FreeBSD 12 web server hosting numerous websites. We use php-fpm and nginx to host each website in isolation by running it under its own user process instead of all websites running under the same process, which is much more common. The problem with the more […]

Kelly’s MySQL quick tutorial

September 20, 2016

| No Comments

| MySQL

You don’t need tools like MySQLAdmin when basic tasks like creating and deleting databases, adding users and adjusting permissions can easily be done from the command line. I run these commands on a FreeBSD system and is likely the same on Linux, Windows, and other systems. Basic tasks Log into mysql: #mysql –u root –p […]