{"id":311,"date":"2007-03-03T14:45:07","date_gmt":"2007-03-03T06:45:07","guid":{"rendered":"http:\/\/192.168.50.160\/wordpress\/?p=311"},"modified":"2007-03-03T14:45:07","modified_gmt":"2007-03-03T06:45:07","slug":"%e5%ae%89%e8%a3%9dmysql-41-%e7%89%88%e6%9c%83%e9%81%87%e7%9a%84%e5%95%8f%e9%a1%8c","status":"publish","type":"post","link":"https:\/\/history.dowdot.idv.tw\/?p=311","title":{"rendered":"\u5b89\u88ddMySQL 4.1 \u7248\u6703\u9047\u7684\u554f\u984c"},"content":{"rendered":"<p>\u7e7c\"<a href=\"http:\/\/192.168.50.160\/wordpress\/?p=309\">MySQL lifecycle<\/a>\"\u9019\u7bc7\u4e4b\u5f8c,\u8c46\u5b50\u6709\u9ede\u4e0d\u60c5\u9858\u7684 \u64c7\u4e86MySQL4.1\u7684\u7248\u672c\u5b89\u88dd\u3002\u5176\u5be6\u4e8c\u5e74\u524d\u4e5f\u66fe\u88dd\u904e4.1\u7684\u7248\u672c,\u53ea\u662f\u6700\u5f8c\u56e0\u70ba\u7de8\u78bc\u7684\u554f\u984c\u548c\u4e00\u4e9b\u8a0e\u53ad\u7684\u7169\u7463\u932f\u8aa4\u3002\u56e0\u70ba\u7576\u6642\u7db2\u8def\u4e0a\u7684\u8a0e\u8ad6\u4e26\u4e0d\u591a,\u61f6\u60f0\u7684\u8c46\u5b50\u4e0d\u60f3\u82b1\u6642\u9593\u5728\u9019\u4e0a\u9762,\u6700\u5f8c\u5c31\u4e00\u76f4\u505c\u7559\u57284.0\u7684\u7248\u672c\u3002<\/p>\n<p><!--more--><\/p>\n<p>\u5728\u5b8c\u6210MySQL 4.1\u7248\u7684\u5b89\u88dd\u5f8c,\u4e00\u8cab\u7684\u5207\u63db\u5230phpMyadmin\u74b0\u5883\u4e2d\u8a2d\u5b9a\u8cc7\u6599\u5eab\u7684\u5bc6\u78bc\u4e26\u91cd\u65b0\u6574\u7406\u7db2\u9801,\u800c\u9019\u6b21\u7db2\u9801\u5c45\u7136\u986f\u793a\u4e86\"Client does not support authentication protocol requested by server; consider upgrading MySQL client\"\u7684\u932f\u8aa4,\u8a71\u8aaa\u4e4b\u524d\u8d77\u78bc\u4e5f\u88dd\u904e\u4e8c\u4e09\u5341\u6b21\u7684MySQL\u5f9e\u4f86\u4e5f\u4e0d\u66fe\u51fa\u73fe\u9019\u6a23\u7684\u8a0a\u606f\u932f\u8aa4\u3002<\/p>\n<p>\u5370\u8c61\u4e2d\u4ee5\u524d\u4e5f\u9047\u904e\u9019\u554f\u984c,\u6240\u4ee5\u7528google\u5927\u795e\u67e5\u4e86\u4e00\u4e0b\u8cc7\u6599,\u73fe\u5728\u7684\u8cc7\u6599\u53ef\u6bd4\u4ee5\u524d\u591a\u4e86\u8a31\u591a,\u99ac\u4e0a\u5c31\u627e\u5230\u6211\u8981\u7684\u7b54\u6848\u3002\u539f\u4f86\u662fMySQL\u7684\u52a0\u5bc6\u65b9\u6cd5\u8b8a\u4e86\uff0c\u53ef\u4ee5\u7528old_password()\u51fd\u6578\u89e3\u6c7a,\u4ee5\u4e0b\u662f\u627e\u5230\u7684\u89e3\u6c7a\u65b9\u5f0f\u53ca\u904e\u7a0b:<\/p>\n<p><code>[root@dowdot]# mysql -uroot -p<br \/>\nEnter password:<br \/>\nWelcome to the MySQL monitor. Commands end with ; or g.<br \/>\nYour MySQL connection id is 44 to server version: 4.1.7-max<br \/>\nType 'help;' or 'h' for help. Type 'c' to clear the buffer.<br \/>\nmysql> <\/p>\n<p>\u89e3\u6c7a\u65b9\u6cd5:<\/p>\n<p>\u4e00:<\/p>\n<p>mysql> SET PASSWORD FOR<br \/>\n-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');<\/p>\n<p>\u4e8c:<\/p>\n<p><\/code><code>mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('\u65b0\u5bc6\u78bc')  WHERE Host = 'localhost' AND User = '\u7528\u6237\u540d'; <\/p>\n<p>mysql> FLUSH PRIVILEGES;<\/code><\/p>\n<p>20100324\u88dc\u5145:<br \/>\n        \u5b89\u88ddMySQL\u5f8c,\u555f\u52d5\u6642\u6703\u767c\u751f\u5982\u4e0b\u7684\u932f\u8aa4:<br \/>\n        [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist<\/p>\n<p>        \u89e3\u6c7a\u65b9\u6cd5:\u521d\u59cb\u5316\u6642\u591a\u52a0\u4e00\u500b--datadir \u7684\u53c3\u6578<br \/>\n<code><br \/>\n        scripts\/mysql_install_db --user=mysql --datadir=\/mysqldata\u7684\u8def\u5f91<br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7e7c&#8221;MySQL lifecycle&#8221;\u9019\u7bc7\u4e4b\u5f8c,\u8c46\u5b50\u6709\u9ede\u4e0d\u60c5\u9858\u7684 \u64c7\u4e86MySQL4.1\u7684\u7248\u672c\u5b89\u88dd\u3002\u5176\u5be6\u4e8c\u5e74\u524d\u4e5f\u66fe\u88dd\u904e4.1\u7684\u7248\u672c,\u53ea\u662f\u6700\u5f8c\u56e0\u70ba\u7de8\u78bc\u7684\u554f\u984c\u548c\u4e00\u4e9b\u8a0e\u53ad\u7684\u7169\u7463\u932f\u8aa4\u3002\u56e0\u70ba\u7576\u6642\u7db2\u8def\u4e0a\u7684\u8a0e\u8ad6\u4e26\u4e0d\u591a,\u61f6\u60f0\u7684\u8c46\u5b50\u4e0d\u60f3\u82b1\u6642\u9593\u5728\u9019\u4e0a\u9762,\u6700\u5f8c\u5c31\u4e00\u76f4\u505c\u7559\u57284.0\u7684\u7248\u672c\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":""},"categories":[8],"tags":[],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5NCTI-51","_links":{"self":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/311"}],"collection":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=311"}],"version-history":[{"count":0,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/311\/revisions"}],"wp:attachment":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}