{"id":210,"date":"2015-08-27T23:10:34","date_gmt":"2015-08-27T15:10:34","guid":{"rendered":"https:\/\/drho.club\/?p=210"},"modified":"2015-08-27T23:10:34","modified_gmt":"2015-08-27T15:10:34","slug":"clipbucket-database-mysql","status":"publish","type":"post","link":"https:\/\/104.es\/index.php\/2015\/08\/27\/clipbucket-database-mysql\/","title":{"rendered":"\u5efa\u7acb\u4e00\u500b\u8981\u7d66ClipBucket\u7528\u7684\u8cc7\u6599\u5eab\u548c\u4f7f\u7528\u8005"},"content":{"rendered":"<p>\u8981\u5728\u81ea\u5df1\u7684\u4f5c\u696d\u7cfb\u7d71\u4e2d\u5b89\u88ddClipBucket\uff0c\u9664\u4e86\u4e4b\u524d\u7684\u4e00\u4e9b\u6a21\u7d44\u8981\u4e00\u500b\u4e00\u500b\u6e96\u5099\u597d\u4e4b\u5916\uff0c\u53e6\u5916\u5c31\u662f\u8981\u6709\u4e00\u500b\u8cc7\u6599\u5eab\u4f9b\u7cfb\u7d71\u4f7f\u7528\u3002\u7576\u7136\uff0c\u4f60\u7684\u7cfb\u7d71\u4e00\u5b9a\u8981\u5148\u6709httpd\u548cmysqld\u624d\u884c\u3002\u8981\u5b89\u88dd\u9019\u5169\u500b\u5012\u4e0d\u662f\u96e3\u4e8b\uff0c\u6b65\u9a5f\u5982\u4e0b\uff1a<\/p>\n<p>[code]<br \/>\nyum install httpd<br \/>\nsystemctl start httpd<br \/>\nsystemctl enable httpd<br \/>\nyum install mariadb-server mariadb<br \/>\nsystemctl start mariadb<br \/>\nsystemctl enable mariadb<\/p>\n<p>[\/code]<\/p>\n<p>\u5728\u9806\u5229\u5b89\u88dd\u5b8c\u6210\u4e26\u555f\u52d5\u4e4b\u5f8c\uff0c\u5728\u9810\u8a2d\u7684\u60c5\u6cc1\u4e0b\u6240\u6709\u7684\u7db2\u9801\u8cc7\u8a0a\u90fd\u662f\u653e\u5728\/var\/www\/html\u4e4b\u5916\uff0c\u5230\u6642\u5019\u53ea\u8981\u628a\u5728ClipBucket\u4e0b\u8f09\u7684\u6a94\u6848\u89e3\u58d3\u7e2e\u4e4b\u5f8c\u653e\u5728\u9019\u500b\u76ee\u9304\u4e4b\u4e0b\u5373\u53ef\u3002\u53e6\u5916\uff0c\u8981\u5efa\u7acb\u4e00\u500b\u65b0\u7684\u8cc7\u6599\u5eab\u4ee5\u53ca\u4f7f\u7528\u8005\u7d66ClipBucket\uff0c\u6b65\u9a5f\u5982\u4e0b\uff1a<\/p>\n<p>[code]<br \/>\nmysqladmin -u root password &#8216;xxxxxxxx&#8217;<br \/>\nmysql -uroot -pxxxxxxxx<br \/>\nmysql&gt;CREATE DATABASE cbdatabase;<br \/>\nmysql&gt;GRANT ALL PRIVILEGES ON cbdatabase.* TO &quot;dbadmin&quot;@&quot;localhost&quot; IDENTIFIED BY &#8216;xxxxxxxx&#8217;;<br \/>\nmysql&gt;exit<br \/>\n[\/code]<\/p>\n<p>\u5176\u4e2dxxxxxxxx\u662f\u5bc6\u78bc\uff0c\u8acb\u4f7f\u7528\u81ea\u5df1\u7684\u5373\u53ef\u3002\u6b64\u5916\uff0c\u9084\u6709 PHP \u4e5f\u8981\u5b89\u88dd\u4e0a\u53bb\u624d\u884c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8981\u5728\u81ea\u5df1\u7684\u4f5c\u696d\u7cfb\u7d71\u4e2d\u5b89\u88ddClipBucket\uff0c\u9664\u4e86\u4e4b\u524d\u7684\u4e00\u4e9b\u6a21\u7d44\u8981\u4e00\u500b\u4e00\u500b\u6e96\u5099\u597d\u4e4b\u5916\uff0c\u53e6\u5916\u5c31\u662f\u8981\u6709\u4e00\u500b\u8cc7\u6599\u5eab\u4f9b\u7cfb\u7d71\u4f7f\u7528\u3002\u7576\u7136\uff0c\u4f60\u7684\u7cfb\u7d71\u4e00\u5b9a\u8981\u5148\u6709httpd\u548cmysqld\u624d\u884c\u3002\u8981\u5b89\u88dd\u9019\u5169\u500b\u5012\u4e0d\u662f\u96e3\u4e8b<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[95],"tags":[110,121,47],"class_list":["post-210","post","type-post","status-publish","format-standard","hentry","category-clipbucket","tag-apache","tag-clipbucket","tag-mysql"],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/104.es\/index.php\/wp-json\/wp\/v2\/posts\/210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/104.es\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/104.es\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/104.es\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/104.es\/index.php\/wp-json\/wp\/v2\/comments?post=210"}],"version-history":[{"count":0,"href":"https:\/\/104.es\/index.php\/wp-json\/wp\/v2\/posts\/210\/revisions"}],"wp:attachment":[{"href":"https:\/\/104.es\/index.php\/wp-json\/wp\/v2\/media?parent=210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/104.es\/index.php\/wp-json\/wp\/v2\/categories?post=210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/104.es\/index.php\/wp-json\/wp\/v2\/tags?post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}