{"id":600,"date":"2020-04-28T05:55:22","date_gmt":"2020-04-27T22:55:22","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=600"},"modified":"2025-04-18T15:21:00","modified_gmt":"2025-04-18T08:21:00","slug":"cara-install-mysql-di-ubuntu-20-04","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/","title":{"rendered":"Cara Install MySQL di Ubuntu 20.04"},"content":{"rendered":"

MySQL<\/a> adalah sistem pengelolaan basis data relasional open-source yang paling populer. Terkenal akan kecepatan, penggunaan yang mudah, mudah untuk ditambah \/ dikurangi, dan merupakan bagian integral dari LAMP<\/code> dan LEMP<\/code>\u00a0stacks yang populer.<\/p>\n

Panduan ini menjelaskan cara menginstal dan mengamankan MySQL di Ubuntu 20.04.<\/p>\n

Prasyarat<\/h2>\n

Pastikan Anda masuk sebagai user dengan hak istimewa sudo<\/a>.<\/p>\n

Install MySQL di Ubuntu<\/h2>\n

Saat artikel ini ditulis, versi terbaru MySQL yang tersedia di repositori Ubuntu adalah\u00a0MySQL versi\u00a0<\/a>8.0. Untuk menginstalnya jalankan perintah berikut:<\/p>\n

sudo apt update
\nsudo apt install mysql-server<\/pre>\n
Setelah instalasi selesai, layanan MySQL akan dimulai secara otomatis. Untuk memverifikasi bahwa server MySQL berjalan, ketik:<\/p>\n
sudo systemctl status mysql<\/pre>\n
Output akan menunjukkan bahwa layanan MySQL telah diaktifkan dan berjalan:<\/p>\n
\u25cf mysql.service - MySQL Community Server
\n     Loaded: loaded (\/lib\/systemd\/system\/mysql.service; enabled; vendor preset: enabled)
\n     Active: active (running) since Tue 2020-04-28 20:59:52 UTC; 10min ago
\n   Main PID: 8617 (mysqld)
\n     Status: \"Server is operational\"
\n     ...<\/pre>\n
Mengamankan MySQL<\/h2>\n
Pada saat proses Instalasi, MySQL dilengkapi dengan skrip bernama mysql_secure_installation<\/code> yang memungkinkan Anda meningkatkan keamanan server database dengan mudah.<\/p>\n
Aktifkan skrip berikut ini di terminal:<\/p>\n
sudo mysql_secure_installation<\/pre>\n
Anda akan diminta untuk mengonfigurasi VALIDATE PASSWORD PLUGIN<\/code><\/a> yang digunakan untuk menguji kekuatan sandi pengguna MySQL dan meningkatkan keamanan:<\/p>\n
Securing the MySQL server deployment.
\n
\nConnecting to MySQL using a blank password.
\n
\nVALIDATE PASSWORD COMPONENT 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 component?
\n
\nPress y|Y for Yes, any other key for No: y
\n<\/pre>\n
Ada tiga tingkat kebijakan validasi kata sandi, low, medium, dan strong. ketik y<\/code> jika Anda ingin menyiapkan plugin kata sandi validasi atau kunci lainnya untuk melanjutkan ke langkah berikutnya:<\/p>\n
There 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: 2<\/pre>\n
Pada prompt berikutnya, Anda akan diminta untuk menyetel kata sandi untuk akun root MySQL:<\/p>\n
Please set the password for root here.
\n
\n
\nNew password: 
\n
\nRe-enter new password:<\/pre>\n
Jika Anda menyiapkan plugin validasi kata sandi, skrip akan menunjukkan kepada Anda kekuatan kata sandi baru Anda. Ketik y<\/code> untuk mengonfirmasi kata sandi:<\/p>\n
Estimated strength of the password: 50 
\nDo you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y<\/pre>\n
Selanjutnya, Anda akan diminta untuk menghapus pengguna anonim, membatasi akses pengguna root ke mesin lokal, menghapus database pengujian, dan memuat ulang tabel hak istimewa. Demi alasan keamanan, Anda harus menjawab y<\/code> untuk semua pertanyaan.<\/p>\n
Login sebagai root<\/h2>\n
Untuk berinteraksi dengan server MySQL dari baris perintah, gunakan utilitas MySQL MySQL client yang diinstal sebagai dependensi dari paket server MySQL.<\/p>\n
Di MySQL 8.0, akun root diautentikasi oleh plugin auth_socket<\/code> secara default.<\/p>\n
Plugin auth_socket<\/code> mengotentikasi pengguna yang terhubung dari localhost melalui file soket Unix. Ini berarti Anda tidak dapat mengautentikasi sebagai root dengan memberikan kata sandi.<\/p>\n
Untuk masuk ke server MySQL sebagai pengguna root ketik:<\/p>\n
sudo mysql<\/pre>\n
Anda akan disajikan dengan shell MySQL, seperti yang ditunjukkan di bawah ini:<\/p>\n
Welcome to the MySQL monitor.  Commands end with ; or \\g.
\nYour MySQL connection id is 12
\nServer version: 8.0.19-0ubuntu5 (Ubuntu)
\n
\nCopyright (c) 2000, 2020, 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><\/pre>\n
Jika Anda ingin login ke server MySQL Anda sebagai root menggunakan program eksternal seperti phpMyAdmin, Anda memiliki dua pilihan.<\/p>\n
Yang pertama adalah mengubah metode autentikasi dari auth_socket<\/code> ke mysql_native_password<\/code>. Anda dapat melakukannya dengan menjalankan perintah berikut:<\/p>\n
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Ganti_Dengan_Password_Anda';
\nFLUSH PRIVILEGES;<\/pre>\n
Opsi kedua yang disarankan adalah membuat pengguna baru dengan akses ke semua database:<\/p>\n
GRANT ALL PRIVILEGES ON *.* TO 'administrator'@'localhost' IDENTIFIED BY 'Ganti_Dengan_Password_Anda';<\/pre>\n
Kesimpulan<\/h2>\n
Kami telah menunjukkan kepada Anda cara install MySQL di Ubuntu 20.04. Setelah server database Anda aktif dan berjalan, langkah selanjutnya adalah mempelajari cara mengelola akun<\/a> dan database pengguna<\/a> MySQL.<\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL adalah sistem pengelolaan basis data relasional open-source yang paling populer. Terkenal akan kecepatan, penggunaan…<\/p>\n","protected":false},"author":2,"featured_media":601,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[41,9,82],"class_list":["post-600","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ubuntu","tag-mysql","tag-ubuntu","tag-ubuntu-20-04"],"yoast_head":"\nCara Install MySQL di Ubuntu 20.04 - 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:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Install MySQL di Ubuntu 20.04 - Linuxid\" \/>\n<meta property=\"og:description\" content=\"MySQL adalah sistem pengelolaan basis data relasional open-source yang paling populer. Terkenal akan kecepatan, penggunaan…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-27T22:55:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-18T08:21:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MySQL-di-Ubuntu-20.04.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"407\" \/>\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:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/\",\"url\":\"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/\",\"name\":\"Cara Install MySQL di Ubuntu 20.04 - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MySQL-di-Ubuntu-20.04.jpg\",\"datePublished\":\"2020-04-27T22:55:22+00:00\",\"dateModified\":\"2025-04-18T08:21:00+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MySQL-di-Ubuntu-20.04.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MySQL-di-Ubuntu-20.04.jpg\",\"width\":768,\"height\":407},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Install MySQL di Ubuntu 20.04\"}]},{\"@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":"Cara Install MySQL di Ubuntu 20.04 - 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:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Install MySQL di Ubuntu 20.04 - Linuxid","og_description":"MySQL adalah sistem pengelolaan basis data relasional open-source yang paling populer. Terkenal akan kecepatan, penggunaan…","og_url":"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/","og_site_name":"Linuxid","article_published_time":"2020-04-27T22:55:22+00:00","article_modified_time":"2025-04-18T08:21:00+00:00","og_image":[{"width":768,"height":407,"url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MySQL-di-Ubuntu-20.04.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:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/","url":"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/","name":"Cara Install MySQL di Ubuntu 20.04 - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/#primaryimage"},"image":{"@id":"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MySQL-di-Ubuntu-20.04.jpg","datePublished":"2020-04-27T22:55:22+00:00","dateModified":"2025-04-18T08:21:00+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MySQL-di-Ubuntu-20.04.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MySQL-di-Ubuntu-20.04.jpg","width":768,"height":407},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxid.net\/post\/cara-install-mysql-di-ubuntu-20-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Install MySQL di Ubuntu 20.04"}]},{"@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\/600","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=600"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/600\/revisions"}],"predecessor-version":[{"id":2610,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/600\/revisions\/2610"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/601"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}