Home / SIDU

    How to install databases

    2013-01-01 00:00
    889536   2   2

    You need to check official websites as howto. Here is a quick guide for ubuntu users as howto install Apache2+PHP5, MySQL, PostgreSQL, SQLite, CUBRID, MSSQL

    A. Install apache2+php5: windows xampp; ubuntu:
    sudo apt-get install apache2 php5 libapache2-mod-php5 php5-gd

    B1. Install MySQL database and php driver: [optional]
    sudo apt-get install mysql-server mysql-client php5-mysql

    B2. Install PostgreSQL database and php driver: [optional]
    sudo apt-get install postgresql php5-pgsql
    Setup password for user postgres via terminal
    sudo -u postgres psql ## login via cmd
    \password postgres ## input new password twice
    \q ## exit psql

    B3. Install php driver for SQLite: [optional]
    sudo apt-get install php5-sqlite

    B4. Install CUBRID database and php driver: [optional]
    sudo add-apt-repository ppa:cubrid/cubrid
    sudo apt-get update
    sudo apt-get install cubrid php5-cubrid cubrid-demodb
    You need to start db each time on use:
    cubrid server start demodb

    B5. Install Microsoft SQL Server (MSSQL): [optional]
    sudo apt-get install freetds-common freetds-bin unixodbc php5-sybase

    C. Restart apache server: ubuntu
    sudo service apache2 restart
    Back « SIDU Support and Help Desk
    Next » Optional sidu_fk table


    Leave a commentEdit comment