MySQLのユーザー

第19回 MySQLのユーザー管理について[その2]:MySQL道普請便り|gihyo.jp … 技術評論社

root@127.0.0.1とroot@localhostは別アカウントかという、興味深い内容

csvファイルをMySQLに読み込む

MySQL :: MySQL 5.6 リファレンスマニュアル :: 13.2.6 LOAD DATA INFILE 構文

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
    [REPLACE | IGNORE]
    INTO TABLE tbl_name
    [PARTITION (partition_name,...)]
    [CHARACTER SET charset_name]
    [{FIELDS | COLUMNS}
        [TERMINATED BY 'string']
        [[OPTIONALLY] ENCLOSED BY 'char']
        [ESCAPED BY 'char']
    ]
    [LINES
        [STARTING BY 'string']
        [TERMINATED BY 'string']
    ]
    [IGNORE number {LINES | ROWS}]
    [(col_name_or_user_var,...)]
    [SET col_name = expr,...]

コンマ区切りのテキストファイルを読み込むなら、

load data local infile '/full/path_to/sample.csv'
 into table `node_countriesNW`
 fields terminated by ','
 enclosed by '"'
 ignore 1 lines;