How to reset or change MySQL root password in production server? | Step by step process explained

Published: 01 April 2018
on channel: Programming With Prem

4,076

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

Watch video How to reset or change MySQL root password in production server? | Step by step process explained online without registration, duration hours minute second in high quality. This video was added by user Programming With Prem 01 April 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,076 once and liked it 15 people.

876