Category: hosting
-
Howto create a MariaDB database and user with UTF8mb4
Reference
-
How to download a file from a remote Linux server via SCP in Windows using Cmder
If you’re working on Windows and you need to grab a file from a remote Linux server over SSH, make sure you use Cmder. Once you have Cmder extracted, you can use the Linux command line SCP directly from Windows: You can use this shortcut if you’ve already setup your SSH agent. There is unexplained…
-
How to manually kill a MariaDB process
Thanks to Wojtek Dmyszewicz on StackOverflow for saving me time and frustration when I ran into [ERROR] InnoDB: Unable to lock ./ibdata1, error while working with MariaDB at the command line. The solution is to list all currently running MariaDB processes, which call themselves ‘mysql’ for compatibility with MySQL: This will output some results, such…
-
Setting up a WordPress site using EasyEngine 3.7
Creating WordPress sites on a $5/month VPS such as DigitalOcean with EasyEngine is incredibly rapid. Installing EasyEngine is a single command and then setting up a WordPress site with the following features is another single command.
-
SSL A rating with SSL Labs
I was getting a B rating when testing my newly Let’s Encrypted site with Qualys SSL Labs. The solution was to add a strong DH group to NGINX – here’s how to do it.