[solved] Access Denied for User 'root'@'localhost' (using password : NO) in xampp phpmyadmin

hello guys in this video we are going to solve error access denied for rout at Local Host using password no now let's solve this error as we can see our Port is 3307 so we have to make some changes in our configuration files but firstly let's shut down our Apache and MySQL server by clicking on the stop button now let's open config files by clicking on the config button of Apache server so we are opening php.ini first now in this file scroll down to the bottom okay so now we are at the bottom of this file so now I am going to tell you where you you have to make the required changes here we are seeing that our MySQL default uncore Port is set as 3306 so now change it and set it to 3307 okay now save the [Music] file now we can close the php.ini file now again click on the config button of Apache server and open config in.php file okay now in this file we have to make a minor change now just copy this line of code and paste it below the host address now rename the host of the line we pasted to port and let's give it the port of 3307 7 okay now save the [Music] file now we can close the config.inc file okay we have made the changes that were required now we are back at our zamp control panel again so now let's start the Apache and MySQL servers okay our servers are up and running now let's refresh the PHP midman homepage and here we go voila we have solved our error thanks again for watching I hope to see you soon in another troubleshooting video bye

Channel: TY Edu-Knowledge

Views: 2,986

Keywords: mysql, phpmyadmin, xampp, windows, xampp error, localhost, using password: no, access denied for user, root@localhost, php error access denied, mysql workbench

Id: YkLfRVGRLjE

Length: 2min 53sec (173 seconds)

Published: Thu Jan 25 2024