mysql server root password recovery - Revision history

Nighthawk at 03:07, 12 July 2016

2016-07-12T03:07:58Z

Nighthawk at 22:12, 24 May 2016

2016-05-24T22:12:31Z

Nighthawk: Created page with "# Stop MySQL # sudo /etc/init.d/mysqld stop # start mysql in Safe mode # mysqld_safe --skip-grant-tables & # Login as root # mysql -uroot # Reset Password # use my..."

2016-05-24T22:11:43Z

Created page with "# Stop MySQL # sudo /etc/init.d/mysqld stop # start mysql in Safe mode # mysqld_safe --skip-grant-tables & # Login as root # mysql -uroot # Reset Password # use my..."

New page

# Stop MySQL

# sudo /etc/init.d/mysqld stop

# start mysql in Safe mode

# mysqld_safe --skip-grant-tables &

# Login as root

# mysql -uroot

# Reset Password

# use mysql;
mysql> update user set password=PASSWORD("mynewpassword") where User='root';
mysql> flush privileges;
mysql> quit

# Restart

# killall mysqld
# /etc/init.d/mysqld start

[[category:mysql]]

@@ Line 1: / Line 1: @@
 Stop MySQL
-  # sudo /etc/init.d/mysqld stop
+  # sudo /etc/init.d/mysql stop
 start mysql in Safe mode
@@ Line 14: / Line 14: @@
 Reset Password
-  # use mysql;
+  mysql> use mysql;
   mysql> update user set password=PASSWORD("mynewpassword") where User='root';
   mysql> flush privileges;
@@ Line 22: / Line 22: @@
   # killall mysqld
-  # /etc/init.d/mysqld start
+  # /etc/init.d/mysql start
 start and stop commands may vary depending on Linux distro
 [[category:mysql]]

@@ Line 1: / Line 1: @@
-# Stop MySQL
+Stop MySQL
   # sudo /etc/init.d/mysqld stop
-# start mysql in Safe mode
+start mysql in Safe mode
   # mysqld_safe --skip-grant-tables &
-# Login as root
+Login as root
   # mysql -uroot
-# Reset Password
+Reset Password
   # use mysql;
@@ Line 19: / Line 19: @@
   mysql> quit
-# Restart
+Restart
   # killall mysqld
   # /etc/init.d/mysqld start
 [[category:mysql]]