April 11, 2008
FreeBSD & Linux
No Comments
(117 views)
# cd /usr/ports/databases/mysql51-server
# make make WITH_CHARSET=utf8 WITH_XCHARSET=all WITH_COLLATION=utf8_unicode_ci
# make install && make clean
# mysql_install_db (/usr/local/bin/mysql_install_db)
# chown -R mysql /var/db/mysql/
# chgrp -R mysql /var/db/mysql/
# /usr/local/bin/mysqld_safe -user=mysql &
edit /etc/rc.conf
add this
mysql_enable="YES"
Change the password to root user
# /usr/local/bin/mysqladmin -u root password new-password
Optionally, copy either my-huge.cnf, my-large.cnf, my-medim.cnf, my-small.cnf or my-innodb-heavy-4G.cnf (depending on the usage and utilization of MySQL server) as my.cnf
to /var/db/mysql which will enable you to tweak and change the configuration of server-specific MySQL server options by editing the file.
April 10, 2008
FreeBSD & Linux
No Comments
(97 views)
# nano /boot/loader.conf
add the following line into
accf_http_load="YES"
February 24, 2008
FreeBSD & Linux
No Comments
(120 views)
SetEnvIf Remote_Addr "::1" dontlog
CustomLog /var/log/apache2/access.log combined env=!dontlog
January 25, 2008
FreeBSD & Linux
No Comments
(153 views)
# nano /usr/local/etc/proftpd.conf
Allow CHMOD
# Bar use of SITE CHMOD by default
< Limit SITE_CHMOD >
AllowAll
# DenyAll
< /Limit>
January 24, 2008
FreeBSD & Linux
No Comments
(148 views)
Search
# cd /usr/ports/
# make search name=php5-mysql | less
Install
# make install clean
Deinstall
# make deinstall clean
January 24, 2008
FreeBSD & Linux
No Comments
(169 views)
สั่ง update ports index
# cd /usr/ports
# /usr/local/bin/cvsup -g -L 2 -h cvsup.th.FreeBSD.org /usr/share/examples/cvsup/ports-supfile
# make fetchindex
ตรวจสอบเวอร์ชั่นของ software ที่ลงในเครื่องกับ เวอร์ชั่นปัจจุบัน
# pkg_version -v