GRANT ALL PRIVILEGES ON *.* TO cocon@wkstn03.cocon.localcoconstyle.com IDENTIFIED BY 'passcocon' WITH GRANT OPTION; UPDATE user SET Password = OLD_PASSWORD('passcocon') WHERE Host = 'wkstn03.cocon.localcoconstyle.com' AND User = 'cocon'; W…

http://usednote.seesaa.net/article/37313781.html

cd /home/svn/svnadmin create ./idg-frontsvn mkdir file:///home/svn/idg-front/trunk file:///home/svn/idg-front/tags file:///home/svn/idg-front/branches -m 'Create trunk, tags, and branches.'chown -R apache.apache ./idg-front http://210.188.…

select date_format(create_date,'%y/%m/') dates, count(*) id from access_log group by dates order by dates;SELECT create_date FROM access_log WHERE TO_DAYS(NOW()) - TO_DAYS(create_date) SELECT COUNT(*) FROM access_log where create_date + da…

Linux MD5パスワード生成 echo -n 'pass' | md5sum

負荷対策 http://gigazine.net/index.php?/news/comments/20060601_loadavarage/ http://yamashita.dyndns.org/blog/107/ Trac http://demdem.cocolog-nifty.com/blog/2006/08/subversiontrac_2b5f.html http://blog.denden-cafe.com/blog/trac/index.html

usr/bin/htpasswd ./dav_svn.passwd idg-developer

//MySQL /etc/rc.d/init.d/mysqld stop /etc/rc.d/init.d/mysqld start //設定ファイル /etc/my.cnfデータディレクトリ /var/lib/mysql