Archive for September 2017

Mysql number of tables in DB

Posted on September 22, 2017, 12:56 pm, by admin, under mysql.

SELECT COUNT(*) FROM information_schema.TABLES WHERE table_schema = ‘databasename’;

No Comments | Read the rest of this entry »

Mysql create utf-8 database

Posted on September 19, 2017, 2:57 pm, by admin, under mysql.

Former practice: CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci; Current practice: CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

No Comments | Read the rest of this entry »

Postfix localhost IP address only bind configuration

Posted on September 11, 2017, 11:51 am, by admin, under mail.

Open /etc/postfix/main.cf file: bash# vi /etc/postfix/main.cf Append / modify line as follows to bind to localhost (127.0.0.1) only: inet_interfaces = 127.0.0.1 Type the following to restart Postfix: bash# /etc/init.d/postfix restart

No Comments | Read the rest of this entry »