{"id":902,"date":"2012-11-27T09:43:55","date_gmt":"2012-11-27T01:43:55","guid":{"rendered":"http:\/\/blog.hoyo.idv.tw\/?p=902"},"modified":"2019-04-08T13:25:04","modified_gmt":"2019-04-08T05:25:04","slug":"freebsd-9-%e5%ae%89%e8%a3%9d%e5%8f%8a%e8%a8%ad%e5%ae%9a","status":"publish","type":"post","link":"https:\/\/blog.hoyo.idv.tw\/?p=902","title":{"rendered":"FreeBSD 9 \u5b89\u88dd\u53ca\u8a2d\u5b9a"},"content":{"rendered":"<p>\u9019\u7bc7\u5f88\u9577\u5f88\u9577\u5f88\u9577........... \u4e09\u5e74\u6c92\u6709\u4f7f\u7528 FreeBSD \u4e86\uff0c\u518d\u6b21\u4f7f\u7528\u6709\u7a2e\u6709\u9ede\u719f\u53c8\u4e0d\u6703\u592a\u719f\u7684\u611f\u89ba :-| \u00a0\u771f\u662f\u6158 :oops:<\/p>\n<p>\u6240\u4ee5\u6211\u6c7a\u5b9a\u4e00\u6b65\u4e00\u8173\u5370\u91cd\u65b0\u7d00\u9304\uff0c\u4e26\u4e14\u628a\u4ee5\u524d\u6a21\u7cca\u4e0d\u6e05\u7684\u89c0\u5ff5\u641e\u61c2\u3002\u5982\u679c\u525b\u597d\u4f60\u4e5f\u6709\u9019\u4e9b\u554f\u984c\u5e0c\u671b\u53ef\u4ee5\u6709\u4e9b\u5e6b\u52a9\u3002<\/p>\n<p>\u672c\u7bc7\u72c0\u614b\uff1a<strong>\u672a\u5b8c<\/strong>\u3002<\/p>\n<h2>\u786c\u9ad4\uff1a<\/h2>\n<ul>\n<li>CPU : AMD FX-8150<\/li>\n<li>BOARD : ASUS SABERTOOTH 990FX<\/li>\n<li>RAM : DDR3 1600 8GB * 4<\/li>\n<li>RAID : HighPoint RocketRAID 2310<\/li>\n<li>HD : \u00a0WD \u4f01\u696d\u786c\u789f 2TB * 3<\/li>\n<li>Network : Intel PRO\/1000 PT<\/li>\n<\/ul>\n<div>\u70ba\u4e86\u5b8c\u6574\u4f7f\u7528\u8a72\u786c\u9ad4\u8a2d\u5099\u5fc5\u9808\u8003\u91cf\u4ee5\u4e0b\u5e7e\u9ede\uff1a<\/div>\n<div>\n<ul>\n<li><span style=\"color: #333333; font-style: normal; line-height: 24px;\">\u5fc5\u9808\u4f7f\u7528 x64 \u4f5c\u696d\u7cfb\u7d71\u624d\u80fd\u5229\u7528<\/span>\u00a032GB \u8a18\u61b6\u9ad4<\/li>\n<li>\u7cfb\u7d71\u5fc5\u9808\u57f7\u884c\u904b\u4f5c\u5728 RAID \u74b0\u5883\u4e0a\uff0c\u652f\u63f4\u7684 OS \u662f FreeBSD<\/li>\n<li>\u77ad\u89e3\u78c1\u789f\u9663\u5217\u707d\u96e3\u5fa9\u539f\u6d41\u7a0b<\/li>\n<li>FreeBSD \u904b\u4f5c\u5728 Server \u57fa\u672c\u4e0a\u53ea\u8981\u786c\u789f\u3001\u7db2\u8def\u5361\u9019\u5169\u500b\u652f\u63f4\uff0c\u986f\u793a\u53ea\u8981\u6b63\u5e38\uff0c\u5176\u4ed6\u5c31\u96a8\u4fbf\u4e86<\/li>\n<\/ul>\n<\/div>\n<div><\/div>\n<h2>\u8edf\u9ad4\uff1a<\/h2>\n<ul>\n<li>FreeBSD 9.0 x64<\/li>\n<li>RocketRAID\u00a0RAID Management\/ Inband Service <strong>Web GUI<\/strong><\/li>\n<li>\u5f88\u591a\u5f88\u591a\u7684 \/usr\/ports\/<\/li>\n<\/ul>\n<h2>HighPoint RocketRAID \u7684\u8a2d\u7f6e<\/h2>\n<ol>\n<li>\u5728\u4e3b\u6a5f\u677f\u4e0a\u4f7f\u7528 SATA \u9023\u63a5\u4e00\u9846\u7368\u7acb\u786c\u789f<\/li>\n<li>BIOS \u8a2d\u5b9a\u5149\u789f\u958b\u6a5f<\/li>\n<li>\u4f7f\u7528\u5149\u789f\u5b89\u88dd Windows \u5728\u7368\u7acb\u786c\u789f\u4e0a<\/li>\n<li>Windows \u5b89\u88dd\u5b8c\u6210\uff0c\u958b\u6a5f\u5b8c\u6210\u653e\u5165 HighPoint RocketRAID 2310 \u5149\u789f\n<ol>\n<li>\u5b89\u88dd\u00a0HighPoint RocketRAID 2310 \u9a45\u52d5<\/li>\n<li>\u5b89\u88dd\u00a0RAID Management Software<\/li>\n<\/ol>\n<\/li>\n<li>\u57f7\u884c\u684c\u9762 RAID \u7ba1\u7406\u7a0b\u5f0f\u6377\u5f91\uff0c\u6216\u662f\u958b\u555f\u700f\u89bd\u5668\u8f38\u5165 <strong>https:\/\/127.0.0.1:7402<\/strong> \u9032\u5165\u7ba1\u7406\u4ecb\u9762<\/li>\n<li>\u8f38\u5165\u5e33\u865f RAID \u5bc6\u78bc hpt<\/li>\n<li>\u5efa\u7acb RAID 5 \u78c1\u789f\u9663\u5217<\/li>\n<li>\u9000\u51fa Windows \uff0cBIOS \u958b\u6a5f\u9806\u5e8f\u4fee\u6539\u70ba RocketRAID \u512a\u5148\uff0c\u6b63\u5f0f\u5b89\u88dd FreeBSD<\/li>\n<\/ol>\n<h2>FreeBSD 9.0 x64<\/h2>\n<ol>\n<li>\u5149\u789f\u958b\u6a5f<\/li>\n<li>\u8a72\u8a2d\u5b9a\u5c31\u8a2d\u5b9a\uff0c\u95dc\u9375\u5728\u786c\u789f\u5206\u5272<\/li>\n<li>\u786c\u789f\u5206\u5272\u5927\u53ef\u5148\u4f7f\u7528 auto \u521d\u6b65\u8a2d\u5b9a\n<ol>\n<li>\u7136\u5f8c\u628a \/ \u522a\u9664\uff0c\u56e0\u70ba FreeBSD \u7684 root boot \u7121\u6cd5\u5728 4TB \u7684\u5206\u5272\u555f\u52d5<\/li>\n<li>\u5272\u4e00\u584a 500GB \u7d66 \/<\/li>\n<li>\u5176\u4ed6\u7a7a\u9593\u5272\u7d66 \/home<\/li>\n<\/ol>\n<\/li>\n<li>\u5b89\u88dd\u5230\u5b8c\u6210<\/li>\n<\/ol>\n<p>\u4ee5\u4e0a\u6b64\u7d50\u8ad6\u82b1\u4e86\u6211\u6574\u6574\u5c07\u8fd1\u4e00\u500b\u661f\u671f\uff0c root \u5206\u5272\u76f4\u63a5\u4f7f\u7528 4T \u5927\u5c0f\u53ef\u4ee5\u5206\u5272\u4e5f\u53ef\u4ee5\u5b89\u88dd\uff0c\u4e0d\u904e\u61c9\u8a72\u662f\u5b89\u88dd\u5230\u5916\u592a\u7a7a\u53bb\u4e86\uff0c\u6240\u4ee5\u91cd\u65b0\u958b\u6a5f\u5f8c\u6703\u555f\u52d5\u5931\u6557\uff0c\u6709\u71d2\u9999\u7684\u6709\u6a5f\u6703\u6bd4\u8f03\u5e78\u904b\u53ef\u4ee5\u555f\u52d5\u5230 mountroot&gt; \u9019\u88e1\u5931\u6557\uff0c\u7136\u5f8c\u81ea\u884c\u8f38\u5165\u9019\u985e\u5b57\u4e32 ufs:\/dev\/da0p2 \u63a5\u4e0b\u53bb\u5b8c\u6210\uff1b\u6c92\u71d2\u9999\u7684\u76f4\u63a5\u5c31\u662f\u555f\u52d5\u4e0d\u80fd\u3002<\/p>\n<h2>\u57fa\u672c\u8a2d\u5b9a<\/h2>\n<p>\u589e\u52a0 hostname \u5230 \/etc\/hosts<\/p>\n<p>ee \/etc\/hosts<\/p>\n<pre>127.0.0.1\u00a0\u00a0\u00a0\u00a0\u00a0 hostname<\/pre>\n<h2>\u66f4\u65b0 ports<\/h2>\n<p>\u8a2d\u5b9a\u6a94: \/etc\/portsnap.conf<\/p>\n<p>SERVERNAME=portsnap.freebsd.org<\/p>\n<pre class=\"\">portsnap fetch extract\u00a0update\r\nsource ~\/.cshrc<\/pre>\n<h2>\u52a0\u5f37 ls - gnuls<\/h2>\n<p>\u4e0b\u8f09\u3001\u5b89\u88dd<\/p>\n<pre class=\"lang:default decode:true \">cd \/usr\/ports\/misc\/gnuls\r\nmake install<\/pre>\n<pre class=\"lang:sh decode:true\">ee ~\/.cshrc\r\nalias ls\u00a0\u00a0\u00a0 gnuls -a --color<\/pre>\n<p>&nbsp;<\/p>\n<h2>\u8cc7\u6599\u5eab MariaDB<\/h2>\n<pre class=\"lang:sh decode:true\">cd \/usr\/ports\/databases\/mariadb55-server\r\nmake install<\/pre>\n<pre class=\"lang:default decode:true\">ee \/etc\/rc.conf\r\nmysql_enable=\"YES\"<\/pre>\n<p>\u7de8\u8f2f\u3001\u4fee\u6539 my.cnf<\/p>\n<pre class=\"lang:sh decode:true\">cp \/usr\/local\/share\/mysql\/my-huge.cnf \/usr\/local\/etc\/my.cnf\r\ncd \/var\/db\/mysql\/\r\nln -s \/usr\/local\/etc\/my.cnf my.cnf<\/pre>\n<p>\u4fee\u6539 root \u5bc6\u78bc<\/p>\n<pre class=\"lang:default decode:true\"># mysql\r\n&gt; UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';\r\n&gt; FLUSH PRIVILEGES;<\/pre>\n<p><strong>\u4fee\u6539\u8a9e\u7cfb\u70ba UTF8<\/strong><\/p>\n<p>\u7de8\u8f2f my.cnf \u52a0\u5165\u4ee5\u4e0b\u8a2d\u5b9a<\/p>\n<pre class=\"lang:ini decode:true\">[mysqld]\r\ncharacter-set-server = utf8\r\ncollation-server = utf8_unicode_ci<\/pre>\n<ul>\n<li>character-set-server = utf8 \u2192\u00a0collation_server : utf8_general_ci<\/li>\n<li>collation-server = utf8_unicode_ci \u2192\u00a0collation_server : utf8_unicode_ci<\/li>\n<\/ul>\n<div>\n<p>db.php<\/p>\n<p>\u5728 php \u7a0b\u5f0f\u9023\u7d50\u8cc7\u6599\u5eab\u9078\u64c7\u8cc7\u6599\u5eab\u5f8c\uff0c\u4f7f\u7528\u00a0SET collation_connection \u5f71\u97ff\u7684\u662f\u00a0collation_connection \u548c\u00a0collation_database<\/p>\n<pre>mysql_select_db( \"hoyoDB\" , $link );\r\nmysql_query( 'SET collation_connection = utf8_unicode_ci' );<\/pre>\n<\/div>\n<h2>\u5fd8\u8a18 root \u5bc6\u78bc\uff0c\u5982\u4f55\u91cd\u65b0\u8a2d\u5b9a<\/h2>\n<p class=\"brush: bash; gutter: true\">\u505c\u6b62 MySQL Server \uff0c\u4f7f\u7528\u4e0d\u9700\u8a8d\u8b49\u6a21\u5f0f\u555f\u52d5 MySQL Server<\/p>\n<pre class=\"brush: bash; gutter: true\">\/usr\/local\/etc\/rc.d\/mysql-server stop\r\nmysqld_safe -u root --skip-grant-tables &amp;\r\nmysql<\/pre>\n<p class=\"brush: sql; gutter: true\">\u4f7f\u7528 SQL \u6307\u4ee4\u91cd\u65b0\u8a2d\u5b9a root \u5bc6\u78bc<\/p>\n<pre class=\"brush: sql; gutter: true\">use mysql;\r\nUPDATE mysql.user SET Password=PASSWORD('\u65b0\u5bc6\u78bc') WHERE User='root';\r\nFLUSH PRIVILEGES;\r\nquit<\/pre>\n<p class=\"brush: bash; gutter: true\">\u6b63\u5e38\u555f\u52d5 MySQL Server<\/p>\n<pre class=\"brush: bash; gutter: true\">\/usr\/local\/etc\/rc.d\/mysql-server start<\/pre>\n<h2>\u7db2\u7ad9\u4f3a\u670d\u5668 Apache<\/h2>\n<pre class=\"brush: bash; gutter: true\">cd \/usr\/ports\/www\/apache22\r\nmake install<\/pre>\n<p>ee \/etc\/rc.conf<\/p>\n<pre class=\"lang:ini decode:true\">apache22_enable=\"YES\"<\/pre>\n<p>ee \/usr\/local\/etc\/apache22\/httpd.conf<\/p>\n<pre class=\"lang:ini decode:true\">DirectoryIndex index.php index.html<\/pre>\n<p>--<\/p>\n<h2>\u7db2\u9801\u7a0b\u5f0f PHP5.5<\/h2>\n<pre>cd \/usr\/ports\/lang\/php55\r\nmake install<\/pre>\n<p>\u7de8\u8f2f Apache httpd.conf \u8a2d\u5b9a .php \u526f\u6a94\u540d\u95dc\u806f\u7d66 PHP \u8655\u7406<\/p>\n<pre class=\"lang:sh decode:true\">ee \/usr\/local\/etc\/apache22\/httpd.conf<\/pre>\n<pre class=\"lang:ini decode:true\">AddType application\/x-httpd-php .php\r\nAddType application\/x-httpd-php-sources .phps<\/pre>\n<p>\u5b89\u88dd PHP Extensions \uff0c\u8996\u9700\u6c42\u9078\u64c7<\/p>\n<pre class=\"lang:sh decode:true\">cd \/usr\/ports\/lang\/php55-extensions\r\nmake install<\/pre>\n<h2>\u8cc7\u6599\u5eab\u7ba1\u7406 phpmyadmin<\/h2>\n<p>\u4e0b\u8f09\u3001\u5b89\u88dd<\/p>\n<pre class=\"lang:sh decode:true\">cd \/usr\/ports\/databases\/phpmyadmin\r\nmake install<\/pre>\n<p>\u5c07 APC \u52fe\u9078\u53d6\u6d88\uff0cPHP 5.5\u00a0 \u4f7f\u7528 OPcache \u53d6\u4ee3 APC<\/p>\n<p>\u8a2d\u5b9a Apache httpd.conf \uff0c\u53ea\u5141\u8a31\u5167\u90e8\u7db2\u8def\u4f7f\u7528<\/p>\n<pre class=\"lang:ini decode:true\">Alias \/phpmyadmin\/ \"\/usr\/local\/www\/phpMyAdmin\/\"\r\n&lt;Directory \"\/usr\/local\/www\/phpMyAdmin\/\"&gt;\r\n Options none\r\n AllowOverride Limit\r\n\r\n Order Deny,Allow\r\n Deny from all\r\n Allow from 192.168.0.0\/24\r\n&lt;\/Directory&gt;<\/pre>\n<p>\/usr\/local\/www\/phpMyAdmin<\/p>\n<p>\u4fee\u6539\u767b\u5165\u903e\u6642<\/p>\n<pre class=\"\">ee \/usr\/local\/www\/phpMyAdmin\/config.inc.php\r\n$cfg['LoginCookieValidity'] = 144000;<\/pre>\n<p>--<\/p>\n<h2>sshd<\/h2>\n<p>\/etc\/ssh\/sshd_config<\/p>\n<pre class=\"lang:ini decode:true\">PermitRootLogin yes\r\nListenAddress 192.168.1.240<\/pre>\n<h2>NFS<\/h2>\n<p>ee \/etc\/rc.conf<\/p>\n<pre>nfs_server_enable=\"YES\"<\/pre>\n<p>ee\u00a0\/etc\/exports<\/p>\n<h2>SAMBA<\/h2>\n<p>\u4e0b\u8f09\u3001\u5b89\u88dd<\/p>\n<pre class=\"\">cd \/usr\/ports\/net\/samba36\r\nmake install<\/pre>\n<p>\u958b\u6a5f\u555f\u52d5<\/p>\n<pre class=\"lang:sh decode:true\">ee \/etc\/rc.conf<\/pre>\n<pre class=\"lang:ini decode:true\">samba_enable=\"YES\"<\/pre>\n<p>\u4f7f\u7528\u8005\u8a8d\u8b49<\/p>\n<pre class=\"brush: bash; gutter: true\">adduser\r\nsmbpasswd -a user<\/pre>\n<h2>\u7db2\u7ad9\u958b\u767c<\/h2>\n<p>1. <a href=\"https:\/\/code.google.com\/p\/mod-auth-token\/\" target=\"_blank\" rel=\"noopener\">mod-auth-token<\/a><\/p>\n<pre class=\"\">wget --no-check-certificate https:\/\/mod-auth-token.googlecode.com\/files\/mod_auth_token-1.0.6-beta.tar.gz\r\nrm -f configure\r\nautoreconf -fi\r\nautomake -f\r\n.\/configure\r\nmake<\/pre>\n<p>2. <a href=\"http:\/\/h264.code-shop.com\/trac\" target=\"_blank\" rel=\"noopener\">H264 Streaming Module Introduction<\/a> \u5b89\u88dd\u53c3\u8003\uff1a<a href=\"http:\/\/wiki.paskvil.com\/index.php\/Install_Apache_and_PHP_to_do_Secure_h264_Pseudo_Streaming\" target=\"_blank\" rel=\"noopener\">Install Apache and PHP to do Secure h264 Pseudo Streaming<\/a><\/p>\n<pre class=\"\">wget http:\/\/h264.code-shop.com\/download\/apache_mod_h264_streaming-2.2.7.tar.gz\r\ntar zxf apache_mod_h264_streaming-2.2.7.tar.gz\r\ncd mod_h264_streaming-2.2.7\/\r\n.\/configure --with-apxs='which apxs2'\r\nmake\r\nsudo make install<\/pre>\n<p>\u589e\u52a0 .mp4 \u526f\u6a94\u540d\u5728 Apache2 \u7684\u4e32\u6d41\u8a2d\u5b9a<\/p>\n<pre>LoadModule h264_streaming_module \/usr\/local\/libexec\/apache22\/mod_h264_streaming.so\r\nAddHandler h264-streaming.extensions .mp4<\/pre>\n<p>3. TexLive<\/p>\n<pre>mount -t cd9660 \/dev\/cd0 \/media\r\ncd \/media\r\n.\/install<\/pre>\n<p>\/usr\/local\/texlive\/2010\/index.html<\/p>\n<p>mktexlsr \/usr\/local\/texlive\/2010\/texmf-dist \/usr\/local\/texlive\/2010\/texmf<\/p>\n<p>pre-generating all format files (fmtutil-sys --all)<\/p>\n<pre class=\"lang:default decode:true\">Add \/usr\/local\/texlive\/2010\/texmf\/doc\/man to MANPATH, if not dynamically determined.\r\nAdd \/usr\/local\/texlive\/2010\/texmf\/doc\/info to INFOPATH.\r\nMost importantly, add \/usr\/local\/texlive\/2010\/bin\/amd64-freebsd &amp;nbsp;to your PATH for current and future sessions.<\/pre>\n<p>\u958b\u6a5f\u52a0\u5165 TexLive bin \u8def\u5f91<\/p>\n<pre class=\"lang:sh decode:true\">cp ~\/.cshrc \/etc\/csh.cshrc\r\nee \/etc\/csh.cshrc\r\nset path=($path \/usr\/local\/texlive\/2010\/bin\/amd64-freebsd)<\/pre>\n<h2><\/h2>\n<h2>\/usr\/ports\u00a0\u5176\u4ed6\u5b89\u88dd\u5f8c\u4e0d\u9808\u8a2d\u5b9a\u8edf\u9ad4<\/h2>\n<p>&nbsp;<\/p>\n<p><strong>graphics\/ImageMagick<\/strong><\/p>\n<p>\u984c\u5eab\u3001\u5716\u5eab\u4e0a\u50b3\u5f8c\u7e2e\u5716\u8655\u7406\u7528<\/p>\n<p><strong>multimedia\/ffmpeg1<\/strong><\/p>\n<p>\u5c07\u4e0a\u50b3\u5f71\u7247\u8f49\u63db\u6210 MP4 \u683c\u5f0f\uff0c\u63d0\u4f9b\u7db2\u9801\u4e32\u6d41\u64ad\u653e<\/p>\n<h2 class=\"brush: bash; gutter: true\">\u5b89\u88dd\u8a2d\u5b9a\u7528\u5f97\u5230<\/h2>\n<pre class=\"brush: bash; gutter: true\"># \/etc\/netstart restart<\/pre>\n<h2>\u96d9\u7db2\u5361\u5b89\u5168\u8a2d\u5b9a<\/h2>\n<p>\u4e3b\u6a5f\u4e0a\u4e3b\u6a5f\u677f\u672c\u8eab\u6709\u63d0\u4f9b\u4e00\u500b\u7db2\u8def\u5361\uff0c\u53e6\u5916\u53c8\u5b89\u88dd\u4e86\u4e00\u584a Intel PRO\/1000 PT \u7db2\u8def\u5361<\/p>\n<p>\u5c0d\u5167\u7db2\u5361\u8a2d\u5b9a 192.168.1 \u5340\u6bb5\uff0c\u5c0d\u5916\u8a2d\u5b9a 192.168.0 \u5340\u6bb5\uff0c\u5404\u81ea\u6709\u5c0d\u5916\u7684\u5bec\u983b\u7dda\u8def\uff0c\u4e92\u4e0d\u76f8\u901a\uff0c\u793a\u610f\u5716\u5982\u4e0b\uff1a<\/p>\n<p>\u57fa\u672c\u539f\u5247\u5c31\u662f\u4e0d\u9700\u8981\u5c0d\u5916\u7684\u5c31\u4e0d\u63d0\u4f9b\uff0c\u5c0d\u5916\u57fa\u672c\u4e0a\u53ea\u9700\u8981 DNS \u548c WEB \uff0c\u4e5f\u5c31\u662f UDP 53 \u548c TCP 80 \uff0c\u96e2\u6a5f\u53ca\u9060\u7aef\u7ba1\u7406\u5c31\u5f9e\u5167\u90e8\u9023\u7dda\u9032\u884c\uff0c\u4e0d\u76f4\u63a5\u5f9e\u5c0d\u5916\u983b\u5bec\u7ba1\u7406\u3002<\/p>\n<p><strong>Samba<\/strong><\/p>\n<p>\/usr\/local\/etc\/smb.conf<\/p>\n<pre class=\"brush: bash; gutter: false\">hosts allow = 192.168.1.\r\ninterfaces = 192.168.1.240\r\nbind interfaces only = yes<\/pre>\n<h2>xorg - X Window<\/h2>\n<p>\u639b\u8f09 DVD \u5149\u789f<\/p>\n<pre class=\"lang:sh decode:true\">cd \/media\/package\/x11\r\npkg_add *\r\ncd \/media\/package\/gnome\r\npkg_add *\r\necho gnome_enable=\"YES\" &gt;&gt; \/etc\/rc.conf\r\ninit 6<\/pre>\n<p>(\u6211\u4e5f\u5fd8\u8a18\u7576\u521d\u5b89\u88dd X window \u8981\u5e79\u55ce\uff1f...)<\/p>\n<h2>\u5b9a\u6642\u57f7\u884c<\/h2>\n<p>\u5099\u4efd \u6821\u6642<\/p>\n<h2>PHP \u7a0b\u5f0f\u958b\u767c<\/h2>\n<p><strong><span style=\"color: #993300;\">\u4e00\u3001<\/span><\/strong>MySQL \u9023\u7dda\u6821\u5c0d utf8_unicode_ci<\/p>\n<p>\u5728\u6b64\u9810\u671f\u76ee\u7684\u662f\u5c07\u00a0collation_connection,\u00a0collation_database,\u00a0collation_server \u4e09\u500b\u72c0\u614b\u90fd\u8a2d\u5b9a\u70ba utf8_unicode_ci<\/p>\n<p>\u5148\u524d\u5728 OpenSUSE \u4e0a\u958b\u767c\uff0c\u6b64\u4e09\u500b\u72c0\u614b\u5728\u300c\u604d\u795e\u7684\u60c5\u6cc1\u4e0b\u300d\u5c31\u5df2\u7d93\u662f utf8_unicode_ci \u3002\u4e00\u822c\u4f86\u8aaa\uff0c\u4f7f\u7528 phpMyAdmin \u4f86\u67e5\u770b\u4e5f\u6703\u662f utf8_unicode_ci \uff0c\u56e0\u70ba\u5728\u9996\u9801 phpMyAdmin \u5c31\u8981\u4f60\u8a2d\u5b9a MySQL \u7684\u9023\u7dda\u6821\u5c0d<\/p>\n<p><a href=\"http:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2012\/11\/\u5716\u7247-016.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-927\" title=\"\" src=\"\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2012\/11\/\u5716\u7247-016.png\" alt=\"\" width=\"732\" height=\"142\" srcset=\"https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2012\/11\/\u5716\u7247-016.png 732w, https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2012\/11\/\u5716\u7247-016-300x58.png 300w, https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2012\/11\/\u5716\u7247-016-500x96.png 500w\" sizes=\"(max-width: 732px) 100vw, 732px\" \/><\/a><\/p>\n<p>\u4e0d\u904e\u4e0d\u8ad6\u662f Linux \u6216\u662f phpMyAdmin \u986f\u793a\u4ec0\u9ebc\u90fd\u548c FreeBSD \u7121\u95dc ..... \u6240\u4ee5\u6211\u5011\u9084\u662f\u9700\u8981\u81ea\u5df1\u8a2d\u5b9a\u3002<\/p>\n<p>1. \u6839\u64da\u8a18\u61b6\u9ad4\u4ee5\u53ca\u9700\u6c42\u8907\u88fd\u6a21\u7d44\u8a2d\u5b9a my.cnf<\/p>\n<pre>cp \/usr\/local\/share\/mysql\/my-*.cnf \/usr\/local\/etc\/my.cnf\r\nee \/usr\/local\/etc\/my.cnf<\/pre>\n<p>2. \u7de8\u8f2f my.cnf \u52a0\u5165\u4ee5\u4e0b\u8a2d\u5b9a<\/p>\n<pre class=\"brush: bash; gutter: true\">[mysqld]\r\ncharacter-set-server = utf8\r\ncollation-server = utf8_unicode_ci<\/pre>\n<ul>\n<li>character-set-server = utf8 \u2192\u00a0collation_server : utf8_general_ci<\/li>\n<li>collation-server = utf8_unicode_ci \u2192\u00a0collation_server : utf8_unicode_ci<\/li>\n<\/ul>\n<p class=\"brush: bash; gutter: true\">db.php<\/p>\n<p class=\"brush: bash; gutter: true\">\u5728 php \u7a0b\u5f0f\u9023\u7d50\u8cc7\u6599\u5eab\u9078\u64c7\u8cc7\u6599\u5eab\u5f8c\uff0c\u4f7f\u7528\u00a0SET collation_connection \u5f71\u97ff\u7684\u662f\u00a0collation_connection \u548c\u00a0collation_database<\/p>\n<pre class=\"brush: php; gutter: true\">mysql_select_db( \"hoyoDB\" , $link );\r\nmysql_query( 'SET collation_connection = utf8_unicode_ci' );<\/pre>\n<p class=\"brush: bash; gutter: true\">\u89c0\u770b MySQL \u8a2d\u5b9a\u72c0\u614b\u6307\u4ee4<\/p>\n<pre class=\"brush: sql; gutter: true\">show variables like 'collation%';<\/pre>\n<p class=\"brush: bash; gutter: true\">collation_connection : utf8_unicode_ci<\/p>\n<p>collation_database : utf8_unicode_ci<\/p>\n<p class=\"brush: bash; gutter: true\"><strong><span style=\"color: #993300;\">\u4e8c\u3001<\/span><\/strong>php \u6642\u5340\u8a2d\u5b9a<\/p>\n<p class=\"brush: bash; gutter: true\">\u4fee\u6539 \/usr\/local\/etc\/php.ini \u5167 date.timezone<\/p>\n<pre class=\"brush: bash; gutter: true\">[Date]\r\n; Defines the default timezone used by the date functions\r\n; http:\/\/php.net\/date.timezone\r\ndate.timezone = Asia\/Taipei<\/pre>\n<p class=\"brush: bash; gutter: true\">\u6642\u5340\u8a2d\u5b9a\u5230\u00a0<a href=\"http:\/\/tw1.php.net\/manual\/en\/timezones.php\">PHP: List of Supported Timezones - Manual<\/a>\u00a0\u9019\u88e1\u67e5\uff0c\u4fee\u6539\u5b58\u6a94\u5b8c\u6210\uff0c\u91cd\u65b0\u555f\u52d5 apache<\/p>\n<p class=\"brush: bash; gutter: true\">\/usr\/local\/etc\/rc.d\/apache22 restart<\/p>\n<h2>\u88dc\u5145\u8cc7\u6599<\/h2>\n<ul>\n<li>\u78c1\u789f\u9663\u5217\u83ef\u6c0f\u6eab\u5ea6\u8f49\u63db\u516c\u5f0f\n<dl>\n<dd><img src=\"http:\/\/upload.wikimedia.org\/math\/3\/2\/c\/32c3165c7b5c40475f41de6ce7cada94.png\" alt=\"{}^\\circ C = \\frac{5}{9}({}^\\circ F - 32)\" \/> <img src=\"http:\/\/upload.wikimedia.org\/math\/d\/3\/4\/d346c0701d2ffd0df051ae44f61333af.png\" alt=\"{}^\\circ F = \\frac{9}{5} {}^\\circ C + 32\" \/><a href=\"http:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2012\/11\/\u5716\u7247-017.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\"><img loading=\"lazy\" title=\"\" src=\"\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2012\/11\/\u5716\u7247-017.png\" alt=\"\" width=\"772\" height=\"222\" \/><\/a><\/dd>\n<\/dl>\n<\/li>\n<\/ul>\n<p>--<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p class=\"pvc_stats all \" data-element-id=\"902\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> &nbsp;1,775&nbsp;total views<\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u9019\u7bc7\u5f88\u9577\u5f88\u9577\u5f88\u9577..........<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p class=\"pvc_stats all \" data-element-id=\"902\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> &nbsp;1,775&nbsp;total views<\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[259],"tags":[107],"_links":{"self":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/902"}],"collection":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=902"}],"version-history":[{"count":101,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/902\/revisions"}],"predecessor-version":[{"id":5775,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/902\/revisions\/5775"}],"wp:attachment":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}