Prashanth Goriparthi

As a good measure install all updates to this CentOS 6 server. Before you continue further. This step is optional.

Postgres Repo:

pgdg is the repo that postgresql can be downloaded and installed from. Here is where you download it from. Identify which version of rpm you want to download for installing PostgreSQL database server. Right now I am picking PostgreSQL 9.2 for CentOS [CentOS 6 – x86_64] as this is the latest version at this time. Now that we have identified which version we want to download, right click on that hyperlink and click "copy link address".

January 9, 2013 Prashanth Goriparthi 5

Passwordless authentication using mysql_config_editor with MySQL 5.6

Standard

This post elaborates how to use passwordless authentication using mysql_config_editor with MySQL 5.6. The mysql_config_editor utility is available for production use as of MySQL 5.6.6 [Technically 5.6.10 since its first cut GA of MySQL 5.6 server]. This utility enables you to store authentication credentials in an encrypted login file named .mylogin.cnf. Running this utility creates a file named .mylogin.cnf file in %APPDATA%\MySQL directory on Windows and the current user’s home directory on non-Windows systems such as Redhat EL6/CentOS/Fedora/Ubuntu. The file is read later by MySQL client programs to obtain authentication credentials for connecting to MySQL Server.mysql_config_editor encrypts .mylogin.cnf unlike its predecessor .my.cnf file so it cannot be read as clear text and supposedly contents after decrypted are only used in memory. If you have access to the system where you have stored these passwords then you can print them, except password is not visible.

January 8, 2013 Prashanth Goriparthi 68

How to Install MySQL 5.6 on CentOS 6.3/RedHat EL6/Fedora

Standard

First head over here and download MySQL 5.6.14 rpm’s under Oracle & Redhat Linux 6 section of rpm’s.

You want to download these rpm’s to your CentOS 6 server [As we will install 64bit version on MySQL 5.6] :

Red Hat/Oracle Enterprise Linux ver. 6 (x86, 64-bit), RPM Package – MySQL Server : MySQL-server-5.6.14-1.el6.x86_64.rpm
Red Hat/Oracle Enterprise Linux ver. 6 (x86, 64-bit), RPM Package – Shared components : MySQL-shared-5.6.14-1.el6.x86_64.rpm
Red Hat/Oracle Enterprise Linux ver. 6 (x86, 64-bit), RPM Package – Client Utilities : MySQL-client-5.6.14-1.el6.x86_64.rpm

To download on command line [Make sure that you have wget utility installed, if not install it :

December 2, 2012 Prashanth Goriparthi 50

How to Install CentOS 6.3 Linux in Oracle VirtualBox/SSH access/Port forwarding

Standard

For installing this flavor of Linux I am going to use Cent OS 6.3 x86_64 minimal version [Don’t be fooled by its name "minimal"] and Oracle Virtual box 4.2.6 x86. These are the current releases of both softwares.What do you need for this:

October 9, 2012 Prashanth Goriparthi 2

psqlrc : psql startup file for postgres

Standard

The ~/.psqlrc file determines the behavior of psql interactive command line client. Just like bashrc, psql client utility attempts to read and execute commands from the system-wide psqlrc file and the user’s ~/.psqlrc file before starting up. (On Windows, the user’s startup file is named %APPDATA%\postgresql\psqlrc.conf.)

July 10, 2012 Prashanth Goriparthi 0

How to Install MySQL 5.5 on CentOS 6.3/Redhat EL6/Fedora

Standard

First head over here and download MySQL 5.5.30 [Can be any minor version, I have this as this is latest when I was writing this post] rpm’s under Oracle & Redhat Linux 6 platform section of rpm’s.You want to download these rpm’s to your CentOS 6 server [As we will install 64bit version on MySQL 5.5] :