資料庫

一、mysql
      cd /usr/ports/databases/mysql50-server
      make WITH_CHARSET=big5 WITH_XCHARSET=all install clean
      cd /usr/ports/databases/php5-mysql
      make install clean
      
      vi  /etc/rc.conf
      mysql_enable="yes"
      /usr/local/etc/rc.d/mysql-server start
      
      設定sql
      /usr/local/bin/mysql mysql
     Update user SET password=password('XXXXXXXXXX') where user='root';
     FLUSH PRIVILEGES;
    

二、PostgreSQL
      cd /usr/ports/databases/postgresql82-server
      make install clean
      cd /usr/ports/databases/php5-pgsql
      make install clean
      
      vi  /etc/rc.conf
      postgresql_enable="YES"
      ...

查看更多...

Tags: 資料庫資料庫