{"id":15179,"date":"2024-10-15T17:12:50","date_gmt":"2024-10-15T09:12:50","guid":{"rendered":"http:\/\/i-services.info\/wordpress\/?p=15179"},"modified":"2024-10-15T17:14:04","modified_gmt":"2024-10-15T09:14:04","slug":"%e3%80%90jamf-pro%e3%80%91%e5%8d%87%e7%b4%9a-jamf-pro-%e5%89%8d%ef%bc%8c%e5%a6%82%e4%bd%95%e6%9f%a5%e8%a9%a2-jamf-pro-mysql-db-%e7%9a%84%e5%9b%9e%e6%87%89%e7%8b%80%e6%85%8b%ef%bc%9f","status":"publish","type":"post","link":"http:\/\/i-services.info\/wordpress\/?p=15179","title":{"rendered":"\u3010Jamf Pro\u3011\u5347\u7d1a Jamf Pro \u524d\uff0c\u5982\u4f55\u67e5\u8a62 Jamf Pro MySQL DB \u7684\u56de\u61c9\u72c0\u614b\uff1f"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>1. \u4ee5\u7cfb\u7d71\u7ba1\u7406\u54e1\u8eab\u5206\u958b\u555f CMD (\u547d\u4ee4\u63d0\u793a\u5b57\u5143)\uff0c\u5207\u63db\u81f3 MySQL \u8def\u5f91\u5230 bin \u4e2d\uff0c\u9810\u8a2d\u8def\u5f91\uff1a<strong><font color=\"#0000ff\">C:\\Program Files\\MySQL\\MySQL Server 8.0\\bin<\/font><\/strong> \u3002 <\/p>\n<p><a href=\"http:\/\/i-services.info\/wordpress\/wp-content\/uploads\/2024\/10\/image.png\"><img loading=\"lazy\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"http:\/\/i-services.info\/wordpress\/wp-content\/uploads\/2024\/10\/image_thumb.png\" width=\"889\" height=\"580\"><\/a> <\/p>\n<p>&nbsp; <\/p>\n<p>2. \u767b\u5165MySQL\u3002\u8f38\u5165\u6307\u4ee4\uff1a<strong><font color=\"#0000ff\">mysql -u root \u2013p<\/font> <\/strong>\u5f8c\u6309<strong> Enter \u9375<\/strong>\uff0c\u7136\u5f8c\u8f38\u5165<strong><font color=\"#0000ff\"> root \u5bc6\u78bc<\/font><\/strong>\u3002 <\/p>\n<p><a href=\"http:\/\/i-services.info\/wordpress\/wp-content\/uploads\/2024\/10\/image-1.png\"><img loading=\"lazy\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"http:\/\/i-services.info\/wordpress\/wp-content\/uploads\/2024\/10\/image_thumb-1.png\" width=\"886\" height=\"581\"><\/a> <\/p>\n<p>&nbsp; <\/p>\n<p>3. \u6aa2\u67e5 Jamf Pro \u6240\u4f7f\u7528\u7684DB\uff0c\u8f38\u5165\u6307\u4ee4\uff1a<font color=\"#0000ff\"><strong>show databases; <\/strong><font color=\"#000000\">\u5f8c\u6309<\/font><strong> Enter \u9375<\/strong><\/font><font color=\"#000000\">\u3002<\/font> <\/p>\n<p><a href=\"http:\/\/i-services.info\/wordpress\/wp-content\/uploads\/2024\/10\/image-2.png\"><img loading=\"lazy\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"http:\/\/i-services.info\/wordpress\/wp-content\/uploads\/2024\/10\/image_thumb-2.png\" width=\"894\" height=\"582\"><\/a> <\/p>\n<p><strong>&nbsp;<\/strong> <\/p>\n<p>4. \u9032\u5165JamfDB\uff0c\u8f38\u5165\u6307\u4ee4\uff1a<b><font color=\"#0000ff\">use jamfdb;<\/font> <font color=\"#0000ff\"><font color=\"#000000\">\u5f8c\u6309<\/font><strong> Enter \u9375<\/strong><\/font><font color=\"#000000\">\u3002<\/font><\/b> <\/p>\n<p><a href=\"http:\/\/i-services.info\/wordpress\/wp-content\/uploads\/2024\/10\/image-3.png\"><img loading=\"lazy\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"http:\/\/i-services.info\/wordpress\/wp-content\/uploads\/2024\/10\/image_thumb-3.png\" width=\"900\" height=\"513\"><\/a> <\/p>\n<p><strong><font color=\"#000000\">&nbsp;<\/font><\/strong> <\/p>\n<p>5. \u67e5\u8a62 Jamf Pro \u6240\u4f7f\u7528\u7684 MySQL DB \u56de\u61c9\u72c0\u614b\uff0c\u8f38\u5165\u4ee5\u4e0b\u6307\u4ee4\u5f8c<font color=\"#000000\">\u6309<\/font><strong> <font color=\"#0000ff\">Enter \u9375<\/font><\/strong>\uff1a <\/p>\n<p><b><font color=\"#0000ff\">select distinct f.report_id from fonts f inner join computers_denormalized cd ON f.report_id = cd.last_report_id where f.font_path IS NULL;<\/font> <\/b> <\/p>\n<p>&nbsp; <\/p>\n<p>\u986f\u793a\uff1a<strong><font color=\"#0000ff\">Empty set(0.01 sec)<\/font><\/strong>&nbsp; \u8868\u793a\u6b63\u5e38\u6c92\u554f\u984c\uff01 <\/p>\n<p>\u986f\u793a\u5176\u4ed6\u6578\u503c\u4fbf\u8981\u8207 <a href=\"https:\/\/support.jamf.com\" target=\"_blank\" rel=\"noopener\">Jamf Support<\/a> \u806f\u7e6b\u4f86\u9032\u884c\u76f8\u95dc\u8655\u7406\uff01 <\/p>\n<p><a href=\"http:\/\/i-services.info\/wordpress\/wp-content\/uploads\/2024\/10\/image-4.png\"><img loading=\"lazy\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"http:\/\/i-services.info\/wordpress\/wp-content\/uploads\/2024\/10\/image_thumb-4.png\" width=\"893\" height=\"584\"><\/a><\/p>\n<div class=\"linkwithin_hook\" id=\"http:\/\/i-services.info\/wordpress\/?p=15179\"><\/div><script>\n<!-- \/\/LinkWithinCodeStart\nvar linkwithin_site_id = 2246677;\nvar linkwithin_div_class = \"linkwithin_hook\";\n\/\/LinkWithinCodeEnd -->\n<\/script>\n<script src=\"http:\/\/www.linkwithin.com\/widget.js\"><\/script>\n<a href=\"http:\/\/www.linkwithin.com\/\"><img src=\"http:\/\/www.linkwithin.com\/pixel.png\" alt=\"Related Posts Plugin for WordPress, Blogger...\" style=\"border: 0\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>&nbsp; 1. \u4ee5\u7cfb\u7d71\u7ba1\u7406\u54e1\u8eab\u5206\u958b\u555f CMD (\u547d\u4ee4\u63d0\u793a\u5b57\u5143)\uff0c\u5207\u63db\u81f3 MySQL \u8def\u5f91\u5230 bin \u4e2d\uff0c\u9810\u8a2d\u8def\u5f91\uff1aC:\\Program Files\\MySQL\\MySQL Server 8.0\\bin \u3002 &nbsp; 2. \u767b\u5165MyS&#46;&#46;&#46;<\/p>\n<script>\n<!-- \/\/LinkWithinCodeStart\nvar linkwithin_site_id = 2246677;\nvar linkwithin_div_class = \"linkwithin_hook\";\n\/\/LinkWithinCodeEnd -->\n<\/script>\n<script src=\"http:\/\/www.linkwithin.com\/widget.js\"><\/script>\n<a href=\"http:\/\/www.linkwithin.com\/\"><img src=\"http:\/\/www.linkwithin.com\/pixel.png\" alt=\"Related Posts Plugin for WordPress, Blogger...\" style=\"border: 0\" \/><\/a>","protected":false},"author":4,"featured_media":15170,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[176],"tags":[],"_links":{"self":[{"href":"http:\/\/i-services.info\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/15179"}],"collection":[{"href":"http:\/\/i-services.info\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/i-services.info\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/i-services.info\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/i-services.info\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15179"}],"version-history":[{"count":1,"href":"http:\/\/i-services.info\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/15179\/revisions"}],"predecessor-version":[{"id":15180,"href":"http:\/\/i-services.info\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/15179\/revisions\/15180"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/i-services.info\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/15170"}],"wp:attachment":[{"href":"http:\/\/i-services.info\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/i-services.info\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15179"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/i-services.info\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}