\u3044\u3084\u30fc\u5fd8\u308c\u3093\u306a\uff01\u3068\u3044\u3046\u7a81\u3063\u8fbc\u307f\u306f\u3042\u308d\u3046\u304c\u3001\u500b\u4eba\u30b5\u30fc\u30d0\u3067\u8a2d\u5b9a\u3057\u305fMySQL\u306eroot\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5fd8\u308c\u308b\u306a\u3093\u3066\u3053\u3068\u306f\u3088\u304f\u3042\u308b\u8a71\u3002<\/p>\n
CentOS\u3067\u306e\u8a2d\u5b9a\u4f8b\u3060\u304c\u3001\/etc\/my.cnf\u30d5\u30a1\u30a4\u30eb\u3092\u7de8\u96c6\u3057\u3066\u518d\u8d77\u52d5\u3059\u308b\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u518d\u8a2d\u5b9a\u304c\u53ef\u80fd\u3068\u306a\u308b\u3002<\/p>\n
\u8a72\u5f53\u30d5\u30a1\u30a4\u30eb\u306e\u306b\u5148\u982d\u306b[mysqld]\u30bb\u30af\u30b7\u30e7\u30f3\u304c\u3042\u308b\u306f\u305a\u3001\u305d\u306e\u76f4\u4e0b\u3042\u305f\u308a\u4ee5\u4e0b\u306e\u3088\u3046\u306bskip-grant-tables\u3092\u5165\u308c\u3066\u3001mysql\u3092\u518d\u8d77\u52d5\u3059\u308b\u3002<\/p>\n
[mysqld]
\n#\u3053\u306e\u884c\u3092\u5165\u308c\u308b
\nskip-grant-tables<\/p>\n
\u305d\u306e\u5f8c\u306fmysql\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\u306a\u3057\u3067\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u308b\u306e\u3067<\/p>\n
[shell]
\n[root@rutake]# mysql -u root mysql
\nReading table information for completion of table and column names
\nYou can turn off this feature to get a quicker startup with -A<\/p>\n
Welcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 2 to server version: 4.1.22<\/p>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the buffer.<\/p>\n
mysql> UPDATE user SET Password=PASSWORD(‘tmp’) WHERE User=’root’;
\nQuery OK, 1 row affected (0.03 sec)
\nRows matched: 1 Changed: 1 Warnings: 0<\/p>\n
mysql> exit
\nBye
\n[\/shell]<\/p>\n
\u3042\u3068\u306f\u5148\u307b\u3069\u8ffd\u52a0\u3057\u305f\u8a18\u8ff0\u3092\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3057\u3066\u518d\u8d77\u52d5\u3059\u308c\u3070OK!
\nmysqld\u306b\u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u3064\u3051\u3066\u3082\u3044\u3044\u3089\u3057\u3044\u3051\u3069\u3001\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3044\u3058\u308b\u307b\u3046\u304c\u7c21\u5358\u3060\u3068\u601d\u3063\u3066\u7d39\u4ecb\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3044\u3084\u30fc\u5fd8\u308c\u3093\u306a\uff01\u3068\u3044\u3046\u7a81\u3063\u8fbc\u307f\u306f\u3042\u308d\u3046\u304c\u3001\u500b\u4eba\u30b5\u30fc\u30d0\u3067\u8a2d\u5b9a\u3057\u305fMySQL\u306eroo … \u7d9a\u304d\u3092\u8aad\u3080