@sepdek's

The following set of shell commands are among the basic steps to setup a Linux-based web server (LAMP=Linux Apache MySQL PHP). The procedure has been tested on an Ubuntu 14.04.05 Trusty Tahr (LTS) installation. Most steps and procedures are based on the tutorial found in DigitalOcean and in the linked pages. In the commands that […]

Even though all default settings include “utf8-general-ci” every newly created database keeps getting that “swedish” collation and character set! So one way to convert to utf8 is to go table by table and type the SQL command: ALTER TABLE dbase.table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci where ‘dbase’ is the name of the database […]