Access Denied root@localhost - Solved - MySQL Server - Windows - Reset Root Password

welcome to another video if you haven't not yet done so hit the subscribe button so you never miss another tutorial today you're gonna solve this access denied problem when you're trying to log into MySQL so you might try to log into your MySQL server by in MySQL - you - even though you enter your correct password you say that access denied for your user root at localhost using a spurt yes so how do you solve it so they are reserves specific way of solving these in Microsoft Windows so how do you solve it first you need to stop MySQL server from the services to do that right click on your task and go to task manager go to services and search for my SQL it so I have already installed MySQL workbench and MySQL server 8 but still I cannot get into the server so I'm gonna stop it ok then I'm going to create a simple text file so I'm gonna create a new file on the desktop new text file and I'm going to name it as MySQL int so the name can be anything so I'm gonna name it as masculine I'm gonna open it so I have the MySQL e dot txt file so next time then I'm going to enter this SQL query altered use of the host identified by doc password so you need to give the password that you have given the when you were installing workbench of the sub so he gave root and I'm gonna save this file Josie and open this file and paste it turn sit right I have this masquerade I don't a signal next what you want to do is to navigate to the folder where you have installed - cur server so it should be Program Files MySQL MySQL server 8 and inside B you should have the - cool but yeah open the command prompt the span you need to open the command prompt in the administrator Phillips no no come on Chrome in that better and I'm going to navigate to this place so I'm going to see the East and I'm inside the bin folder so after navigating to the bin folder then what you have to do is find this part where you have the ini file my dot ini file is located so it is located inside the C Drive and make sure you have the option hidden items to be deemed and there you will have folder called program data said that you will have a folder for - Cuban said that - cassava 8.0 and here you have the my dot ini file then copy this part and on the command prompt type - QLD double - before equal sign and make sure you have trouble slash after that double slash enter white dot ini close by inverted commas then type double dash init file and here you need to give the path ooh the file that we have created earlier so it was inside the C Drive and the name is my SQL - don't add in word this time if you press ENTER you will not be able to see what is happening behind the scenes so just enter double dash console so you can see what is happening behind the scene so presenter and Z of the like this ready for connections version 8.0 socket is one end or 0-6 SQL server is ready for the connections press control-c get out from this so your message the server is shut down close it and again go to your task manager and start the MySQL server is getting started and it is running now run come on from can now type - Q - you the room and the password should be the password that you have entered in the MySQL - in its way and now you have access to my square and after that you can delete this money square inside like we have it escalated thank you for watching you have a nice

Channel: Don Hash

Views: 113,295

Keywords: access denied, root@localhost, mysql, mysql server, windows, solve mysql server issues

Id: uD2c1GQSc-I

Length: 5min 10sec (310 seconds)

Published: Fri May 15 2020