How to reset or change MySQL root password in production server? | Step by step process explained
This video explains step by step process for changing mysql root user password in Linux. Below are the steps to follow
Step 1 : sudo /etc/init.d/mysqld stop
Step 2 : sudo mysqld_safe --skip-grant-tables &
Step 3 : mysql -u root
Step 4 : use mysql;
Step 5 : UPDATE user SET password=PASSWORD("Jksbahjkal") WHERE User='root'
Step 6 : flush privileges;
If you like the video please like, comment and subscribe to the channel