{"id":228,"date":"2025-02-28T10:36:54","date_gmt":"2025-02-28T08:36:54","guid":{"rendered":"https:\/\/prikaz3.wordpress.com\/?page_id=228"},"modified":"2025-11-13T12:30:22","modified_gmt":"2025-11-13T12:30:22","slug":"kasutajate-loomine-ja-oiguste-maaraminesql","status":"publish","type":"page","link":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/","title":{"rendered":"SQL\/XAMPP Kasutajate loomine ja \u00f5iguste m\u00e4\u00e4ramine"},"content":{"rendered":"\n<ul id=\"yui_3_17_2_1_1740730745635_390\" class=\"wp-block-list\">\n<li>AB nimi  -Kliendihaldus<\/li>\n\n\n\n<li>Millise tabeli on vaja luua? \u00a0-Kliendid<\/li>\n\n\n\n<li>Milliste tabeli v\u00e4ljadega? -KliendiID, Eesnimi, Perekonnanimi<\/li>\n\n\n\n<li>Milline on selle andmebaasi tabeli kasutaja kasutajanimi ja parool?  -&#8216;admin&#8217;; &#8216;123&#8217;<\/li>\n\n\n\n<li>Millised \u00f5igused peaks kasutajal olema loodud tabeli suhtes (maksimaalselt 2 \u00f5igust tabeli tasandil)?\u00a0 \u00a0 -&#8216;SELECT&#8217;; &#8216;INSERT&#8217;<\/li>\n\n\n\n<li>Milliseid tegevusi tuleks kontrollida? \u00a0 \u00a0-&#8220;UPDATE&#8221; v\u00f5i &#8220;DELETE&#8221;<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\"><strong>SQL<\/strong><\/h2>\n\n\n\n<p>Tabeli koostamine ja andmete sisestamine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"605\" height=\"475\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/1-3.png?w=605\" alt=\"\" class=\"wp-image-229 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/1-3.png 605w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/1-3-300x236.png 300w\" data-sizes=\"(max-width: 605px) 100vw, 605px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 605px; --smush-placeholder-aspect-ratio: 605\/475;\" \/><\/figure>\n\n\n\n<p>Uue kasutaja loomine, parooli m\u00e4\u00e4ramine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"509\" height=\"243\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/2-2.png?w=509\" alt=\"\" class=\"wp-image-230 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/2-2.png 509w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/2-2-300x143.png 300w\" data-sizes=\"(max-width: 509px) 100vw, 509px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 509px; --smush-placeholder-aspect-ratio: 509\/243;\" \/><\/figure>\n\n\n\n<p>Andmebaasi valimine, \u00f5iguste seadmine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"499\" height=\"437\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/3-3.png?w=499\" alt=\"\" class=\"wp-image-231 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/3-3.png 499w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/3-3-300x263.png 300w\" data-sizes=\"(max-width: 499px) 100vw, 499px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 499px; --smush-placeholder-aspect-ratio: 499\/437;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"452\" height=\"69\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/grant-1.png?w=452\" alt=\"\" class=\"wp-image-266 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/grant-1.png 452w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/grant-1-300x46.png 300w\" data-sizes=\"(max-width: 452px) 100vw, 452px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 452px; --smush-placeholder-aspect-ratio: 452\/69;\" \/><\/figure>\n\n\n\n<p>L\u00e4bivaatus update<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1331\" height=\"483\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/44.png?w=1024\" alt=\"\" class=\"wp-image-261 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/44.png 1331w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/44-300x109.png 300w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/44-1024x372.png 1024w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/44-768x279.png 768w\" data-sizes=\"(max-width: 1331px) 100vw, 1331px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1331px; --smush-placeholder-aspect-ratio: 1331\/483;\" \/><\/figure>\n\n\n\n<p>L\u00e4bivaatus delete<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1335\" height=\"507\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/55.png?w=1024\" alt=\"\" class=\"wp-image-262 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/55.png 1335w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/55-300x114.png 300w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/55-1024x389.png 1024w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/55-768x292.png 768w\" data-sizes=\"(max-width: 1335px) 100vw, 1335px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1335px; --smush-placeholder-aspect-ratio: 1335\/507;\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\"><strong>XAMPP<\/strong><\/h2>\n\n\n\n<p>Tabeli koostamine ja andmete sisestamine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"904\" height=\"105\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x1-1.png?w=904\" alt=\"\" class=\"wp-image-241 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x1-1.png 904w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x1-1-300x35.png 300w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x1-1-768x89.png 768w\" data-sizes=\"(max-width: 904px) 100vw, 904px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 904px; --smush-placeholder-aspect-ratio: 904\/105;\" \/><\/figure>\n\n\n\n<p>Uue kasutaja loomine, parooli m\u00e4\u00e4ramine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"436\" height=\"394\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x2-1.png?w=436\" alt=\"\" class=\"wp-image-242 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x2-1.png 436w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x2-1-300x271.png 300w\" data-sizes=\"(max-width: 436px) 100vw, 436px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 436px; --smush-placeholder-aspect-ratio: 436\/394;\" \/><\/figure>\n\n\n\n<p>\u00f5iguste seadmine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"855\" height=\"476\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x3-2.png?w=855\" alt=\"\" class=\"wp-image-256 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x3-2.png 855w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x3-2-300x167.png 300w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x3-2-768x428.png 768w\" data-sizes=\"(max-width: 855px) 100vw, 855px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 855px; --smush-placeholder-aspect-ratio: 855\/476;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"434\" height=\"207\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/tabel.png?w=434\" alt=\"\" class=\"wp-image-268 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/tabel.png 434w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/tabel-300x143.png 300w\" data-sizes=\"(max-width: 434px) 100vw, 434px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 434px; --smush-placeholder-aspect-ratio: 434\/207;\" \/><\/figure>\n\n\n\n<p>L\u00e4bivaatus update<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"939\" height=\"622\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x4.png?w=939\" alt=\"\" class=\"wp-image-245 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x4.png 939w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x4-300x199.png 300w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x4-768x509.png 768w\" data-sizes=\"(max-width: 939px) 100vw, 939px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 939px; --smush-placeholder-aspect-ratio: 939\/622;\" \/><\/figure>\n\n\n\n<p>L\u00e4bivaatus delete<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"950\" height=\"596\" data-src=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x5.png?w=950\" alt=\"\" class=\"wp-image-246 lazyload\" data-srcset=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x5.png 950w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x5-300x188.png 300w, https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/x5-768x482.png 768w\" data-sizes=\"(max-width: 950px) 100vw, 950px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 950px; --smush-placeholder-aspect-ratio: 950\/596;\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Tabeli koostamine ja andmete sisestamine Uue kasutaja loomine, parooli m\u00e4\u00e4ramine Andmebaasi valimine, \u00f5iguste seadmine L\u00e4bivaatus update L\u00e4bivaatus delete XAMPP Tabeli koostamine ja andmete sisestamine Uue kasutaja loomine, parooli m\u00e4\u00e4ramine \u00f5iguste seadmine L\u00e4bivaatus update L\u00e4bivaatus delete<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-with-title","meta":{"footnotes":""},"class_list":["post-228","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL\/XAMPP Kasutajate loomine ja \u00f5iguste m\u00e4\u00e4ramine - Roman Prikaztsikov Portfolio<\/title>\n<meta name=\"description\" content=\"\u00d5pi, kuidas XAMPP-is luua SQL kasutajaid ja m\u00e4\u00e4rata neile \u00f5igused kiiresti ja turvaliselt.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL\/XAMPP Kasutajate loomine ja \u00f5iguste m\u00e4\u00e4ramine - Roman Prikaztsikov Portfolio\" \/>\n<meta property=\"og:description\" content=\"\u00d5pi, kuidas XAMPP-is luua SQL kasutajaid ja m\u00e4\u00e4rata neile \u00f5igused kiiresti ja turvaliselt.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/\" \/>\n<meta property=\"og:site_name\" content=\"Roman Prikaztsikov Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T12:30:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/1-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"605\" \/>\n\t<meta property=\"og:image:height\" content=\"475\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/kasutajate-loomine-ja-oiguste-maaraminesql\\\/\",\"url\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/kasutajate-loomine-ja-oiguste-maaraminesql\\\/\",\"name\":\"SQL\\\/XAMPP Kasutajate loomine ja \u00f5iguste m\u00e4\u00e4ramine - Roman Prikaztsikov Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/kasutajate-loomine-ja-oiguste-maaraminesql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/kasutajate-loomine-ja-oiguste-maaraminesql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/1-3.png?w=605\",\"datePublished\":\"2025-02-28T08:36:54+00:00\",\"dateModified\":\"2025-11-13T12:30:22+00:00\",\"description\":\"\u00d5pi, kuidas XAMPP-is luua SQL kasutajaid ja m\u00e4\u00e4rata neile \u00f5igused kiiresti ja turvaliselt.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/kasutajate-loomine-ja-oiguste-maaraminesql\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/kasutajate-loomine-ja-oiguste-maaraminesql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/kasutajate-loomine-ja-oiguste-maaraminesql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/1-3.png\",\"contentUrl\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/1-3.png\",\"width\":605,\"height\":475},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/kasutajate-loomine-ja-oiguste-maaraminesql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\\\/XAMPP Kasutajate loomine ja \u00f5iguste m\u00e4\u00e4ramine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/\",\"name\":\"Roman Prikaztsikov Portfolio\",\"description\":\"J&auml;rgmine WordPress veebileht\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/romanprikaztsikov24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL\/XAMPP Kasutajate loomine ja \u00f5iguste m\u00e4\u00e4ramine - Roman Prikaztsikov Portfolio","description":"\u00d5pi, kuidas XAMPP-is luua SQL kasutajaid ja m\u00e4\u00e4rata neile \u00f5igused kiiresti ja turvaliselt.","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:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/","og_locale":"et_EE","og_type":"article","og_title":"SQL\/XAMPP Kasutajate loomine ja \u00f5iguste m\u00e4\u00e4ramine - Roman Prikaztsikov Portfolio","og_description":"\u00d5pi, kuidas XAMPP-is luua SQL kasutajaid ja m\u00e4\u00e4rata neile \u00f5igused kiiresti ja turvaliselt.","og_url":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/","og_site_name":"Roman Prikaztsikov Portfolio","article_modified_time":"2025-11-13T12:30:22+00:00","og_image":[{"width":605,"height":475,"url":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/1-3.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/","url":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/","name":"SQL\/XAMPP Kasutajate loomine ja \u00f5iguste m\u00e4\u00e4ramine - Roman Prikaztsikov Portfolio","isPartOf":{"@id":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/#primaryimage"},"image":{"@id":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/#primaryimage"},"thumbnailUrl":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/1-3.png?w=605","datePublished":"2025-02-28T08:36:54+00:00","dateModified":"2025-11-13T12:30:22+00:00","description":"\u00d5pi, kuidas XAMPP-is luua SQL kasutajaid ja m\u00e4\u00e4rata neile \u00f5igused kiiresti ja turvaliselt.","breadcrumb":{"@id":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/#primaryimage","url":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/1-3.png","contentUrl":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/1-3.png","width":605,"height":475},{"@type":"BreadcrumbList","@id":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/kasutajate-loomine-ja-oiguste-maaraminesql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"SQL\/XAMPP Kasutajate loomine ja \u00f5iguste m\u00e4\u00e4ramine"}]},{"@type":"WebSite","@id":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/#website","url":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/","name":"Roman Prikaztsikov Portfolio","description":"J&auml;rgmine WordPress veebileht","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=228"}],"version-history":[{"count":1,"href":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/228\/revisions"}],"predecessor-version":[{"id":1029,"href":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/228\/revisions\/1029"}],"wp:attachment":[{"href":"https:\/\/romanprikaztsikov24.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}