Tutorial by Examples

To change MySQL's root user password: Step 1: Stop the MySQL server. in Ubuntu or Debian: sudo /etc/init.d/mysql stop in CentOS, Fedora or Red Hat Enterprise Linux: sudo /etc/init.d/mysqld stop Step 2: Start the MySQL server without the privilege system. sudo mysqld_safe --skip-grant-tab...

When we want to change root password in windows, We need to follow following steps : Step 1 : Start your Command Prompt by using any of below method : Perss Crtl+R or Goto Start Menu > Run and then type cmd and hit enter Step 2 : Change your directory to where MYSQL is installed, In my case i...

Stop the MySQL (mysqld) server/daemon process. Start the MySQL server process the --skip-grant-tables option so that it will not prompt for a password: mysqld_safe --skip-grant-tables & Connect to the MySQL server as the root user: mysql -u root Change password: (5.7.6 and newer): ALT...