recover lost root password of mysql code example
Example 1: how to change mysql localhost password
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword'
Example 2: firt time root
Step 1: Open a Terminal Window.
Right-click the desktop, then left-click Open in terminal.
Alternately, you can click Menu > Applications > Accessories > Terminal.
Step 2: Change Your Root Password.
In the terminal window, type the following:
- sudo passwd root.