-
Compile Spawn-FCGI (PHP5) & MySQL for Nginx
This tutorial guide shows how to install MySQL & PHP compiled with Spawn-FCGI to work with the Nginx web server and to start automatically on reboot.
» tutorial » Install PHP with Spawn-FCGI for Nginx -
Compile PHP-FPM (PHP5) & MySQL for Nginx
Perfect & UP-TO-DATE how-to compile guide! Add PHP-FPM with MySQL for Nginx on Debian/Ubuntu with the best configuration extension options explained.
» tutorial » PHP-FPM & MySQL on Nginx -
Add a DB with Full Permissions
Here’s the MySQL syntax to add a new database from the terminal command line. It’s commonly required as part of a new site or content platform setup.
» tutorial » Setup MySQL Database -
PHP5 (with FastCGI) and MySQL
Install PHP for server-side web applications, configured with FastCGI, adding MySQL for your databases .. tweaking the lot for optimum performance.
» tutorial » Install PHP5 with FastCGI -
Reset a Lost MySQL Password
Locked yourself out of MySQL? Feels like leaving the car keys in the trunk, huh?
» tutorial » Unlock MySQL & Refresh Forgotten Password
Sorry to laugh! But I can .. and show you how to get back in. -
Update (Replace or Delete) MySQL Data
Change repetitive db data with one single syntax command. Rather than manually find & alter each instance, isolate the lot & update multiple content.
» tutorial » Manipulate MySQL Data -
Reinstate MySQL DBs with Terminal Shell
Here’s the syntax for reinstating a MySQL database. For instance, you moved a site, added a blank db and now want to add your backed up data. Easy!
» tutorial » Adding & Import Data to a DB -
Backup a MySQL Database from the Terminal
This guide shows how to save a MySQL database using a terminal, with a simple syntax command. And faster than using phpMyAdmin, for sure.
» tutorial » Export DBs using the CLI -
Create or Bin MySQL DBs using the Terminal
This how-to guide maps out two basic but handy MySQL operations, creating and erasing a database, using the command line interface.
» tutorial » Adding & Deleting DBs from the CLI
