2017-01-27 09:15 pm

Installing MariaDB Server in a FreeBSD 11



MySQL is a very fast, multi-threaded, multi-user and robust SQL database server. The latest version is located at /usr/ports/databases/mysql57-server/. MariaDB is a database server that offers drop-in replacement functionality for MySQL1. MariaDB is built by some of the original authors of MySQL, with assistance from the broader community of Free and open source software developers around the world. In addition to the core functionality of MySQL, MariaDB offers a rich set of feature enhancements including alternate storage engines, server optimizations, and patches. The latest version is located at /usr/ports/databases/mariadb55-server/. In this tutorial, you will learn how to install MariaDB server and create a databases, users, and grant sql rights using sql commands on a FreeBSD 10 or 11 server.

=> More info: How To Install MariaDB Databases on a FreeBSD v10/11 Unix Server
2017-01-27 04:51 pm

How to ppen a file in a tab in vim in readonly mode on Linux, MacOS and Unix system

Want to open a file in read-only mode on Unix, try:
vim -M file
OR open a tab in read-only mode:
: view file



More info: Open a file or a tab in vim in readonly mode
2017-01-26 04:20 pm

How To Fix SSH "WARNING: UNPROTECTED PRIVATE KEY FILE!" on Unix/MacOS/Linux

If you are getting this error then you probably reset the permissions on your keys:

chmod 0400 ~/.ssh/key
chmod 0700 ~/.ssh/
ssh -i ~/.ssh/key user@server




More info: Fixing ssh error.
2017-01-24 07:36 pm

Want to flush the content of memcached server using bash on Linux/Unix?



You type the following command to flush the content of memcached server:
echo flush_all >/dev/tcp/127.0.0.1/11211

=> More commands and options here about the same.
2017-01-24 05:02 pm
Entry tags:

curl ignore invalid ssl certificate warning



Want to ignore SSL warning with curl command on Linux/Unix/MacOS? Try:

curl -k url
curl -k -I url


More info: cURL Ignore SSL Certificate Warnings
2017-01-23 11:26 pm

The Awk Programming Language for all {PDF version}

AWK is a programming language designed for text processing and typically used for a data extraction and reporting tool. It is a standard feature of Linux, FreeBSD, OpenBSD, MacOS and most Unix-like systems.



Download: The AWK programming book (PDF version)
2017-01-23 05:26 pm

Directly attach screen/tmux over ssh session & save a useless parent bash process:

Run the following command:

ssh -t box screen -r
ssh -t box tmux a
ssh -t user@server screen -r
ssh -t user@server tmux a