NETWORKSTIP Networking CCNA,Centos,Ubuntu,Sql,

Made By Muhammad Nafees

Breaking

Wednesday, 30 January 2019

how to reset Mysql root Password

How to reset Mysql root Password

  • sudo /etc/init.d/mysqld stop
  •  sudo mysqld_safe --skip-grant-tables &
 
  • mysql -uroot
 

  •  use mysql;

  •  UPDATE mysql.user SET Password=PASSWORD('Sin2P2Nvqu') WHERE User='root';
  •  FLUSH PRIVILEGES;

No comments:

Post a Comment