16 responses to “How to set a MySQL root user password | lynda.com tutorial”
Hey guys! I found my own, fast way to change password.
1. Navigate to the MySQL bin folder (my path to this folder is "C:Program FilesMySQLMySQL Server 5.7bin") 2. Open Command Window there like this: 2.1. Hold SHIFT and right click on empty space in the bin folder 2.2. Select "Open command window here" 3. Write this command: mysqladmin.exe -u root -p password 4. Write your old password and it will prompt you to enter new password and to confirm it
I hope this helps 🙂 (if it does, please like it so more people see it 🙂 ) Cheers!
+Thainá Rodrigues ANYONE help please! I use Mac and installed mysql and didn't not jot down the temporary password, and now trying to set up or reset password.
So, stuck at 1.24 of this video.
after ls
I type in the terminal
./mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Orujs-MacBook-Pro:bin orujgadimov$
or if continue with the video and type in the following step; it gives me this
./mysqladmin -u root password 'password' mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' Orujs-MacBook-Pro:bin orujgadimov$
I am stuck at this for days and would be very grateful if anyone could jump in and help. I am very new with MySQL. Thanks million beforehand!
Thank you! I had been struggling a while with my passwords and could not find clear instructions to fix them/get them set up. Thanks for being so clear!
16 responses to “How to set a MySQL root user password | lynda.com tutorial”
Hey guys! I found my own, fast way to change password.
1. Navigate to the MySQL bin folder (my path to this folder is "C:Program FilesMySQLMySQL Server 5.7bin")
2. Open Command Window there like this:
2.1. Hold SHIFT and right click on empty space in the bin folder
2.2. Select "Open command window here"
3. Write this command:
mysqladmin.exe -u root -p password
4. Write your old password and it will prompt you to enter new password and to confirm it
I hope this helps 🙂
(if it does, please like it so more people see it 🙂 )
Cheers!
help Access denied for user 'root'@'localhost' (using password: NO)
oh my lord, thank you.
i forgot my password 🙁 how i can changed it, please help me i have an important project
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO). Does anyone know the solution please?
i am not able to find the directory where i installed mysql
i hade gone ahead with default settings please help
ERROR 1045 (28000): Access denied for user 'root'@'localhost'
+Thainá Rodrigues ANYONE help please! I use Mac and installed mysql and didn't not jot down the temporary password, and now trying to set up or reset password.
So, stuck at 1.24 of this video.
after ls
I type in the terminal
./mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Orujs-MacBook-Pro:bin orujgadimov$
or if continue with the video and type in the following step; it gives me this
./mysqladmin -u root password 'password'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Orujs-MacBook-Pro:bin orujgadimov$
I am stuck at this for days and would be very grateful if anyone could jump in and help. I am very new with MySQL. Thanks million beforehand!
-bash: -u: command not found
i am getting this… :/
does it work by cmd?
macs are for faggots
thank you for being so awesome
I need help, someone else set up a password for the root and now I can't access my own database. How can I change the password or create another user?
Thank you! I had been struggling a while with my passwords and could not find clear instructions to fix them/get them set up. Thanks for being so clear!
thank you! just spent hours trying to figure this out – your solution worked in 2 minutes. thank you,
can u do one for xampp please thanks 😀