{"id":3604,"date":"2010-08-28T22:16:25","date_gmt":"2010-08-28T14:16:25","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/176\/2010\/08\/28\/%e4%bd%bf%e7%94%a8mysql-%e6%8c%87%e4%bb%a4%e6%96%b0%e5%a2%9e%e8%b3%87%e6%96%99%e5%ba%ab-2\/"},"modified":"2010-08-28T22:16:25","modified_gmt":"2010-08-28T14:16:25","slug":"%e4%bd%bf%e7%94%a8mysql-%e6%8c%87%e4%bb%a4%e6%96%b0%e5%a2%9e%e8%b3%87%e6%96%99%e5%ba%ab-2","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/linkc\/2010\/08\/28\/%e4%bd%bf%e7%94%a8mysql-%e6%8c%87%e4%bb%a4%e6%96%b0%e5%a2%9e%e8%b3%87%e6%96%99%e5%ba%ab-2\/","title":{"rendered":"\u4f7f\u7528MySQL \u6307\u4ee4\u65b0\u589e\u8cc7\u6599\u5eab"},"content":{"rendered":"<p><span style=\"border-collapse: separate; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium; font-family: 'Droid Sans'; color: #000000\"><\/p>\n<div style=\"font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 13px; background-color: #ffffff; display: block\">\n<span style=\"font-size: 15.8333px; color: #181818\"><\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n\u5728Linux Server \u8981\u65b0\u5efa\u7acb\u50cfxoops\u3001joomla\u3001gallery<br \/>\n&#8230;&#8230;\u7b49\u7db2\u7ad9\uff0c\u90fd\u8981\u5efa\u7acb\u8cc7\u6599\u5eab\uff0c\u8981\u5efa\u7acb\u8cc7\u6599\u5eab\u6700\u5feb\u7684\u65b9\u5f0f\u5c31\u662f\u4f7f\u7528\u6587\u5b57\u6307\u4ee4\uff0c\u5176\u65b9\u6cd5\u5982\u4e0b:\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n[@more@]&nbsp;<span style=\"font-size: 15.8333px\"><strong>1.\u767b\u5165<br \/>\nMySQ<\/strong>L<\/span>\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n\u5728\u547d\u4ee4\u5217\u8f38\u5165\u4e0b\u5217\u6307\u4ee4\uff0c\u63a5\u8457\u8f38\u5165 root \u7684\u5bc6\u78bc\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n#<span>&nbsp;<\/span><span style=\"color: #ff0000\">mysql -u root -p<\/span>\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<strong>2.\u5efa\u7acb\u8cc7\u6599\u5eab\u7684\u4f7f\u7528\u8005<\/strong>\n<\/p>\n<p><\/span><\/p>\n<blockquote style=\"margin: 0px 0px 0px 40px; border-style: none; padding: 0px\" class=\"webkit-indent-blockquote\" style=\"margin: 0px 0px 0px 40px; border-style: none; padding: 0px\"><p>\n\t<span style=\"font-size: 15.8333px; font-family: Georgia,'Times New Roman',Arial,Verdana,Tahoma,sans-serif; color: #181818\"><\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n\t\u4ee5\u4e0b\u9019\u500b\u6307\u4ee4\u6703\u540c\u6642\u5efa\u7acb\u4f7f\u7528\u8005\u4e26\u4e14\u9650\u5236\u9019\u500b\u4f7f\u7528\u8005\u53ea\u80fd\u5f9e\u672c\u6a5f\u4f86\u9023\u5230 MySQL \u4f3a\u670d\u5668 (\u9019\u53ea\u662f\u9023\u5230\u4f3a\u670d\u5668\u7684\u6b0a\u9650\u800c\u5df2\uff0c\u8cc7\u6599\u5eab\u7684\u6b0a\u9650\u8981\u53e6\u5916\u8a2d\u5b9a..)\n\t<\/p>\n<p>\t<\/span><span style=\"font-size: 15.8333px; font-family: Georgia,'Times New Roman',Arial,Verdana,Tahoma,sans-serif; color: #181818\"><\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n\t\u5982\u679c\u8981\u505a\u9060\u7aef\u5099\u4efd\u600e\u9ebc\u8fa6\u5462 ? \u90a3\u5c31\u518d\u5efa\u4e00\u500b\u9650\u5236\u53ea\u80fd\u5f9e\u9060\u7aef\u96fb\u8166\u9023\u7dda\u7684\u4f7f\u7528\u8005\u5c31\u53ef\u4ee5 (\u628a localhost \u63db\u6210\u9060\u7aef\u96fb\u8166\u7684 IP )\n\t<\/p>\n<p>\t<\/span>\n<\/p><\/blockquote>\n<p><span style=\"font-size: 15.8333px; color: #181818\"><\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n&nbsp;<span style=\"font-size: 15.8333px\"><span style=\"color: #ff0000\">grant<br \/>\nusage on *.* to linkc@localhost identified by &#8216;linkcpasswd&#8217;;<\/span><\/span>\n<\/p>\n<p><\/span><\/p>\n<blockquote style=\"margin: 0px 0px 0px 40px; border-style: none; padding: 0px\" class=\"webkit-indent-blockquote\" style=\"margin: 0px 0px 0px 40px; border-style: none; padding: 0px\"><p>\n\t<span style=\"font-size: 15.8333px; font-family: Georgia,'Times New Roman',Arial,Verdana,Tahoma,sans-serif; color: #181818\"><\/p>\n<h4 style=\"line-height: normal; font-size: 1.1em; font-family: Arial,Verdana,sans-serif; margin: 0px; padding: 0px 0px 6px; clear: both; display: block; font-weight: normal\"><span style=\"color: #339966\">linkc \u662f\u4f7f\u7528\u8005\u540d\u7a31<\/span><\/h4>\n<p><\/span><span style=\"font-size: 15.8333px; color: #181818\"><\/p>\n<h4 style=\"line-height: normal; font-size: 1.1em; font-family: Arial,Verdana,sans-serif; margin: 0px; padding: 0px 0px 6px; clear: both; display: block; font-weight: normal\"><span style=\"color: #339966\">&#8216;linkcpasswd&#8217;\u662f\u5bc6\u78bc<\/span><\/h4>\n<p><\/span>\n<\/p><\/blockquote>\n<p><span style=\"font-size: 15.8333px; color: #181818\"><\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<strong>3.\u5efa\u7acb\u8cc7\u6599\u5eab&nbsp;<\/strong>\n<\/p>\n<p><\/span><\/p>\n<blockquote style=\"margin: 0px 0px 0px 40px; border-style: none; padding: 0px\" class=\"webkit-indent-blockquote\" style=\"margin: 0px 0px 0px 40px; border-style: none; padding: 0px\"><p>\n\t<span style=\"font-size: 15.8333px; font-family: Georgia,'Times New Roman',Arial,Verdana,Tahoma,sans-serif; color: #181818\"><\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n\t\u5efa\u7acb<span style=\"font-size: 15.8333px\">\u9810\u8a2d\u662f\u7528 utf8 \u5b57\u5143\u7684<\/span><span style=\"font-size: 15.8333px\">\u8cc7\u6599\u5eab\u3002<\/span>\n\t<\/p>\n<p>\t<\/span>\n<\/p><\/blockquote>\n<p><span style=\"font-size: 15.8333px; color: #181818\"><\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<span style=\"color: #ff0000\">create database linkcdb default charset<br \/>\nutf8 collate utf8_general_ci;<\/span>\n<\/p>\n<p><\/span><\/p>\n<blockquote style=\"margin: 0px 0px 0px 40px; border-style: none; padding: 0px\" class=\"webkit-indent-blockquote\" style=\"margin: 0px 0px 0px 40px; border-style: none; padding: 0px\"><p>\n\t<span style=\"font-size: 15.8333px; font-family: Georgia,'Times New Roman',Arial,Verdana,Tahoma,sans-serif; color: #181818\"><\/p>\n<h4 style=\"line-height: normal; font-size: 1.1em; font-family: Arial,Verdana,sans-serif; margin: 0px; padding: 0px 0px 6px; clear: both; display: block; font-weight: normal\"><span style=\"color: #339966\">linkcdb \u662f\u8cc7\u6599\u5eab\u540d\u7a31<\/span><\/h4>\n<p><\/span>\n<\/p><\/blockquote>\n<p><span style=\"font-size: 15.8333px; color: #181818\"><\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<strong>4.\u8a2d\u5b9a\u8cc7\u6599\u5eab\u6b0a\u9650<\/strong><br \/>\n\u8b93\u9019\u500b\u4f7f\u7528\u8005\u5177\u6709\u4f7f\u7528\u9019\u500b\u8cc7\u6599\u5eab\u7684\u6b0a\u9650 ( \u8a3b:\u4e0b\u9762\u7684\u8a2d\u5b9a\u65b9\u5f0f\u662f )\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<span style=\"color: #ff0000\">grant all privileges on linkcdb.* to<br \/>\nlinkc@localhost ;<\/span>\n<\/p>\n<p><\/span><\/p>\n<blockquote style=\"margin: 0px 0px 0px 40px; border-style: none; padding: 0px\" class=\"webkit-indent-blockquote\" style=\"margin: 0px 0px 0px 40px; border-style: none; padding: 0px\"><p>\n\t<span style=\"font-size: 15.8333px; font-family: Georgia,'Times New Roman',Arial,Verdana,Tahoma,sans-serif; color: #181818\"><\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n\t<span style=\"font-size: 15.8333px\"><span style=\"color: #339966\">\u8b93<br \/>\n\t\u300clinkc\u300d\u9019\u500b\u4f7f\u7528\u8005\u53ef\u5b8c\u5168\u63a7\u5236\u300clinkcdb\u300d\u9019\u500b\u8cc7\u5eab<\/span><\/span><span style=\"color: #339966\">&nbsp;<\/span>\n\t<\/p>\n<p>\t<\/span>\n<\/p><\/blockquote>\n<p><span style=\"font-size: 15.8333px; color: #181818\"><\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n&nbsp;\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<strong><span style=\"font-size: large\">\u4e0b\u5217\u6307\u4ee4\u53ef\u80fd\u4e5f\u6703\u7528\u5230:<\/span><\/strong>\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<strong>\u67e5\u770b\u4f7f\u8005\u7528&nbsp;<\/strong><br \/>\n\u67e5\u770b\u662f\u5426\u65b0\u589e\u6210\u529f..\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<span style=\"color: #ff0000\">selec user from user;<\/span>\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<strong>\u522a\u9664\u4f7f\u7528<\/strong><br \/>\n<span style=\"font-size: 15.8333px\"><span style=\"color: #ff0000\">drop<br \/>\nuser linkc@localhost;<\/span><\/span>\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<strong>\u67e5\u770b\u8cc7\u6599\u5eab<\/strong><br \/>\n<span style=\"font-size: 15.8333px\"><span style=\"color: #ff0000\">show<br \/>\ndatabases;<\/span><\/span>\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<strong>\u522a\u9664\u8cc7\u6599\u5eab<\/strong><br \/>\n<span style=\"font-size: 15.8333px\"><span style=\"color: #ff0000\">drop<br \/>\ndatabase linkcdb;<\/span><\/span>\n<\/p>\n<p style=\"margin: 0px; padding: 0px 0px 12px; line-height: 27px\">\n<strong>\u67e5\u770b\u6b0a\u9650\u8a2d\u5b9a<\/strong><br \/>\n\u7528\u65b0\u589e\u7684\u4f7f\u7528\u8005\u767b\u5165 MySQL \uff0c\u518d\u7528<span>&nbsp;<\/span><span style=\"color: #ff0000\">show<br \/>\ndatabases;<\/span><span>&nbsp;<\/span>\u6307\u4ee4\uff0c\u5982\u679c\u770b\u4e0d\u5230\u65b0\u589e\u7684\u8cc7\u6599\u5eab\uff0c\u90a3\u5c31\u8868\u793a\u6b0a\u9650\u6c92\u8a2d\u597d\u3002\n<\/p>\n<p><\/span>\n<\/div>\n<p><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728Linux Server \u8981\u65b0\u5efa\u7acb\u50cfxoops\u3001joomla\u3001gallery &#8230;&#8230;\u7b49 [&hellip;]<\/p>\n","protected":false},"author":58,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3604","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"meta_key":{"lt_post_id":["105178"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/linkc\/wp-json\/wp\/v2\/posts\/3604"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/linkc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/linkc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/linkc\/wp-json\/wp\/v2\/users\/58"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/linkc\/wp-json\/wp\/v2\/comments?post=3604"}],"version-history":[{"count":0,"href":"https:\/\/2blog.ilc.edu.tw\/linkc\/wp-json\/wp\/v2\/posts\/3604\/revisions"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/linkc\/wp-json\/wp\/v2\/media?parent=3604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/linkc\/wp-json\/wp\/v2\/categories?post=3604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/linkc\/wp-json\/wp\/v2\/tags?post=3604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}