{"id":130,"date":"2017-11-24T08:00:04","date_gmt":"2017-11-23T23:00:04","guid":{"rendered":"http:\/\/www.itc109.com\/knowledge\/?p=130"},"modified":"2021-09-30T09:00:03","modified_gmt":"2021-09-30T00:00:03","slug":"mysql-database-list","status":"publish","type":"post","link":"https:\/\/www.itc109.com\/knowledge\/database\/mysql-database-list","title":{"rendered":"MySQL &#8211; \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7\u306e\u78ba\u8a8d"},"content":{"rendered":"<h4><strong>\u6982\u8981<\/strong><\/h4>\n<hr \/>\n<p>MySQL\u306b\u4f5c\u6210\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7\u3092\u8868\u793a\u3059\u308b\u624b\u9806\u306b\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><strong>\u624b\u9806<\/strong><\/h4>\n<hr \/>\n<h5><strong>MySQL\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u307e\u3059\u3002<\/strong><\/h5>\n<p>\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<pre>\r\nmysql -h %END_POINT% -P 3306 -u %DB_USER% -p %DB_NAME%\r\n<\/pre>\n<p>\u5b9f\u884c\u7d50\u679c<\/p>\n<pre>\r\nmysql>\r\n<\/pre>\n<p>&nbsp;<\/p>\n<h5><strong>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/strong><\/h5>\n<p>\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<pre>\r\nshow databases;\r\n<\/pre>\n<p>\u5b9f\u884c\u7d50\u679c\u3000<span style=\"color: #ff0000;\">\u203b\u30b5\u30f3\u30d7\u30eb\u3067\u3059<\/span><\/p>\n<pre>\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| infratest          |\r\n| innodb             |\r\n| mysql              |\r\n| performance_schema |\r\n| sys                |\r\n+--------------------+\r\n6 rows in set (0.00 sec)\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981 MySQL\u306b\u4f5c\u6210\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7\u3092\u8868\u793a\u3059\u308b\u624b\u9806\u306b\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u3066\u3044\u307e\u3059\u3002 &nbsp; &nbsp; \u624b\u9806 MySQL\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u307e\u3059\u3002 \u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002 mysql -h %END_POINT&#8230;<\/p>\n","protected":false},"author":3,"featured_media":46,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[23],"tags":[54],"class_list":["post-130","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.itc109.com\/knowledge\/wp-content\/uploads\/sites\/2\/logo\/logo-mysql.png","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pacZwp-26","_links":{"self":[{"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/posts\/130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":7,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":1791,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/posts\/130\/revisions\/1791"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/media\/46"}],"wp:attachment":[{"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}