Posts

Showing posts with the label Mysql root change password

Set / Change / Reset the MySQL root password on Ubuntu Linux

1.  Stop the MySQL Server.                        sudo /etc/init.d/mysql stop 2.  Stop the MySQL Server. sudo /etc/init.d/mysql stop 3.   Start the mysqld configuration.      sudo mysqld --skip-grant-tables & 4.   Login to MySQL as root.           mysql -u root mysql 5.  Replace YOUR NEWP ASSWORD with your new password! UPDATE user SET Password=PASSWORD ('your password') WHERE User='root'; FLUSH PRIVILEGES; exit; Note: This method is not regarded as the securest way of resetting the password. However it works.