Personal tools
You are here: Home Ressources Installation Apache - mySQL - PHP - PostGres
Document Actions

Installation Apache - mySQL - PHP - PostGres

by François Rioult last modified 2008-09-14 02:58
# apt-get install apache2

Pour pouvoir gérer les sites personnels, ajouter dans /etc/apache2/apache2.conf
# gestion des sites personnels dans ~/public_html
Include /etc/apache2/mods-available/userdir.load
Include /etc/apache2/mods-available/userdir.conf

Installation gd pour PHP
libgd2-xpm (version 2.0.34-1ubuntu1.1) will be installed
php5-gd (version 5.2.3-1ubuntu6.3) will be installed


# apt-get install mysql-server-5.0
# apt-get install php5-mysql
# apt-get install phpmyadmin # accès par 127.0.0.1/phpmyadmin

# mysql
> create database frioult_bd;
> GRANT ALL PRIVILEGES ON frioult_bd.* TO 'frioult'@'localhost' IDENTIFIED BY 'toto';
> use mysql;
> select user, host, password from user;
+------------------+-----------+------------------+
| user | host | password |
+------------------+-----------+------------------+
| root | localhost | |
| root | petiquick | |
| debian-sys-maint | localhost | 1ae9ccbb34df1d4c |
| frioult | localhost | 3c90ae60272fb624 |
+------------------+-----------+------------------+
$ mysql -ufrioult -hlocalhost -ptoto frioult_bd
> SET PASSWORD = PASSWORD('...');

redémarrer appache2 :
# /etc/init.d/apache2 restart


Postgres

  • apt-get install postgresql (8.3)
  • fichier de configuration  /etc/postgresql/8.3/main/postgresql.conf port = 5432
  • apt-get install postgresql-client
  • apt-get install pgadmin3 : GUI
  • su postgres -c psql puis ALTER USER postgres WITH PASSWORD 'Z89ther2';
  • effacer le pass de postgres : passwd -d postgres
  • su postgres -c passwd -> saisir nouveau pass
  • tout sur http://www.ubuntugeek.com/howto-setup-database-server-with-postgresql-and-pgadmin3.html


« June 2011 »
Su Mo Tu We Th Fr Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30
 

Powered by Plone, the Open Source Content Management System

This site conforms to the following standards: