{"id":660,"date":"2022-10-11T00:23:37","date_gmt":"2022-10-11T00:23:37","guid":{"rendered":"https:\/\/eka.smkn1pogalan.sch.id\/?p=660"},"modified":"2022-10-11T02:45:31","modified_gmt":"2022-10-11T02:45:31","slug":"instalasi-dan-konfigurasi-database-server","status":"publish","type":"post","link":"https:\/\/eka.smkn1pogalan.sch.id\/?p=660","title":{"rendered":"Instalasi dan Konfigurasi Database Server"},"content":{"rendered":"\n<p id=\"yui_3_17_2_1_1665447730198_1149\">1. Login sebagai user root<\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1380\">2.&nbsp;Instal paket&nbsp;<strong>Database server <\/strong><\/p>\n\n\n\n<pre id=\"yui_3_17_2_1_1665447730198_1384\" class=\"wp-block-preformatted\"><strong>\"apt install mariadb-server mariadb-client php-mysql\"<\/strong><\/pre>\n\n\n\n<p><strong><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image.png\" alt=\"\"><\/strong><\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1390\"><strong>3.&nbsp;<\/strong>Masukkan dvd yang diminta<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%281%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%282%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1398\">4. Pastikan proses installasi selesai sampai akhir<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1401\"><strong>Jika sudah selesai melakukan installasi, lanjutkan pada konfigurasi MySQL dan Phpmyadmin<\/strong><\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1402\">1.&nbsp;<strong>Seting Database MySQL (User, Password, Database)<\/strong><\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1404\">Memberikan Privileges (hak akses) kepada user root untuk dapat mengelola seluruh database.<br>user login :&nbsp;root<br>password :&nbsp;paswdroot<\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1411\">a. Masukkan perintah&nbsp;<\/p>\n\n\n\n<pre id=\"yui_3_17_2_1_1665447730198_1413\" class=\"wp-block-preformatted\"><code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">mysql -u root<\/mark><\/code><\/pre>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1414\">b. Selanjutnya masukkan&nbsp;<\/p>\n\n\n\n<pre id=\"yui_3_17_2_1_1665447730198_1416\" class=\"wp-block-preformatted\"><code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY \"paswdroot\";<\/mark><\/code><\/pre>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1417\">c. jika sudah, keluar dengan perintah &#8220;quit&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%283%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1423\"><strong>2.&nbsp;Instalasi PHP pada debian<\/strong><\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1425\">a. Masukkan perintah berikut ini untuk menginstall php pada debian<\/p>\n\n\n\n<pre id=\"yui_3_17_2_1_1665447730198_1429\" class=\"wp-block-preformatted\">\"<code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">apt install php php-cgi php-mysqli php-pear php-mbstring php-gettext libapache2-mod-php php-common php-phpseclib php-mysql -y<\/mark><\/code>\"<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%284%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1431\">b. Masukkan dvd yang diminta oleh debian<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%285%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%286%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1439\">c. Lihat versi php yang telah di install dengan perintah &#8220;<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">php &#8211;version<\/mark>&#8220;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%287%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1445\">d. Php sudah selesai diinstall<\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1451\"><strong><\/strong><\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1454\"><strong>3. Installasi PhpMyadmin pada debian<\/strong><\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1665447730198_1456\">a. Unduh terlebih dahulu file PhpMyadmin melalui link berikut ini&nbsp;<\/p>\n\n\n\n<p><a href=\"https:\/\/www.phpmyadmin.net\/downloads\/phpMyAdmin-latest-all-languages.tar.gz\">https:\/\/www.phpmyadmin.net\/downloads\/phpMyAdmin-latest-all-languages.tar.gz<\/a><\/p>\n\n\n\n<p>b. Jika sudah diunduh, unggah file tersebut ke debian dengan menggunakan FTP<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%288%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>c. Ekstrak file tersebut dengan perintah &#8220;<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">tar -xzvf nama_file.tar.gz<\/mark>&#8220;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%289%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>d. Setelah diekstrak pindahkan folder hasil ekstrak phpMyAdmin ke folder default dari http (dari folder&nbsp;<strong><em>phpMyAdmin-5.1.2-all-languages<\/em><\/strong>&nbsp;menjadi folder&nbsp;<strong><em>phpmyadmin<\/em><\/strong>).&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%2810%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Serta&nbsp;Copy file&nbsp;<strong><em>config.sample.inc.php<\/em><\/strong>&nbsp;menjadi&nbsp;<strong><em>config.inc.php<\/em><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%2811%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>e.&nbsp;Masukan kode blowfish_secret&nbsp;<em><strong>&nbsp;&#8216;RfMd2oX7L7vT9Ls6fkuM0KwY;9gcho3C&#8217;<\/strong><\/em>&nbsp;&nbsp; ke dalam file&nbsp;<strong>config.inc.php<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%2812%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%2813%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>f. Selanjutnya file tersebut dengan perintah seperti biasanya<br>g.&nbsp;Buat folder&nbsp;<strong><em>tmp<\/em><\/strong>&nbsp;di dalam folder&nbsp;<strong>phpmyadmin<\/strong>&nbsp;kemudian rubah kepemilkannya ke user&nbsp;<strong>www-data<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%2814%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%2815%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>h. Selanjutnya restart apache2 dengan perintah &#8220;service apache2 restart&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%2816%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>PENGUJIAN DI BROWSER PADA CLIENT<br>akses alamat ip server\/phpmyadmin pada browser<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%2817%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>akses juga menggunakan Domain\/phpmyadmin<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/elearning.smkn1pogalan.sch.id\/draftfile.php\/2188\/user\/draft\/719680465\/image%20%2818%29.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Coba login menggunakan user root dan password yang sudah dibuat ketika konfigurasi MySql diawal tadi. Jika user dan password yang digunakan login sudah benar maka akan muncul tampilan seperti berikut ini.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"567\" src=\"https:\/\/eka.smkn1pogalan.sch.id\/wp-content\/uploads\/2022\/10\/image-1024x567.png\" alt=\"\" class=\"wp-image-672\" srcset=\"https:\/\/eka.smkn1pogalan.sch.id\/wp-content\/uploads\/2022\/10\/image-1024x567.png 1024w, https:\/\/eka.smkn1pogalan.sch.id\/wp-content\/uploads\/2022\/10\/image-300x166.png 300w, https:\/\/eka.smkn1pogalan.sch.id\/wp-content\/uploads\/2022\/10\/image-768x425.png 768w, https:\/\/eka.smkn1pogalan.sch.id\/wp-content\/uploads\/2022\/10\/image.png 1312w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>SELAMAT ANDA TELAH SELESAI MELAKUKAN INSTALLASI DAN KONFIGURASI DATABASES SERVER<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Login sebagai user root 2.&nbsp;Instal paket&nbsp;Database server &#8220;apt install mariadb-server mariadb-client php-mysql&#8221; 3.&nbsp;Masukkan dvd yang diminta 4. Pastikan proses installasi selesai sampai akhir Jika sudah selesai melakukan installasi, lanjutkan pada konfigurasi MySQL dan Phpmyadmin 1.&nbsp;Seting Database MySQL (User, Password, Database) Memberikan Privileges (hak akses) kepada user root untuk dapat mengelola seluruh database.user login :&nbsp;rootpassword [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"_links":{"self":[{"href":"https:\/\/eka.smkn1pogalan.sch.id\/index.php?rest_route=\/wp\/v2\/posts\/660"}],"collection":[{"href":"https:\/\/eka.smkn1pogalan.sch.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eka.smkn1pogalan.sch.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eka.smkn1pogalan.sch.id\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eka.smkn1pogalan.sch.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=660"}],"version-history":[{"count":10,"href":"https:\/\/eka.smkn1pogalan.sch.id\/index.php?rest_route=\/wp\/v2\/posts\/660\/revisions"}],"predecessor-version":[{"id":691,"href":"https:\/\/eka.smkn1pogalan.sch.id\/index.php?rest_route=\/wp\/v2\/posts\/660\/revisions\/691"}],"wp:attachment":[{"href":"https:\/\/eka.smkn1pogalan.sch.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eka.smkn1pogalan.sch.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eka.smkn1pogalan.sch.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}