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 Continue Reading…
List the listening ports and check if mysql is listed on it.
$ netstat -tln | grep mysql
If you cannot find the port number for mysql view my.cnf file to see if you can find the port number. If you see a line “skip-networking” try commenting out the line and then restart mysql daemon.
$ vi /etc/my.cnf[mysqld] set-variable=local-infile=0
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
skip-networking [mysql.server] user=mysql
basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log
$ service mysqld restart
There are different variants of Linux in the market like RedHat, Debian, CentOS, Ubuntu, Mandrake, Suse and a Linux beginner often ponder why they call Linux distributions by various names. The kernel or the heart of all the distributions is Linux and in bringing it to different market usage different community or vendors have adopted the kernel to serve that purpose.
To create a password file and to add users to it, use the command
$ htpasswd -cm /secured/.mypass username1
To add users to the already existing password file, use the command
$ htpasswd -m /secured/.mypass username2
When additional users are added to the password file, ensure that you don’t use the “-c” option.
Alias command comes handy when we are in need to make long and frequently used command string short.
To list the current set of aliases simply type
To display the set alias for a specified alias name, type
$ alias alias-shortstring
$ alias ls
To set an alias you use the format
$ alias shortstring = “linux command string”