{"id":1236,"date":"2024-04-16T16:39:28","date_gmt":"2024-04-16T13:39:28","guid":{"rendered":"https:\/\/www.fibacloud.com\/community\/tutorials\/?p=1236"},"modified":"2024-04-16T17:33:37","modified_gmt":"2024-04-16T14:33:37","slug":"ubuntu-ustunde-mysql-kurulumu-ve-yonetimi","status":"publish","type":"post","link":"https:\/\/www.fibacloud.com\/community\/tutorials\/ubuntu-ustunde-mysql-kurulumu-ve-yonetimi\/","title":{"rendered":"Ubuntu \u00dcst\u00fcnde MySQL Kurulumu ve Y\u00f6netimi"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1236\" class=\"elementor elementor-1236\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cd97a28 e-flex e-con-boxed e-con e-parent\" data-id=\"cd97a28\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-24833c5 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"24833c5\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;marker_view&quot;:&quot;numbers&quot;,&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor-pro - v3.20.0 - 26-03-2024 *\/\n.elementor-widget-table-of-contents .elementor-toc__header-title{color:var(--header-color)}.elementor-widget-table-of-contents.elementor-toc--collapsed .elementor-toc__toggle-button--collapse,.elementor-widget-table-of-contents:not(.elementor-toc--collapsed) .elementor-toc__toggle-button--expand{display:none}.elementor-widget-table-of-contents .elementor-widget-container{min-height:var(--box-min-height);border:var(--box-border-width,1px) solid var(--box-border-color,#9da5ae);border-radius:var(--box-border-radius,3px);background-color:var(--box-background-color);transition:min-height .4s;overflow:hidden}.elementor-toc__header{display:flex;align-items:center;justify-content:space-between;padding:var(--box-padding,20px);background-color:var(--header-background-color);border-bottom:var(--separator-width,1px) solid var(--box-border-color,#9da5ae)}.elementor-toc__header-title{font-size:18px;margin:0;color:var(--header-color);flex-grow:1}.elementor-toc__toggle-button{cursor:pointer;display:inline-flex}.elementor-toc__toggle-button i{color:var(--toggle-button-color)}.elementor-toc__toggle-button svg{height:1em;width:1em;fill:var(--toggle-button-color)}.elementor-toc__spinner-container{text-align:center}.elementor-toc__spinner{font-size:2em}.elementor-toc__spinner.e-font-icon-svg{height:1em;width:1em}.elementor-toc__body{padding:var(--box-padding,20px);max-height:var(--toc-body-max-height);overflow-y:auto}.elementor-toc__body::-webkit-scrollbar{width:7px}.elementor-toc__body::-webkit-scrollbar-thumb{background-color:#babfc5;border-radius:10px}.elementor-toc__list-wrapper{list-style:none;padding:0}.elementor-toc__list-item{margin-bottom:.5em}.elementor-toc__list-item.elementor-item-active{font-weight:700}.elementor-toc__list-item .elementor-toc__list-wrapper{margin-top:.5em;margin-left:var(--nested-list-indent,1em)}.elementor-toc__list-item-text{transition-duration:var(--item-text-transition-duration)}.elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}.elementor-toc__list-item-text-wrapper{display:flex;align-items:center}.elementor-toc__list-item-text-wrapper:before,.elementor-toc__list-item-text-wrapper i{margin-right:8px;color:var(--marker-color)}.elementor-toc__list-item-text-wrapper svg{margin-right:8px;fill:var(--marker-color);height:var(--marker-size,.5em);width:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper i{font-size:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper:before{font-size:var(--marker-size,1em)}.elementor-toc--content-ellipsis .elementor-toc__list-item-text{white-space:nowrap;overflow:hidden;text-overflow:ellipsis}.elementor-toc__list-items--collapsible>.elementor-toc__list-wrapper>.elementor-toc__list-item>.elementor-toc__list-wrapper{display:none}.elementor-toc__heading-anchor{position:absolute}.elementor-toc__body .elementor-toc__list-item-text{color:var(--item-text-color);-webkit-text-decoration:var(--item-text-decoration);text-decoration:var(--item-text-decoration);transition-duration:var(--item-text-transition-duration)}.elementor-toc__body .elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__body .elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}ol.elementor-toc__list-wrapper{counter-reset:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item{counter-increment:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item-text-wrapper:before{content:counters(item,\".\") \". \"}<\/style>\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\t\u0130\u00e7indekiler\t\t\t<\/h4>\n\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__24833c5\" aria-expanded=\"true\" aria-label=\"Open table of contents\"><svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-chevron-down\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M207.029 381.476L12.686 187.132c-9.373-9.373-9.373-24.569 0-33.941l22.667-22.667c9.357-9.357 24.522-9.375 33.901-.04L224 284.505l154.745-154.021c9.379-9.335 24.544-9.317 33.901.04l22.667 22.667c9.373 9.373 9.373 24.569 0 33.941L240.971 381.476c-9.373 9.372-24.569 9.372-33.942 0z\"><\/path><\/svg><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__24833c5\" aria-expanded=\"true\" aria-label=\"Close table of contents\"><svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-chevron-up\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M240.971 130.524l194.343 194.343c9.373 9.373 9.373 24.569 0 33.941l-22.667 22.667c-9.357 9.357-24.522 9.375-33.901.04L224 227.495 69.255 381.516c-9.379 9.335-24.544 9.317-33.901-.04l-22.667-22.667c-9.373-9.373-9.373-24.569 0-33.941L207.03 130.525c9.372-9.373 24.568-9.373 33.941-.001z\"><\/path><\/svg><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div id=\"elementor-toc__24833c5\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<svg class=\"elementor-toc__spinner eicon-animation-spin e-font-icon-svg e-eicon-loading\" aria-hidden=\"true\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M500 975V858C696 858 858 696 858 500S696 142 500 142 142 304 142 500H25C25 237 238 25 500 25S975 237 975 500 763 975 500 975Z\"><\/path><\/svg>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-24ac7d2 elementor-widget elementor-widget-heading\" data-id=\"24ac7d2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 08-05-2024 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">MySQL Kurulumu<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1e26773 elementor-widget elementor-widget-text-editor\" data-id=\"1e26773\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 08-05-2024 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Ubuntu i\u015fletim sistemi, \u00f6zellikle sunucu ortamlar\u0131nda en \u00e7ok tercih edilen Linux da\u011f\u0131t\u0131mlar\u0131ndan biridir. G\u00fc\u00e7l\u00fc ve esnek yap\u0131s\u0131 sayesinde, bir\u00e7ok veritaban\u0131 y\u00f6netim sistemiyle uyumlu \u00e7al\u0131\u015fabilir.<\/p><p>Bu rehberde, Ubuntu \u00fczerinde MySQL veritaban\u0131 sunucusunun nas\u0131l kurulaca\u011f\u0131 ve y\u00f6netilece\u011fi hakk\u0131nda ad\u0131m ad\u0131m bilgiler sunaca\u011f\u0131z. \u0130ster yeni ba\u015flayan bir kullan\u0131c\u0131 olun ister tecr\u00fcbeli bir sistem y\u00f6neticisi, bu yaz\u0131 dizimizdeki a\u00e7\u0131klamalarla MySQL kurulumu ve y\u00f6netimi konusunda kendinizi daha donan\u0131ml\u0131 hissedeceksiniz.<\/p><p><strong>MySQL<\/strong>\u00a0kurulumu i\u00e7in ilk ad\u0131m, terminali a\u00e7mak ve a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131rmakt\u0131r:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2172d13 elementor-widget elementor-widget-code-highlight\" data-id=\"2172d13\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>sudo apt update -y<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f74ee94 elementor-widget elementor-widget-text-editor\" data-id=\"f74ee94\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Bu komut, paket listelerini g\u00fcncelleyecek ve sisteminizi en son s\u00fcr\u00fcmler i\u00e7in haz\u0131rlayacakt\u0131r. Ard\u0131ndan, MySQL paketlerini kurmak i\u00e7in:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4d1497a elementor-widget elementor-widget-code-highlight\" data-id=\"4d1497a\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>sudo apt install mysql-server -y<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4ee94bf elementor-widget elementor-widget-text-editor\" data-id=\"4ee94bf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>komutunu kullanabilirsiniz. Kurulum s\u0131ras\u0131nda, root kullan\u0131c\u0131s\u0131 i\u00e7in bir \u015fifre belirlemeniz istenebilir. G\u00fcvenli bir \u015fifre se\u00e7ti\u011finizden emin olun.<\/p><p>Kurulum tamamland\u0131\u011f\u0131nda, MySQL servisinin aktif olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b1e5a89 elementor-widget elementor-widget-code-highlight\" data-id=\"b1e5a89\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>sudo systemctl status mysql.service<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3524fc1 elementor-widget elementor-widget-text-editor\" data-id=\"3524fc1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>komutunu kullanabilirsiniz. E\u011fer servis aktif de\u011filse, ba\u015flatmak i\u00e7in:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-03bf62c elementor-widget elementor-widget-code-highlight\" data-id=\"03bf62c\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>sudo systemctl start mysql.service<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c5fb505 elementor-widget elementor-widget-text-editor\" data-id=\"c5fb505\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>komutunu \u00e7al\u0131\u015ft\u0131r\u0131n.<\/p><p>MySQL sunucusunu kurduktan sonra, g\u00fcvenlik ve kullan\u0131m kolayl\u0131\u011f\u0131 i\u00e7in baz\u0131 yap\u0131land\u0131rma ayarlar\u0131n\u0131 yapman\u0131z \u00f6nerilir. Bu ayarlar\u0131 yapmak i\u00e7in terminalde \u015fu komutu \u00e7al\u0131\u015ft\u0131rabilirsiniz:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c137dbb elementor-widget elementor-widget-code-highlight\" data-id=\"c137dbb\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>sudo mysql_secure_installation<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f870e65 elementor-widget elementor-widget-text-editor\" data-id=\"f870e65\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Bu betik, root \u015fifresini g\u00fc\u00e7lendirmeniz, anonim kullan\u0131c\u0131lar\u0131 kald\u0131rman\u0131z, uzaktan root kullan\u0131c\u0131 giri\u015fini devre d\u0131\u015f\u0131 b\u0131rakman\u0131z ve test veritaban\u0131n\u0131 silmeniz gibi bir dizi g\u00fcvenlik \u00f6nlemi sunar. Her ad\u0131mda size y\u00f6nlendirmeler yap\u0131lacak ve tercihlerinize g\u00f6re ayarlamalar\u0131 yapabileceksiniz.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cc1295d elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"cc1295d\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 08-05-2024 *\/\n.elementor-widget-divider{--divider-border-style:none;--divider-border-width:1px;--divider-color:#0c0d0e;--divider-icon-size:20px;--divider-element-spacing:10px;--divider-pattern-height:24px;--divider-pattern-size:20px;--divider-pattern-url:none;--divider-pattern-repeat:repeat-x}.elementor-widget-divider .elementor-divider{display:flex}.elementor-widget-divider .elementor-divider__text{font-size:15px;line-height:1;max-width:95%}.elementor-widget-divider .elementor-divider__element{margin:0 var(--divider-element-spacing);flex-shrink:0}.elementor-widget-divider .elementor-icon{font-size:var(--divider-icon-size)}.elementor-widget-divider .elementor-divider-separator{display:flex;margin:0;direction:ltr}.elementor-widget-divider--view-line_icon .elementor-divider-separator,.elementor-widget-divider--view-line_text .elementor-divider-separator{align-items:center}.elementor-widget-divider--view-line_icon .elementor-divider-separator:after,.elementor-widget-divider--view-line_icon .elementor-divider-separator:before,.elementor-widget-divider--view-line_text .elementor-divider-separator:after,.elementor-widget-divider--view-line_text .elementor-divider-separator:before{display:block;content:\"\";border-block-end:0;flex-grow:1;border-block-start:var(--divider-border-width) var(--divider-border-style) var(--divider-color)}.elementor-widget-divider--element-align-left .elementor-divider .elementor-divider-separator>.elementor-divider__svg:first-of-type{flex-grow:0;flex-shrink:100}.elementor-widget-divider--element-align-left .elementor-divider-separator:before{content:none}.elementor-widget-divider--element-align-left .elementor-divider__element{margin-left:0}.elementor-widget-divider--element-align-right .elementor-divider .elementor-divider-separator>.elementor-divider__svg:last-of-type{flex-grow:0;flex-shrink:100}.elementor-widget-divider--element-align-right .elementor-divider-separator:after{content:none}.elementor-widget-divider--element-align-right .elementor-divider__element{margin-right:0}.elementor-widget-divider--element-align-start .elementor-divider .elementor-divider-separator>.elementor-divider__svg:first-of-type{flex-grow:0;flex-shrink:100}.elementor-widget-divider--element-align-start .elementor-divider-separator:before{content:none}.elementor-widget-divider--element-align-start .elementor-divider__element{margin-inline-start:0}.elementor-widget-divider--element-align-end .elementor-divider .elementor-divider-separator>.elementor-divider__svg:last-of-type{flex-grow:0;flex-shrink:100}.elementor-widget-divider--element-align-end .elementor-divider-separator:after{content:none}.elementor-widget-divider--element-align-end .elementor-divider__element{margin-inline-end:0}.elementor-widget-divider:not(.elementor-widget-divider--view-line_text):not(.elementor-widget-divider--view-line_icon) .elementor-divider-separator{border-block-start:var(--divider-border-width) var(--divider-border-style) var(--divider-color)}.elementor-widget-divider--separator-type-pattern{--divider-border-style:none}.elementor-widget-divider--separator-type-pattern.elementor-widget-divider--view-line .elementor-divider-separator,.elementor-widget-divider--separator-type-pattern:not(.elementor-widget-divider--view-line) .elementor-divider-separator:after,.elementor-widget-divider--separator-type-pattern:not(.elementor-widget-divider--view-line) .elementor-divider-separator:before,.elementor-widget-divider--separator-type-pattern:not([class*=elementor-widget-divider--view]) .elementor-divider-separator{width:100%;min-height:var(--divider-pattern-height);-webkit-mask-size:var(--divider-pattern-size) 100%;mask-size:var(--divider-pattern-size) 100%;-webkit-mask-repeat:var(--divider-pattern-repeat);mask-repeat:var(--divider-pattern-repeat);background-color:var(--divider-color);-webkit-mask-image:var(--divider-pattern-url);mask-image:var(--divider-pattern-url)}.elementor-widget-divider--no-spacing{--divider-pattern-size:auto}.elementor-widget-divider--bg-round{--divider-pattern-repeat:round}.rtl .elementor-widget-divider .elementor-divider__text{direction:rtl}.e-con-inner>.elementor-widget-divider,.e-con>.elementor-widget-divider{width:var(--container-widget-width,100%);--flex-grow:var(--container-widget-flex-grow)}<\/style>\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b467725 elementor-widget elementor-widget-heading\" data-id=\"b467725\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">MySQL Kullan\u0131c\u0131 ve Veritaban\u0131 Olu\u015fturma<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b2d3756 elementor-widget elementor-widget-text-editor\" data-id=\"b2d3756\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>MySQL&#8217;de yeni bir kullan\u0131c\u0131 ile veritaban\u0131 olu\u015fturmak ve bu kullan\u0131c\u0131ya izinler atamak i\u00e7in MySQL komut sat\u0131r\u0131n\u0131 kullanabilirsiniz. \u00d6ncelikle, MySQL&#8217;e giri\u015f yap\u0131n:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4772d08 elementor-widget elementor-widget-code-highlight\" data-id=\"4772d08\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>sudo mysql -u root -p<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eae3624 elementor-widget elementor-widget-text-editor\" data-id=\"eae3624\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Ard\u0131ndan yeni bir kullan\u0131c\u0131 olu\u015fturmak i\u00e7in:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b9a9d41 elementor-widget elementor-widget-code-highlight\" data-id=\"b9a9d41\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>CREATE USER 'kullanici_adi'@'localhost' IDENTIFIED BY 'guclu_sifre';<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-30cf0e3 elementor-widget elementor-widget-text-editor\" data-id=\"30cf0e3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>komutunu kullan\u0131n. Burada &#8216;<strong>kullanici_adi<\/strong>&#8216; ve &#8216;<strong>guclu_sifre<\/strong>&#8216; k\u0131s\u0131mlar\u0131n\u0131 kendi belirledi\u011finiz kullan\u0131c\u0131 ad\u0131 ve \u015fifre ile de\u011fi\u015ftirin.\u00a0<\/p><p>Yeni bir veritaban\u0131 olu\u015fturmak i\u00e7in:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d89ee66 elementor-widget elementor-widget-code-highlight\" data-id=\"d89ee66\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>CREATE DATABASE veritabani_adi;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c6b0db2 elementor-widget elementor-widget-text-editor\" data-id=\"c6b0db2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Kullan\u0131c\u0131ya veritaban\u0131 izni atamak i\u00e7in:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2f74043 elementor-widget elementor-widget-code-highlight\" data-id=\"2f74043\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>GRANT ALL PRIVILEGES ON veritabani_adi.* TO 'kullanici_adi'@'localhost';<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-99f38fe elementor-widget elementor-widget-text-editor\" data-id=\"99f38fe\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>MySQL g\u00fcvenli\u011fini sa\u011flamak i\u00e7in alman\u0131z gereken \u00f6nlemler aras\u0131nda \u015fifre politikalar\u0131, a\u011f g\u00fcvenli\u011fi ve d\u00fczenli yedeklemeler bulunmaktad\u0131r. \u00d6rne\u011fin, g\u00fc\u00e7l\u00fc \u015fifreler kullanmak ve d\u00fczenli olarak \u015fifreleri de\u011fi\u015ftirmek, g\u00fcvenlik i\u00e7in \u00f6nemli ad\u0131mlard\u0131r. Ayr\u0131ca, veritaban\u0131n\u0131za sadece g\u00fcvenilir a\u011flardan eri\u015fime izin vermek ve gereksiz MySQL kullan\u0131c\u0131lar\u0131n\u0131 silmek de g\u00fcvenli\u011fi art\u0131rman\u0131n yollar\u0131ndand\u0131r.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-24853f1 e-flex e-con-boxed e-con e-parent\" data-id=\"24853f1\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-841b662 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"841b662\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6022206 elementor-widget elementor-widget-heading\" data-id=\"6022206\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">MySQL Yap\u0131land\u0131rma Ayarlar\u0131<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-50d26cc elementor-widget elementor-widget-text-editor\" data-id=\"50d26cc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><b>MySQL<\/b>\u00a0sunucusunu ba\u015far\u0131yla kurduktan sonra, performans ve g\u00fcvenlik i\u00e7in baz\u0131 temel yap\u0131land\u0131rma ayarlar\u0131n\u0131 yapman\u0131z gerekecektir. Bu ayarlar, MySQL&#8217;in verimli bir \u015fekilde \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flaman\u0131n yan\u0131 s\u0131ra, veritaban\u0131n\u0131z\u0131n g\u00fcvenli\u011fini de art\u0131racakt\u0131r. \u015eimdi, MySQL yap\u0131land\u0131rma ayarlar\u0131n\u0131 nas\u0131l yapaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m inceleyelim.<\/p><p>\u0130lk olarak, MySQL yap\u0131land\u0131rma dosyas\u0131n\u0131 d\u00fczenleyece\u011fiz. Bu dosya genellikle\u00a0<b>\/etc\/mysql\/my.cnf<\/b>\u00a0veya\u00a0<b>\/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/b>\u00a0konumunda bulunur. Terminal \u00fczerinden a\u015fa\u011f\u0131daki komut ile yap\u0131land\u0131rma dosyas\u0131n\u0131 a\u00e7abilirsiniz:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-776e29f elementor-widget elementor-widget-code-highlight\" data-id=\"776e29f\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>sudo apt-get install -y nano\nsudo nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-55386d2 elementor-widget elementor-widget-text-editor\" data-id=\"55386d2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Yap\u0131land\u0131rma dosyas\u0131nda yapman\u0131z gereken \u00f6nemli ayarlar \u015funlard\u0131r:<\/p><ul><li><b>bind-address<\/b>: MySQL sunucusunun hangi IP adresinden eri\u015filebilece\u011fini belirler. Genellikle g\u00fcvenlik nedeniyle yaln\u0131zca yerel makineden eri\u015fime izin vermek i\u00e7in\u00a0<b>127.0.0.1<\/b>\u00a0olarak ayarlan\u0131r.<\/li><li><b>max_connections<\/b>: Ayn\u0131 anda sunucuya ba\u011flanabilecek maksimum istemci say\u0131s\u0131n\u0131 belirler. \u0130htiyac\u0131n\u0131za g\u00f6re bu de\u011feri art\u0131rabilir veya azaltabilirsiniz.<\/li><li><b>character-set-server<\/b>\u00a0ve\u00a0<b>collation-server<\/b>: Veritaban\u0131n\u0131n karakter seti ve kar\u015f\u0131la\u015ft\u0131rma d\u00fczenini belirler. Genellikle\u00a0<b>utf8<\/b>\u00a0ve\u00a0<b>utf8_general_ci<\/b>\u00a0olarak ayarlan\u0131r.<\/li><\/ul><p>A\u015fa\u011f\u0131da, yap\u0131land\u0131rma dosyas\u0131nda yapman\u0131z gereken baz\u0131 temel ayarlar\u0131n \u00f6rnek bir tablosunu bulabilirsiniz:<\/p><table border=\"\"><tbody><tr><th>Ayar<\/th><th>A\u00e7\u0131klama<\/th><th>\u00d6rnek De\u011fer<\/th><\/tr><tr><td>bind-address<\/td><td>MySQL sunucusunun hangi IP adresinden eri\u015filebilece\u011fini belirtir.<\/td><td>127.0.0.1<\/td><\/tr><tr><td>max_connections<\/td><td>Ayn\u0131 anda sunucuya ba\u011flanabilecek maksimum istemci say\u0131s\u0131n\u0131 belirtir.<\/td><td>151<\/td><\/tr><tr><td>character-set-server<\/td><td>Veritaban\u0131n\u0131n karakter setini belirtir.<\/td><td>utf8<\/td><\/tr><tr><td>collation-server<\/td><td>Veritaban\u0131n\u0131n kar\u015f\u0131la\u015ft\u0131rma d\u00fczenini belirtir.<\/td><td>utf8_general_ci<\/td><\/tr><\/tbody><\/table><p>Ayarlar\u0131 yapt\u0131ktan sonra, yap\u0131land\u0131rma dosyas\u0131n\u0131 kaydedip kapatt\u0131\u011f\u0131n\u0131zdan emin olun. De\u011fi\u015fikliklerin etkili olabilmesi i\u00e7in MySQL sunucusunu yeniden ba\u015flatman\u0131z gerekecek. A\u015fa\u011f\u0131daki komutu kullanarak sunucuyu yeniden ba\u015flatabilirsiniz:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9e0b153 elementor-widget elementor-widget-code-highlight\" data-id=\"9e0b153\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>sudo systemctl restart mysql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a42f949 elementor-widget elementor-widget-text-editor\" data-id=\"a42f949\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Yap\u0131land\u0131rma ayarlar\u0131n\u0131z\u0131 do\u011fru bir \u015fekilde yapmak, MySQL sunucunuzun sa\u011fl\u0131kl\u0131 ve g\u00fcvenli bir \u015fekilde \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flayacakt\u0131r. Unutmay\u0131n, bu ayarlar sadece ba\u015flang\u0131\u00e7 i\u00e7in \u00f6nerilenlerdir. Sisteminizin ihtiya\u00e7lar\u0131na g\u00f6re daha ileri d\u00fczey yap\u0131land\u0131rmalar yapman\u0131z gerekebilir.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fc33524 e-flex e-con-boxed e-con e-parent\" data-id=\"fc33524\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b50b765 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"b50b765\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d18b0d3 elementor-widget elementor-widget-heading\" data-id=\"d18b0d3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">MySQL G\u00fcvenlik \u00d6nlemleri<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f6eb9b2 elementor-widget elementor-widget-text-editor\" data-id=\"f6eb9b2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><b>MySQL<\/b>\u00a0veritaban\u0131 sunucunuzun g\u00fcvenli\u011fini sa\u011flamak, siber sald\u0131r\u0131lara kar\u015f\u0131 korunman\u0131n ilk ad\u0131m\u0131d\u0131r. Bu b\u00f6l\u00fcmde, MySQL sunucunuz i\u00e7in uygulayabilece\u011finiz g\u00fcvenlik \u00f6nlemlerine de\u011finece\u011fiz.<\/p><p>\u0130lk olarak,\u00a0<b>root kullan\u0131c\u0131s\u0131 i\u00e7in \u015fifre belirlemeniz<\/b>\u00a0gerekmektedir. Kurulum s\u0131ras\u0131nda atanm\u0131\u015f olan varsay\u0131lan \u015fifreyi de\u011fi\u015ftirmek, olas\u0131 izinsiz eri\u015fimleri engeller. Bunun i\u00e7in a\u015fa\u011f\u0131daki komutu kullanabilirsiniz:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9e12c06 elementor-widget elementor-widget-code-highlight\" data-id=\"9e12c06\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>sudo mysql_secure_installation\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d584cc7 elementor-widget elementor-widget-text-editor\" data-id=\"d584cc7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0130kinci olarak,\u00a0<b>anonim kullan\u0131c\u0131lar\u0131 kald\u0131r\u0131n<\/b>. Anonim kullan\u0131c\u0131lar, kimlik do\u011frulamas\u0131 olmadan veritaban\u0131n\u0131za eri\u015febilir. Bu kullan\u0131c\u0131lar\u0131 kald\u0131rmak i\u00e7in MySQL komut sat\u0131r\u0131na a\u015fa\u011f\u0131daki komutlar\u0131 girin:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-368052f elementor-widget elementor-widget-code-highlight\" data-id=\"368052f\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>DELETE FROM mysql.user WHERE User'';\r\nFLUSH PRIVILEGES;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0d970bd elementor-widget elementor-widget-text-editor\" data-id=\"0d970bd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u00dc\u00e7\u00fcnc\u00fc ad\u0131m olarak,\u00a0<b>uzaktan root eri\u015fimini devre d\u0131\u015f\u0131 b\u0131rak\u0131n<\/b>. Root kullan\u0131c\u0131s\u0131n\u0131n uzaktan eri\u015fimini k\u0131s\u0131tlamak, g\u00fcvenli\u011fi art\u0131r\u0131r. Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki SQL komutunu kullan\u0131n:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7758c06 elementor-widget elementor-widget-code-highlight\" data-id=\"7758c06\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>UPDATE mysql.user SET Host'localhost' WHERE User'root';\r\nFLUSH PRIVILEGES;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d00fc0c elementor-widget elementor-widget-text-editor\" data-id=\"d00fc0c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>D\u00f6rd\u00fcnc\u00fc olarak,\u00a0<b>gerekli olmayan varsay\u0131lan veritabanlar\u0131n\u0131 kald\u0131r\u0131n<\/b>. Test veritaban\u0131 gibi varsay\u0131lan veritabanlar\u0131 g\u00fcvenlik a\u00e7\u0131klar\u0131 olu\u015fturabilir. Bu veritabanlar\u0131n\u0131 silmek i\u00e7in \u015fu komutlar\u0131 kullan\u0131n:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c72a23 elementor-widget elementor-widget-code-highlight\" data-id=\"0c72a23\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>DROP DATABASE test;\r\nFLUSH PRIVILEGES;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fde9445 elementor-widget elementor-widget-text-editor\" data-id=\"fde9445\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Be\u015finci ad\u0131m,\u00a0<b>veritaban\u0131 izinlerini s\u0131k\u0131la\u015ft\u0131r\u0131n<\/b>. Kullan\u0131c\u0131lar\u0131n yaln\u0131zca gerekli izinlere sahip olmas\u0131n\u0131 sa\u011flay\u0131n. \u00d6rne\u011fin, bir kullan\u0131c\u0131ya veritaban\u0131 olu\u015fturma izni vermek i\u00e7in \u015fu komutu kullanabilirsiniz:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f9a7d6 elementor-widget elementor-widget-code-highlight\" data-id=\"9f9a7d6\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-twilight copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>GRANT CREATE ON *.* TO 'kullanici_adi'@'localhost';\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f1d745 elementor-widget elementor-widget-text-editor\" data-id=\"3f1d745\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Alt\u0131nc\u0131 olarak,\u00a0<b>veritaban\u0131n\u0131z\u0131 d\u00fczenli olarak yedekleyin<\/b>. Olas\u0131 bir veri kayb\u0131 durumunda, verilerinizi h\u0131zl\u0131ca geri y\u00fckleyebilirsiniz. Yedekleme i\u00e7in \u00e7e\u015fitli ara\u00e7lar ve komutlar kullan\u0131labilir.<\/p><p>Yedinci ad\u0131m,\u00a0<b>veritaban\u0131 sunucunuzu g\u00fcncel tutun<\/b>. G\u00fcvenlik yamalar\u0131n\u0131 ve g\u00fcncellemeleri d\u00fczenli olarak uygulayarak, bilinen g\u00fcvenlik a\u00e7\u0131klar\u0131n\u0131 kapat\u0131n.<\/p><p>Son olarak,\u00a0<b>g\u00fc\u00e7l\u00fc \u015fifre politikalar\u0131<\/b>\u00a0uygulay\u0131n ve kullan\u0131c\u0131 \u015fifrelerinin d\u00fczenli olarak de\u011fi\u015ftirilmesini sa\u011flay\u0131n. \u015eifrelerin karma\u015f\u0131k ve tahmin edilmesi zor olmas\u0131na \u00f6zen g\u00f6sterin.<\/p><p>Yukar\u0131da belirtilen ad\u0131mlar\u0131n yan\u0131 s\u0131ra, g\u00fcvenlik duvar\u0131 kurallar\u0131, \u015fifrelenmi\u015f ba\u011flant\u0131lar gibi ek g\u00fcvenlik \u00f6nlemlerini de g\u00f6z \u00f6n\u00fcnde bulundurman\u0131z \u00f6nemlidir.\u00a0<b>MySQL<\/b>\u00a0g\u00fcvenli\u011fi, s\u00fcrekli bir s\u00fcre\u00e7tir ve d\u00fczenli olarak g\u00f6zden ge\u00e7irilmelidir.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u0130\u00e7indekiler &nbsp; MySQL Kurulumu Ubuntu i\u015fletim sistemi, \u00f6zellikle sunucu ortamlar\u0131nda en \u00e7ok tercih edilen Linux da\u011f\u0131t\u0131mlar\u0131ndan biridir. G\u00fc\u00e7l\u00fc ve esnek yap\u0131s\u0131 sayesinde, bir\u00e7ok veritaban\u0131 y\u00f6netim sistemiyle uyumlu \u00e7al\u0131\u015fabilir. Bu rehberde, Ubuntu \u00fczerinde MySQL veritaban\u0131 sunucusunun nas\u0131l kurulaca\u011f\u0131 ve y\u00f6netilece\u011fi hakk\u0131nda ad\u0131m ad\u0131m bilgiler sunaca\u011f\u0131z. \u0130ster yeni ba\u015flayan bir kullan\u0131c\u0131 olun ister tecr\u00fcbeli bir sistem y\u00f6neticisi, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1344,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[60,64,72,52],"class_list":["post-1236","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-linux","tag-mysql","tag-ubuntu","tag-veritabanlari"],"lang":"tr","translations":{"tr":1236,"en":1341},"pll_sync_post":[],"_links":{"self":[{"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/posts\/1236","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/comments?post=1236"}],"version-history":[{"count":103,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/posts\/1236\/revisions"}],"predecessor-version":[{"id":1343,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/posts\/1236\/revisions\/1343"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/media\/1344"}],"wp:attachment":[{"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/media?parent=1236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/categories?post=1236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/tags?post=1236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}