mysql

Configure Character set and Collation for Mysql 5.6.

November 9, 2015 Admin 0

Configure Character set and Collation for Mysql 5.6. # vi /etc/my.cnf [client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock symbolic-links=0 character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake init-connect=’SET NAMES utf8′ […]

mariadb-200x140

Commands to manage Mariadb.

September 11, 2015 Admin 0

1) View definers. MariaDB [(none)]> SHOW PROCEDURE STATUS; 2) Update definers. MariaDB [(none)]> UPDATE `mysql`.`proc` p SET definer = ‘root@%’ WHERE definer=’admin@%’; Query OK, 4 […]

postfix-spf-dkim

How to install SPF for Postfix.

September 1, 2015 Admin 0

1) Introduction This guide explains how to install and integrate Sender Policy Framework (SPF)checking with Postfix. SPF is an e-mail anti-forgery technology the enables domain owners to […]

tinydns

Install DJBDNS On FreeBSD

August 31, 2015 Admin 0

tinydns is a powerful and secure DNS server on FreeBSD. 1) Install djbdns # cd /usr/ports/dns/djbdns # make install clean 2) Create new user. # […]

dhcp_server

Install DHCP Server on FreeBSD

August 31, 2015 Admin 0

The Dynamic Host Configuration Protocol (DHCP) is a network service that enables host computers to be automatically assigned settings from a server as opposed to […]

1 2 3