2011/04/21

[MySQL] 設定使用者權限至欄位 - GRANT Fields

用法:
GRANT
    priv_type [(column_list)] [, priv_type [(column_list)]] ...
    ON [object_type] priv_level
    TO user_specification [, user_specification] ...
    [REQUIRE {NONE | ssl_option [[AND] ssl_option ...}]
    [WITH with_option ...]

要設定使用者對欄位權限:

2011/04/19

[MySQL] Host 'xxx' is blocked because of many connection errors. -2147467259(80004005)

昨天,程式出了點狀況,本以為重開就搞定。
今天,程式出現下列錯誤訊息:


Microsoft OLE DB Provider for ODBC Drivers, -2147467259(80004005)
[MySQL][ODBC 3.51 Driver]Host '192.168.1.10' is blocked because of many connection errors.  Unblock with 'mysqladmin flush-hosts'

經查,似乎是 MySQL 為避免駭客程式/病毒攻擊所做的動作?
需到對方機器上,開啟 DOS prompt,並於 MySQL 目錄下輸入:

2011/04/13

[密技] 踩地雷

不須外掛,不用另外跑別的程式"補助"!

踩地雷本身就有密技!

就是打開踩地雷
輸入xyzzy,再按一下