To first start working with this database, the root password must be set. The word root does not apply to the system's root, but to the database administrator, however, it can be the same person. So let's set it and log in:
mysqladmin -u root password 'thepassword'
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 10 to server version: 5.0.20a-Debian_1-log
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
/etc/mysql/my.cnf
apt-get install php5
Installing and Configuring PHP
Now, add support for MySQL:
apt-get install php5-mysql
Just like for Apache and MySQL, extra packages will have to be install as well: apache2-mpm-prefork, libapache2-mod-php5 and php5-common.
The configuration file for PHP is located in /etc/php5/apache2/php.ini
every time you modify it, Apache must be restarted.
/var/www/information.php
Installing and Configuring Postfix
The default configuration files are in /etc/postfix, we will only use main.cf
STEP #1 – get pgAdmin
Install pgAdmin from pgadmin.org
STEP #2 – allow postgre server remote connections from everywhere
Open etc/postgresql/9.x/main/pg_hba.conf and add following line:
host all all all md5
STEP #3 – let the postgre server listen to everyone
Open etc/postgresql/9.x/main/postgresql.conf and change following line:
listen_addresses = ‘*’
STEP #4 – give the user “postgres” a password
Start the psql terminal: sudo -u postgres psql
Give a password: ALTER USER postgres PASSWORD ‘yourpassword';
Leave the psql terminal: \q
STEP #5
Restart postgre server by executing this terminal command:
sudo /etc/init.d/postgresql restart
STEP #6
Start pgAdmin and add a connection to a server like this: