Solve mysql_connect() Access Denied For User 'root'@'localhost' (Using Password Yes)

Hey guys welcome back Bhagyashri here from domainracer.com and in today's video I'm going to show you how to troubleshoot Access denied error while connecting to your MySQL server so let's get started . So here it’s showing you should check the host username and password in your configuration and make sure that they correspond to the xampp control panel popup and in my SQL here in configuration click and open your my.ini so here I am going to paste the command keep-grant-tables=true all the commands used in this video you will get into the description below so you can take it from there. now save the file and close. now restart your MySQL from xampp control panel so here click on stop and again start now refresh your localhost and here its resolve but this is just first step we need to do one more setting. if you have set password for your MySQL and you lost the password then you need to reset or change your MySQL password so let's see how to reset or change your MySQL password even after when we already lost the old password. so open your Windows command promote for that here in xampp control panel click on shell now here you need to enter one command as I already told you all the commands used in this video you will get into the description. so here hit enter button again hit enter button and now it will directly login into your mariadb now again enter one command and here replace this route with watever password you want to set for your MySQL so here I am going to set it as admin 123 make sure you have added Semi column at the end of your command and then hit enter button . so here we have successfully changed password for your my SQL now we need to update this password into configuration.ini.PHP in xampp so open your file from xampp folder and here my SQL here click open your my.ini file and remove the command which we have pasted in

Channel: DomainRacer

Views: 156,580

Keywords: access denied for user 'root'@'localhost', access denied for user, access denied for user 'root'@'localhost' (using password yes), php error access denied, access denied for user 'root'@'localhost'!! [solved], access denied error in phpmyadmin, acess denied error 1045, access denied for user 'root'@'localhost' (using password no), acess denied error mysql, aces denied for user, acess denied error xampp mysql, acess denied phpmyadmin xampp, 2020

Id: kea-2yFFrl0

Length: 3min 35sec (215 seconds)

Published: Mon Dec 31 2018