Yeoman is a tool for modern workflow to aid front-end web application development. Yeoman consists of three tools to manage this workflow and has generators available for Angular, Backbone and a collection of over 100+ other projects

To find the collation of tables within MySQL database, you can use one of the commands listed below mysql> show table status from exampledb; mysql> SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA='exampledb';   To find the character set used in a MySQL table mysql> SELECT tbl.table_name, CCSA.character_set_name FROM information_schema.`TABLES` tbl, information_schema.COLLATION_CHARACTER_SET_APPLICABILITY CCSA WHERE CCSA.collation_name = tbl.table_collation AND tbl.table_schema = "schemaname";

To find the collation of a database mysql> SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = 'exampledb' LIMIT 1; +------------------------+ | DEFAULT_COLLATION_NAME | +------------------------+ | utf8_general_ci | +------------------------+   To find the characterset of a MySQL database mysql> SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = "exampledb";

Visudo is needed to make modifications to the sudoers file. In a fresh install of CentOS "sudoers" file is not normally found. To install visudo issue the command $ yum -y install sudo As a sys admin, you need to be careful when performing tasks with root privileges. To be cautious, you can create a new user and assign him with root privileges using "visudo" $ /usr/sbin/visudo # User privilege specification root ALL=(ALL) ALL test ALL=(ALL) ALL In the above file, test is a new user created with root privileges. In order for the "test" user to have root privileges, command "sudo" should be used. It prevents the user from issuing any commands that can cause system wide havoc and it also logs the command inside "/var/log/secure" for review

Changing host configuration $ vi /var/lib/pgsql/8.4/data/pg_hba.conf Add postgresql to startup process $ chkconfig postgresql-8.4 on Start postgresql service $ service postgresql-8.4 start Access postgresql $ su - postgresql $ psql Create database postgres-# create database test List databases postgres-# \list Exit postgresql postgres-# \q (or \quit) Connect to database postgres-# \c test (\connect test)

First lets do an update before we start installing PostgreSQL $ yum update You can install PostgreSQL from CentOS Base repo or can do a search for the latest version and install it based on your needs. Method 1 describes manual setup and Method 2 indicates an install from CentOS base repo (more…)