How to set a MySQL Password in WAMP Server. A Lucid Nerd beginner tutorial covering how to set a password for the MySQL database server in WAMP( Windows, Apache, MySQL and PHP ) on Windows…
Original source
Setting the MySQL Password in WAMP – Lucid Nerd Tutorial
49 responses to “Setting the MySQL Password in WAMP – Lucid Nerd Tutorial”
really helpful but couldn't find those file in my notepad (I don't have notepad ++) but my password was changed
thanks ..
Thanks
Brazil
Thanks Sir,It works,God Bless U
what if I forgot my password
Clear instruction and very helpful, and the most important thing – it worked! Thank you!
to change password use:
update user set authentication_string=password('1111') where user='root';
for newer versions
THANK YOU
thanks for the video, it was really helpful. BTW just being inquisitive, where is your accent from? Is it like African or Carribbean?
give u one like for your help it's resume and claire , thinks again 4 your bwt vdeo
Thanks mate, what a brilliant tutorial. Problem fixed!
great tut, man, thank you.
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)what does this mean? mysql won't open >.<
thanx brother that realy resolved my issue
After 3 years this still works. So happy for this.
Works on Windows 10 Pro with Wamp Server 2.5
This is how tutorials are made people!
No skipping explaining steps that many others do that gets you stuck and pissed off 😛
Very CLEAR step-by-step instructions…. Thank you!!!
Awesome! Thank you!
This is what I was looking thank you!
Thanks, This was very nice and easy 🙂
thank you, great video 🙂
speed up grandpa!
thanks !!!
Thanks for that, saved me time at work 🙂
You are awesome! Now I can do RoR on Windows.
dose any one know how to fix a error code 1273 in mysql
I thanks you had help me a lot. :))
You can also just browse to the folder, type "cmd" in the addresss bar and press enter. Command prompt will open with the requested folder.
Thanks, That helped a lot!!
Nothing to say except thanks to U
Fantastic. Tried some other guides that didn't help. This one did the trick in a tick.
thank you
That was really helpful, Thanks!
Good god man thank you!! many bad text based tutorials out there that just didn't work in cmd for me. Much appreciated!
Thanks, That helped a lot
Thank You
Thank
You
Very well explained, and it worked like a charm! Thank you.
thanks a lot!!
Thanks a lot. I was going crazy cause phpMyAdmin wasn't connecting.
thank u very much for your help
Thank you!
muchas gracias!!! Saludos desde Zacatecas Mexico! (Y)
Thank you very much, it was much needed.
nice one 🙂
picture worth 1K words. spent longer than anyone should know reading and trying to fix. Your steps and speed with this demo as you clearly talked me through these steps is very appreciated. Thank you!
You can also use this command:
SET PASSWORD FOR root@localhost= password('yourPasswordGoesHere');
Thank you, I followed this step by step and it worked just as expected. I tried to do this on my own, I was frustrated for hours. You saved my day!
first of all thanks, you helped me alot .but i have a question, how can i change the username root?
This helped me a lot. Thanks!
Did your install of Apache Server, MySQL & PHP on Windows 8, they all worked perfectly, your tutorials are really outstanding. I even learned several tricks for using Windows 8, thanks!