SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) . DB_HOST set

hello everybody welcome to our new video and uh  today we're gonna fix one of the most popular   errors in mysql i'm using mysql and php and i'm  using localhost which is using also uh to create   my database i used phpmyadmin and guys we want to  see wanna fix this error with the error code 10 4   5. so it says 10.5 access denied for user root iit  row iit at localhost using password yes okay then   it gives you a way the page is and uh where the  pages is here this is the index page it's in the m   folder under html under www under var that's  why i'd say in uh guys without wasting any time   this is something simple to fix and if you're  using windows uh you're gonna wait until we   leave those command whatever line we're gonna  do so step by step if you're using linux what   you're gonna do you're gonna start your services  first if they are not started gonna be service but ubuntu sometimes you don't need to do this   all what i do but um you can linux you need  to do this service uh start service apache it's gonna be pa phd no it's gonna be che to start then  press enter then you go to service   apache no we're gonna say mysql my  we also have to start mysql sql start zoop once those two services have started what  you're gonna do next you wanna check you you   know sometimes errors they are not major issues  the major issue is what we don't uh read word by   what what the error say here if you can say here  it's gonna say access denied for user row iit you   can see that there is a mistake in this typing it  should be root i don't know if you're using root   as your user may be using some another username  but if you're using root and uh you'll find this   error first check if the user is fine so now if  we're there so we're gonna do go to our i'm gonna   call go follow step by step because this is in  this folder so i'm gonna go to that folder so um i'm gonna do that when i go to that folder which  is gonna be va whereby to access valve we go here   we go to computer then we scroll down give up then  we scroll down look for ww then we look for html   then we look for m in the m folder there is a  a page called index that page we open it here   once we open it here you can simply see that  each and everything is right and uh i wanna show   you something interesting amazing uh if i take  out this code this code only helps you to show   you errors if i take it out i say edit anyway  anyway yes if i take this code out and i save   it doesn't mean i'm fixing the error the error  is not fixed but the error won't appear anymore   you see we don't have errors anymore  but the code won't work anyway so   why do we need this code the reason why we need  this code is this code allows php to show us the   errors we have in our code once you take out that  code you're gonna say blank thing but you don't   see maybe you wanted to call out display some  information from the database or you want to   import or what capture some information put  it in the database you'll never be able to   do that because the code is not working but you  can't see no errors the reason why you notice   don't see any error is that because the errors  they are switched off so you can go to your php in   then you do that but if you don't want to  do that then you can find a simple way to   tap these three lines then it's gonna they're  gonna give you access to that so that you can   show this code so once we save again we're  going to be able to see the errors here   let me go here i can see we have our error the  1049 so once we have the error i've seen i think   you can notice that all this entire line sim  is fine let's first fix this what they say is a bad typing so we take out those two then we go  to the second step which is gonna help us to   save after saving we're gonna see what's gonna  tell us when we save we really get our results   well so that worked so well guys please don't  forget to subscribe and see you in the next video

Channel: Bassonia Tv

Views: 11,843

Keywords: mysql, SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) . DB_HOST set, sqlstate hy000 error 1045 access denied for user, SQLSTATE[HY000] [1045] Access denied, SQLSTATE[HY000] [1045] Access denied for user, mysql error SQLSTATE[HY000] [1045] Access denied, SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES), [PDOException] SQLSTATE[HY000] [1045] Access denied for user

Id: UdT9SdIJUUI

Length: 5min 44sec (344 seconds)

Published: Sat Apr 02 2022