Here, I’m attempting to explain how to install PostgreSQL & phpPgAdmin briefly and an attempt to perform database dump and restore; which should be a basic functionality but is not present in pgadmin. Here, I’m presuming that you already have a Linux machine with Ubuntu(likely v11.10) and installing the latest version of PostgreSQL(v9.1.1). Installation Steps… Continue reading Steps to install PostgreSQL, phpPgAdmin with PHP and managing PostgreSQL over Ubuntu 11.10
Category: Linux
How to change MySQL password on Ubntu 11.10
Here are the steps to change or reset or set your MySQL password on a Ubuntu 11.10 or Linux machines. 1. Stop the mysql server using the following command: sudo /etc/init.d/mysql stop 2. Start the mysqld demon process using the –skip-grant-tables option with the following command: sudo /usr/sbin/mysqld –skip-grant-tables –skip-networking & 3. Start the mysql… Continue reading How to change MySQL password on Ubntu 11.10
Steps to install Apache, MySQL, PHP, PhpMyAdmin over Ubuntu 11.10
Here is a brief description of installing the top most Web-Application developments tools for LAMP Technologies (Linux, Apache, MySQL, PHP). Here, I’m presuming that you already have a Linux machine with Ubuntu(likely v11.10). Steps to install Apache2 Server: sudo apt-get install apache2 Steps to install MySQL5 Client and Server: sudo apt-get install mysql-server mysql-client Steps to… Continue reading Steps to install Apache, MySQL, PHP, PhpMyAdmin over Ubuntu 11.10
Get IP address, gateway details, change gateway over Linux Machine
To get the IP address on a ubuntu machine we use the command:$ ifconfigTo get the gateway details, we use the command:$ route -nTo change the gatway, we use the following commands$ sudo route del default$ sudo route add default gw <new-gateway-address>Cheers.
VI Editor
To create or to open a file for editing [root@comp1 ~]# vi Example:- [root@comp1 ~]# vi fullreport To go to insert mode i – inserts the text at current cursor position r – replace a single char at current cursor position Commands at Execute Mode :q – quit without saving :q! – quit forcefully without… Continue reading VI Editor
Basic’s
To check the present working directory [root@comp1 ~]# pwd /root To see the contents of a directory (folder) [root@comp1 ~]# ls Options: -l Long list including attributes -a All files and directories including hidden -d To check for a particular file or directory -R Recursively, to see the contents in a tree structure To list… Continue reading Basic’s