How to set a MySQL root user password | lynda.com tutorial




Watch this entire course for free at …

source

,

16 responses to “How to set a MySQL root user password | lynda.com tutorial”

  1. 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!

  2. +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!

Leave a Reply