{"id":20492,"date":"2021-03-17T06:33:35","date_gmt":"2021-03-17T06:33:35","guid":{"rendered":"http:\/\/www.devopsschool.com\/blog\/?p=20492"},"modified":"2021-03-17T06:33:36","modified_gmt":"2021-03-17T06:33:36","slug":"i-am-facing-a-mysql-error-when-i-want-to-login-into-a-database-in-ubuntu-20-04-2-lts","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/i-am-facing-a-mysql-error-when-i-want-to-login-into-a-database-in-ubuntu-20-04-2-lts\/","title":{"rendered":"I am facing a MySQL error when I want to login into a database in Ubuntu 20.04.2 LTS"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/03\/image.png\" alt=\"\" class=\"wp-image-20493\" width=\"529\" height=\"572\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/03\/image.png 529w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/03\/image-277x300.png 277w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><figcaption><strong>Mysqli login issue<\/strong><\/figcaption><\/figure><\/div>\n\n\n\n<p>I am facing above issue from two days so I searched a lot for this. but every time I failed,  I started checking from another ubuntu machines, I find that, there is a permission issue in my machine so i decide to run some commands which you can  find below:<\/p>\n\n\n\n<p>First of all, you can&#8217;t give<em> chmod 777<\/em> to htdocs folder so you can follow below steps to find the resolution :<\/p>\n\n\n\n<p><strong>Step 1<\/strong> : Give the permission to your var folder location under lampp folder<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>sudo chmod 777 \/opt\/lampp\/var\/<\/code><\/pre>\n\n\n\n<p>Step 2 : Now give access to mysql folder<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">sudo chown -R mysql:mysql \/opt\/lampp\/<span class=\"hljs-keyword\">var<\/span>\/mysql\/<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Step 3 : At last restart Xampp Server<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">lampp\/lampp restart<\/code><\/span><\/pre>\n\n\n<p> Hey geeks above resolution solved my xampp issue and if you are also stuck on these problems following my steps. Please find another solution given under the resources section. and feel free to comment if you have any other resolutions.<\/p>\n\n\n\n<p>Resources :<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" href=\"https:\/\/stackoverflow.com\/questions\/53626037\/i-am-facing-a-mysql-error-when-i-start-my-xampp-in-ubuntu-18-04\" target=\"_blank\">Click Here<\/a><\/li><li><a href=\"https:\/\/www.mytechiest.rocks\/2020\/03\/how-to-fix-optlamppbinmysqlserver-264_22.html\" data-type=\"URL\" data-id=\"https:\/\/www.mytechiest.rocks\/2020\/03\/how-to-fix-optlamppbinmysqlserver-264_22.html\" target=\"_blank\" rel=\"noreferrer noopener\">Click Here<\/a><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>I am facing above issue from two days so I searched a lot for this. but every time I failed, I started checking from another ubuntu machines, I find that, there is a permission issue in my machine so i decide to run some commands which you can find below: First of all, you can&#8217;t&#8230;<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[4957],"tags":[6550,6551,493,6480,702,5356],"class_list":["post-20492","post","type-post","status-publish","format-standard","hentry","category-linux","tag-lampp","tag-login-issue","tag-mysql","tag-permission-denied","tag-ubuntu","tag-xampp"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/20492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=20492"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/20492\/revisions"}],"predecessor-version":[{"id":20494,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/20492\/revisions\/20494"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=20492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=20492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=20492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}