{"id":1885,"date":"2019-03-18T12:36:49","date_gmt":"2019-03-18T05:36:49","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1885"},"modified":"2025-03-28T22:41:13","modified_gmt":"2025-03-28T15:41:13","slug":"tutorial-cara-install-mysql-5-7-di-amazon-linux","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/","title":{"rendered":"Tutorial Cara Install MySQL 5.7 di Amazon Linux"},"content":{"rendered":"

MySQL adalah sistem database relasional. Dalam tutorial kami sebelumnya, Anda menginstal Apache dan PHP di Amazon Linux<\/a>. Tutorial ini akan membantu Anda menginstal MySQL 5.7 di sistem Amazon Linux.<\/p>\n

Langkah 1 \u2013 Persiapan<\/h2>\n

Login ke sistem Fedora Anda dan buka terminal. Sekarang perbarui paket saat ini ke versi terbaru dengan menjalankan perintah berikut.<\/p>\n

yum update
\n<\/pre>\n
Langkah 2 \u2013 Install MySQL Server<\/h2>\n
Setelah itu jalankan perintah berikut untuk menginstal paket MySQL 5.7 pada sistem Anda. Ini juga akan menginstal semua dependensi yang diperlukan lainnya.<\/p>\n
yum install mysql57-server
\n<\/pre>\n
\"Tutorial<\/a><\/p>\n
Setelah instalasi server MySQL pada sistem Fedora. Aktifkan layanan MySQL untuk memulai secara otomatis saat sistem boot. Juga, mulai layanan menggunakan perintah di bawah ini::<\/p>\n
service mysqld start
\nchkconfig mysqld on
\n<\/pre>\n
Oke, sekarang ikuti instruksi pasca instalasi.<\/p>\n
Langkah 3 \u2013 Konfigurasi MySQL<\/h2>\n
MySQL community server telah diinstal pada sistem Anda. Sekarang jalankan perintah berikut untuk menerapkan keamanan di server MySQL. Cukup jalankan perintah di bawah ini dan ikuti wizard keamanan.<\/p>\n
mysql_secure_installation
\n<\/pre>\n
Ikuti instruksi pada layar. Ubah kata sandi akun root Anda dan Tekan Y untuk semua operasi lain untuk menerapkan keamanan yang ditingkatkan.<\/p>\n
VALIDATE PASSWORD PLUGIN can be used to test passwords
\nand improve security. It checks the strength of password
\nand allows the users to set only those passwords which are
\nsecure enough. Would you like to setup VALIDATE PASSWORD plugin?
\n
\nPress y|Y for Yes, any other key for No: y<\/strong>
\n
\nThere are three levels of password validation policy:
\n
\nLOW    Length >= 8
\nMEDIUM Length >= 8, numeric, mixed case, and special characters
\nSTRONG Length >= 8, numeric, mixed case, special characters and dictionary       file
\n
\nPlease enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 0<\/strong><\/span>
\nPlease set the password for root here.
\n
\nNew password:
\n
\nRe-enter new password:
\n
\nEstimated strength of the password: 100
\nDo you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y<\/strong><\/span>
\nBy default, a MySQL installation has an anonymous user,
\nallowing anyone to log into MySQL without having to have
\na user account created for them. This is intended only for
\ntesting, and to make the installation go a bit smoother.
\nYou should remove them before moving into a production
\nenvironment.
\n
\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : y<\/strong><\/span>
\nSuccess.
\n
\n
\nNormally, root should only be allowed to connect from
\n'localhost'. This ensures that someone cannot guess at
\nthe root password from the network.
\n
\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y<\/strong><\/span>
\nSuccess.
\n
\nBy default, MySQL comes with a database named 'test' that
\nanyone can access. This is also intended only for testing,
\nand should be removed before moving into a production
\nenvironment.
\n
\n
\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) : y<\/strong><\/span>
\n - Dropping test database...
\nSuccess.
\n
\n - Removing privileges on test database...
\nSuccess.
\n
\nReloading the privilege tables will ensure that all changes
\nmade so far will take effect immediately.
\n
\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y<\/strong><\/span>
\nSuccess.
\n
\nAll done!
\n<\/span><\/pre>\n
Langkah 4 \u2013 Konek ke MySQL via Terminal<\/h2>\n
Semua selesai. Anda sekarang dapat terhubung ke server MySQL menggunakan baris perintah. Perintah berikut akan menghubungkan MySQL yang berjalan di localhost sebagai pengguna root. Sebelum login, MySQL akan meminta kata sandi akun root.<\/p>\n
mysql -u root -p<\/strong>
\n
\nEnter password:
\nWelcome to the MySQL monitor.  Commands end with ; or \\g.
\nYour MySQL connection id is 5
\nServer version: 5.7.25 MySQL Community Server (GPL)
\n
\nCopyright (c) 2000, 2019, Oracle and\/or its affiliates. All rights reserved.
\n
\nOracle is a registered trademark of Oracle Corporation and\/or its
\naffiliates. Other names may be trademarks of their respective
\nowners.
\n
\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.
\n
\nmysql>
\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
MySQL adalah sistem database relasional. Dalam tutorial kami sebelumnya, Anda menginstal Apache dan PHP di…<\/p>\n","protected":false},"author":2,"featured_media":1886,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[255,72,41],"class_list":["post-1885","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-terminal","tag-amazon-linux","tag-linux-terminal","tag-mysql"],"yoast_head":"\nTutorial Cara Install MySQL 5.7 di Amazon Linux - Linuxid<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tutorial Cara Install MySQL 5.7 di Amazon Linux - Linuxid\" \/>\n<meta property=\"og:description\" content=\"MySQL adalah sistem database relasional. Dalam tutorial kami sebelumnya, Anda menginstal Apache dan PHP di…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-18T05:36:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-28T15:41:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/MySQL-5.7-di-Amazon-Linux.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"667\" \/>\n\t<meta property=\"og:image:height\" content=\"220\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"xsand\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"xsand\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/\",\"url\":\"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/\",\"name\":\"Tutorial Cara Install MySQL 5.7 di Amazon Linux - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/MySQL-5.7-di-Amazon-Linux.jpg\",\"datePublished\":\"2019-03-18T05:36:49+00:00\",\"dateModified\":\"2025-03-28T15:41:13+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/MySQL-5.7-di-Amazon-Linux.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/MySQL-5.7-di-Amazon-Linux.jpg\",\"width\":667,\"height\":220},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tutorial Cara Install MySQL 5.7 di Amazon Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/linuxid.net\/post\/#website\",\"url\":\"https:\/\/linuxid.net\/post\/\",\"name\":\"Linuxid\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/linuxid.net\/post\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\",\"name\":\"xsand\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"caption\":\"xsand\"},\"url\":\"https:\/\/www.linuxid.net\/post\/author\/xsand\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tutorial Cara Install MySQL 5.7 di Amazon Linux - Linuxid","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/","og_locale":"id_ID","og_type":"article","og_title":"Tutorial Cara Install MySQL 5.7 di Amazon Linux - Linuxid","og_description":"MySQL adalah sistem database relasional. Dalam tutorial kami sebelumnya, Anda menginstal Apache dan PHP di…","og_url":"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/","og_site_name":"Linuxid","article_published_time":"2019-03-18T05:36:49+00:00","article_modified_time":"2025-03-28T15:41:13+00:00","og_image":[{"width":667,"height":220,"url":"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/MySQL-5.7-di-Amazon-Linux.jpg","type":"image\/jpeg"}],"author":"xsand","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"xsand","Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/","url":"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/","name":"Tutorial Cara Install MySQL 5.7 di Amazon Linux - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/#primaryimage"},"image":{"@id":"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/MySQL-5.7-di-Amazon-Linux.jpg","datePublished":"2019-03-18T05:36:49+00:00","dateModified":"2025-03-28T15:41:13+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/MySQL-5.7-di-Amazon-Linux.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/MySQL-5.7-di-Amazon-Linux.jpg","width":667,"height":220},{"@type":"BreadcrumbList","@id":"https:\/\/linuxid.net\/post\/tutorial-cara-install-mysql-5-7-di-amazon-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Tutorial Cara Install MySQL 5.7 di Amazon Linux"}]},{"@type":"WebSite","@id":"https:\/\/linuxid.net\/post\/#website","url":"https:\/\/linuxid.net\/post\/","name":"Linuxid","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linuxid.net\/post\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79","name":"xsand","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","caption":"xsand"},"url":"https:\/\/www.linuxid.net\/post\/author\/xsand\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/comments?post=1885"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1885\/revisions"}],"predecessor-version":[{"id":2499,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1885\/revisions\/2499"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1886"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}