{"id":7333,"date":"2026-08-20T18:28:35","date_gmt":"2026-08-20T16:28:35","guid":{"rendered":"https:\/\/www.webhostingsrbija.rs\/?p=7333"},"modified":"2026-08-20T18:28:35","modified_gmt":"2026-08-20T16:28:35","slug":"mysql-baze","status":"publish","type":"post","link":"https:\/\/www.webhostingsrbija.rs\/en\/mysql-baze\/","title":{"rendered":"MySQL database in WHSPanel"},"content":{"rendered":"<p>MySQL baze \u010duvaju strukturirane podatke tvojih aplikacija (WordPress, Magento, prodavnice, prilago\u0111ene aplikacije). U ovom delu panela pravi\u0161 baze, korisnike baza i upravlja\u0161 njihovim dozvolama. Imena baza i korisnika se automatski prefiksuju imenom tvog naloga (na primer <code>whsuser_<\/code>) da ne bi bilo sudara sa drugim korisnicima na serveru.<\/p>\n\n<h2>1. Pregled<\/h2>\n<p>U meniju otvori <strong>Databases<\/strong> well <strong>MySQL baze<\/strong>. Na vrhu su tri kartice: <strong>Databases<\/strong> (koliko ih ima\u0161), <strong>Ukupna veli\u010dina<\/strong> and <strong>Korisnici baza<\/strong>. Ispod su dve tabele: spisak baza (svaka sa svojim akcijama) i spisak korisnika.<\/p>\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a8775f4e534a&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a8775f4e534a\" class=\"wp-block-image size-large wp-lightbox-container\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"822\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-populated-a-1024x822.png\" alt=\"MySQL upravljanje u WHSPanelu\" class=\"wp-image-7531\" title=\"\" srcset=\"https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-populated-a-1024x822.png 1024w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-populated-a-300x241.png 300w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-populated-a-768x617.png 768w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-populated-a-1536x1233.png 1536w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-populated-a-2048x1644.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><figcaption class=\"wp-block-image__caption\">Populisano stanje: baze i korisnici sa svim akcijama.<\/figcaption><\/figure>\n\n\n<h2>2. Najlak\u0161i na\u010din: \u010carobnjak za baze<\/h2>\n<p>Click <strong>\u010carobnjak za baze<\/strong> da u \u010detiri koraka napravi\u0161 bazu, korisnika i dodeli\u0161 privilegije odjednom (Baza podataka, Korisnik, Privilegije, Zavr\u0161eno).<\/p>\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a8775f4e56f6&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a8775f4e56f6\" class=\"wp-block-image size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"840\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-wizard-p-1024x840.png\" alt=\"MySQL \u010darobnjak za baze\" class=\"wp-image-7532\" title=\"\" srcset=\"https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-wizard-p-1024x840.png 1024w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-wizard-p-300x246.png 300w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-wizard-p-768x630.png 768w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-wizard-p-1536x1260.png 1536w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-wizard-p-2048x1680.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><figcaption class=\"wp-block-image__caption\">\u010carobnjak: baza, korisnik i privilegije u \u010detiri koraka.<\/figcaption><\/figure>\n\n\n<h2>3. Ru\u010dno pravljenje<\/h2>\n<ul>\n<li><strong>Kreiraj bazu podataka:<\/strong> upi\u0161i naziv (dozvoljeni su samo slova, brojevi i donje crte). Baza se pojavi u tabeli.<\/li>\n<li><strong>Kreiraj korisnika:<\/strong> napravi zaseban korisni\u010dki nalog baze sa lozinkom.<\/li>\n<\/ul>\n\n<h2>4. Akcije nad bazom<\/h2>\n<p>Kod svake baze u tabeli su dugmad:<\/p>\n<table>\n<thead><tr><th>Akcija<\/th><th>\u0160ta radi<\/th><\/tr><\/thead>\n<tbody>\n<tr><td><strong>Izvezi<\/strong><\/td><td>Preuzima celu bazu kao <code>.sql<\/code> fajl, za rezervnu kopiju ili selidbu na drugi server.<\/td><\/tr>\n<tr><td><strong>Udaljeni pristup<\/strong><\/td><td>Kontroli\u0161e koje spoljne IP adrese smeju da se pove\u017eu na bazu izvan servera (za povezivanje sa drugog servera ili sa desktop alata).<\/td><\/tr>\n<tr><td><strong>Privilegije<\/strong><\/td><td>Odre\u0111uje kojim korisnicima je baza dostupna i koje operacije smeju (obja\u0161njeno ispod).<\/td><\/tr>\n<tr><td><strong>phpMyAdmin<\/strong><\/td><td>Otvara phpMyAdmin, veb alat za pregled i ure\u0111ivanje tabela i pokretanje SQL upita direktno u pregleda\u010du.<\/td><\/tr>\n<tr><td><strong>Obri\u0161i<\/strong><\/td><td>Trajno bri\u0161e bazu. Pre brisanja obavezno je izvezi.<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<h2>5. Dodela privilegija<\/h2>\n<p>Klikom na <strong>Privilegije<\/strong> otvara se spisak korisnika koji imaju pristup toj bazi. Dugmetom <strong>Dodeli privilegije<\/strong> povezuje\u0161 korisnika sa bazom i bira\u0161 koje operacije sme da izvodi (SELECT, INSERT, UPDATE, DELETE i druge). Za tipi\u010dnu aplikaciju dodeli svom korisniku sve privilegije nad njegovom bazom.<\/p>\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a8775f4e59c2&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a8775f4e59c2\" class=\"wp-block-image size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"822\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-privileges-1024x822.png\" alt=\"Dijalog Privilegije baze u WHSPanelu\" class=\"wp-image-7533\" title=\"\" srcset=\"https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-privileges-1024x822.png 1024w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-privileges-300x241.png 300w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-privileges-768x617.png 768w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-privileges-1536x1233.png 1536w, https:\/\/www.webhostingsrbija.rs\/wp-content\/uploads\/2026\/08\/mysql-privileges-2048x1644.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><figcaption class=\"wp-block-image__caption\">Dodela privilegija: koji korisnik i koje operacije nad bazom.<\/figcaption><\/figure>\n\n\n<h2>6. Korisnici baza<\/h2>\n<p>Korisnici baze su odvojeni nalozi za prijavu koje tvoje aplikacije koriste da se pove\u017eu na MySQL. Oni nisu isto \u0161to i tvoj hosting nalog. Kod svakog korisnika su dugmad:<\/p>\n<ul>\n<li><strong>Lozinka:<\/strong> menja lozinku korisnika (ako procuri ili je treba rotirati).<\/li>\n<li><strong>Obri\u0161i:<\/strong> uklanja korisnika.<\/li>\n<\/ul>\n<p>Preporuka je da napravi\u0161 jednog korisnika po aplikaciji i dodeli\u0161 mu pristup samo bazama koje su mu potrebne.<\/p>\n\n<h2>7. Kako da pove\u017ee\u0161 WordPress ili drugu aplikaciju<\/h2>\n<ul>\n<li><strong>Ime baze:<\/strong> pun naziv sa prefiksom (na primer <code>whsuser_mojasajt<\/code>).<\/li>\n<li><strong>Korisnik baze:<\/strong> korisnik koji si napravio (isto sa prefiksom), kome si dodelio privilegije nad tom bazom.<\/li>\n<li><strong>Lozinka:<\/strong> lozinka tog korisnika.<\/li>\n<li><strong>Host:<\/strong> <code>localhost<\/code> (baza je na istom serveru kao sajt).<\/li>\n<\/ul>\n\n<blockquote><p><strong>Note:<\/strong> uvek koristi pun naziv baze i korisnika sa prefiksom naloga; bez prefiksa povezivanje ne radi. Ne zaboravi da korisniku <strong>dodeli\u0161 privilegije<\/strong> nad bazom, ina\u010de aplikacija ne mo\u017ee da joj pristupi.<\/p><\/blockquote>\n\n<blockquote><p><strong>Bezbednost:<\/strong> napravi zaseban korisnik po aplikaciji sa samo neophodnim privilegijama i redovno pravi izvoz baze kao rezervnu kopiju.<\/p><\/blockquote>","protected":false},"excerpt":{"rendered":"<p>How to create a MySQL database, user and assign privileges in WHSPanel and connect WordPress or other application to the database.<\/p>","protected":false},"author":1,"featured_media":7311,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[206,203],"tags":[],"class_list":["post-7333","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-baze-podataka","category-whs-panel"],"_links":{"self":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/posts\/7333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/comments?post=7333"}],"version-history":[{"count":1,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/posts\/7333\/revisions"}],"predecessor-version":[{"id":7570,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/posts\/7333\/revisions\/7570"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/media\/7311"}],"wp:attachment":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/media?parent=7333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/categories?post=7333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/tags?post=7333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}