{"id":21,"date":"2012-07-16T00:58:45","date_gmt":"2012-07-15T15:58:45","guid":{"rendered":"http:\/\/blog.mamimu.me\/fishblue\/?p=21"},"modified":"2012-07-16T12:05:41","modified_gmt":"2012-07-16T03:05:41","slug":"mysql%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e7%9b%b4%e5%be%8c%e3%81%ab%e3%81%99%e3%82%8b%e3%81%93%e3%81%a8","status":"publish","type":"post","link":"https:\/\/blog.mamimu.me\/fishblue\/?p=21","title":{"rendered":"mysql\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u76f4\u5f8c\u306b\u3059\u308b\u3053\u3068\uff08root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a\uff09"},"content":{"rendered":"

mysql\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u76f4\u5f8c\u306f\u3069\u3046\u3044\u3046\u308f\u3051\u304broot\u30e6\u30fc\u30b6\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u639b\u304b\u3063\u3066\u3044\u307e\u305b\u3093\u3002<\/p>\n

\u306a\u306e\u3067\u59cb\u3081\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n

# mysql -u root<\/p>\n

mysql> \u306e\u30d7\u30ed\u30f3\u30d7\u30c8\u304c\u7121\u4e8b\u306b\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u304b\uff1f<\/p>\n

\u8868\u793a\u3055\u308c\u305f\u3068\u8a00\u3046\u3053\u3068\u306f\u30ce\u30f3\u30d1\u30b9\u3067mysql\u306eroot\u30e6\u30fc\u30b6\u306b\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u305f\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<\/p>\n

 <\/p>\n

\u3061\u3087\u3063\u3068\u78ba\u8a8d<\/p>\n

mysql> show databases;<\/p>\n

mysql> connect mysql;<\/p>\n

mysql> show tables;<\/p>\n

mysql> select * from user;<\/p>\n

\u3050\u3061\u3083\u3050\u3061\u3083\u3067\u898b\u3065\u3089\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n

mysql> pager less -i -n -S<\/p>\n

\u3082\u3046\u4e00\u5ea6\u5148\u307b\u3069\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n

mysql> select * from user;<\/p>\n

\u4eca\u5ea6\u306f\u898b\u3084\u3059\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

 <\/p>\n

\u3067\u3001\u3088\u304f\u898b\u308b\u3068localhost\u306eroot\u30e6\u30fc\u30b6\u306epassword\u6b04\u304c\u7a7a\u6b04\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3067\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n

\u66f8\u5f0f\uff09set password for root@”localhost”=password(‘\u8a2d\u5b9a\u3059\u308b\u30d1\u30b9\u30ef\u30fc\u30c9’);<\/p>\n

\u4f8b\uff09\u30d1\u30b9\u30ef\u30fc\u30c9\u3092 zaq12wsx \u306b\u8a2d\u5b9a\u3059\u308b\u5834\u5408<\/p>\n

mysql> set password for root@”localhost”=password(‘zaq12wsx’);<\/p>\n

 <\/p>\n

localhost\u306eroot\u30e6\u30fc\u30b6\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u6b04\u304c\u57cb\u307e\u3063\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n

mysql> select * from mysql.user;<\/p>\n

exit\u3067\u629c\u3051\u307e\u3059\u3002<\/p>\n

mysql> exit<\/p>\n

 <\/p>\n

\u30ed\u30b0\u30a4\u30f3\u78ba\u8a8d\u3092\u3057\u307e\u3059\u3002<\/p>\n

# myql -u root<\/p>\n

\u5148\u307b\u3069\u3068\u540c\u3058\u30b3\u30de\u30f3\u30c9\u3067\u3059\u304c\u4ee5\u4e0b\u306e\u30a8\u30e9\u30fc\u304c\u51fa\u307e\u3059\u3002<\/p>\n

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)<\/p>\n

\u4eca\u5ea6\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n

# mysql -u root -p<\/p>\n

Enter password: \u304c\u8868\u793a\u3055\u308c\u307e\u3059\u306e\u3067\u5148\u307b\u3069\u8a2d\u5b9a\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n

mysql> \u306e\u30d7\u30ed\u30f3\u30d7\u30c8\u304c\u8868\u793a\u3055\u308c\u3066\u7121\u4e8b\u306b\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u308c\u3070OK\u3067\u3059\u3002<\/p>\n