Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to reset mysql root password
16-08-2015, 04:05 PM,
#1
How to reset mysql root password
Reset root mysql password

#service mysql stop
#mysqld_safe --skip-grant-tables &
#mysql -uroot
mysql> use mysql;
mysql> update user set password=PASSWORD("mynewpassword") where User='root';
mysql> flush privileges;
mysql> quit
#service mysql stop
#service mysql start
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)