MySQL: How to reset or change the MySQL root password?

The only method that worked for me is the one described here (I am running ubuntu 14.04). For the sake of clarity, these are the steps I followed:\n\n\nsudo vim /etc/mysql/my.cnf\nAdd the following lines at the end:\n\n[mysqld]\n\nskip-grant-tables\nsudo service mysql restart\nmysql -u root\nuse mysql\nselect * from mysql.user where user = 'root'; - Look at the top to determine whether the password column is called\npassword or authentication_string\nUPDATE mysql.user set *password_field from above* = PASSWORD('your_new_password') where user = 'root' and host = 'localhost'; - Use the proper password column from above\nFLUSH PRIVILEGES;\nexit\nsudo vim /etc/mysql/my.cnf\nRemove the lines added in step 2 if you want to keep your security standards.\nsudo service mysql restart\n\n\nFor reference : https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html",

In my case this option helped : https://stackoverflow.com/a/49610152/13760371\nThank you, Rahul.\nexcept for the following moment, when I try entered command:\nUPDATE mysql.user SET authentication_string=PASSWORD('YOURNEWPASSWORD'), plugin='mysql_native_password' WHERE User='root' AND Host='%';\n\nthe console issued a warning:\n1681 'password' is deprecated and will be removed in a future release\n\ncured with this command:\nUPDATE mysql.user SET authentication_string=CONCAT('*', UPPER(SHA1(UNHEX(SHA1('NEWPASSWORD'))))), plugin='mysql_native_password' WHERE User='root' AND Host='localhost';\n\nMySQL version 5.7.X\nMy variant:\n1. > sudo service mysql stop\n2. > sudo mkdir /var/run/mysqld\n3. > sudo chown mysql: /var/run/mysqld\n4. > sudo mysqld_safe --skip-grant-tables --skip-networking &\n5. > mysql -uroot mysql\n6. > UPDATE mysql.user SET authentication_string=CONCAT('*', UPPER(SHA1(UNHEX(SHA1('NEWPASSWORD'))))), plugin='mysql_native_password' WHERE User='root' AND Host='localhost';\n7. > \\q;\n8. > sudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdown\n9. > sudo service mysql start\n",

To update the \"root\" Mysql user password you must have in mind that you will need of super user permissions for that. If you have super user privilegies, try the following commands:\n\nMySQL 5.7.6 and later\n\nsudo su\nservice mysql stop\nmysql -u root\nALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';\n\\q;\nexit\nmysql -u root -p MyNewPass\n\n\nMySQL 5.7.5 and earlier\n\nsudo su\nservice mysql stop\nmysql -u root\nSET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');\n\\q;\nexit\nmysql -u root -p MyNewPass\n",

The official and easy way to reset the root password on an ubuntu server...\n\nIf you are on 16.04, 14.04, 12.04:\n\nsudo dpkg-reconfigure mysql-server-5.5\n\n\nIf you are on 10.04:\n\nsudo dpkg-reconfigure mysql-server-5.1\n\n\nIf you are not sure which mysql-server version is installed you can try: \n\ndpkg --get-selections | grep mysql-server\n\n\nUpdated notes for mysql-server-5.7\n\nNote that if you are using mysql-server-5.7 you can not use the easier dpkg-reconfigure method shown above. \n\nIf you know the password, login and run this: \n\nUPDATE mysql.user SET authentication_string=PASSWORD('my-new-password') WHERE USER='root';\nFLUSH PRIVILEGES;\n\n\nAlternatively, you can use the following: \n\nsudo mysql_secure_installation\n\n\nThis will ask you a series of questions about securing your installation (highly recommended), including if you want to provide a new root password. \n\nIf you do NOT know the root password, refer to this Ubuntu-centric write up on the process. \n\nSee for more info:\n\nhttps://help.ubuntu.com/16.04/serverguide/mysql.html\nhttps://help.ubuntu.com/14.04/serverguide/mysql.html",

This solution belongs to the previous version of MySQL.\nBy logging in to MySQL using socket authentication, you can do it.\n\nsudo mysql -u root\n\n\nThen the following command could be run. \n\nALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';\n\n\nDetails are available here .",

As mysql documentation on the password() function says: \n\n\n This function was removed in MySQL 8.0.11.\n\n\nThis invalidates pretty much all existing answers for mysql v8.0.11 and newer.\n\nPer mysql documentation the new generic way to reset the root password is as follows:\n\n\n The preceding sections provide password-resetting instructions\n specifically for Windows and Unix and Unix-like systems.\n Alternatively, on any platform, you can reset the password using the\n mysql client (but this approach is less secure):\n \n Stop the MySQL server if necessary, then restart it with the\n --skip-grant-tables option. This enables anyone to connect without a password and with all privileges, and disables account-management\n statements such as ALTER USER and SET PASSWORD. Because this is\n insecure, if the server is started with the --skip-grant-tables\n option, it enables --skip-networking automatically to prevent remote\n connections.\n \n Connect to the MySQL server using the mysql client; no password is\n necessary because the server was started with --skip-grant-tables:\n\nshell> mysql\n\n \n In the mysql client, tell the server to reload the grant tables so that account-management statements work:\n\nmysql> FLUSH PRIVILEGES;\n\n \n Then change the 'root'@'localhost' account password. Replace the password with the password that you want to use.\n To change the password for a root account with a different host name\n part, modify the instructions to use that host name.\n\nmysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';\n\n \n You should now be able to connect to the MySQL server as root using the\n new password. Stop the server and restart it normally (without the\n --skip-grant-tables and --skip-networking options).\n",

What worked for me (Ubuntu 16.04, mysql 5.7):\n\nStop MySQL\n\nsudo service mysql stop\n\n\nMake MySQL service directory.\n\nsudo mkdir /var/run/mysqld\n\n\nGive MySQL user permission to write to the service directory.\n\nsudo chown mysql: /var/run/mysqld\n\n\nStart MySQL manually, without permission checks or networking.\n\nsudo mysqld_safe --skip-grant-tables --skip-networking &\n\n\nOn another console, log in without a password.\n\nmysql -uroot mysql\n\n\nThen:\n\nUPDATE mysql.user SET authentication_string=PASSWORD('YOURNEWPASSWORD'), plugin='mysql_native_password' WHERE User='root' AND Host='localhost';\nEXIT;\n\n\nTurn off MySQL.\n\nsudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdown\n\n\nStart the MySQL service normally.\n\nsudo service mysql start\n",

This is the solution for me. I work at Ubuntu 18.04:\nhttps://stackoverflow.com/a/46076838/2400373\n\nBut is important this change in the last step:\n\nUPDATE mysql.user SET authentication_string=PASSWORD('YOURNEWPASSWORD'), plugin='mysql_native_password' WHERE User='root' AND Host='localhost'; \n",

You can use this command:\n\nUPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';\n\n\nafter that please use flush:\n\nFLUSH PRIVILEGES;\n",

I am sharing the step by step final solution to reset a MySQL password in Linux \nUbuntu. \n\nReference taken from blog (dbrnd.com)\n\nStep 1:\nStop MySQL Service.\n\nsudo stop mysql\n\n\nStep 2:\nKill all running mysqld.\n\nsudo killall -9 mysqld\n\n\nStep 3:\nStarting mysqld in Safe mode.\n\nsudo mysqld_safe --skip-grant-tables --skip-networking &\n\n\nStep 4:\nStart mysql client\n\nmysql -u root\n\n\nStep 5:\nAfter successful login, please execute this command to change any password.\n\nFLUSH PRIVILEGES;\n\n\nStep 6:\nYou can update mysql root password .\n\nUPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';\n\n\nNote: On MySQL 5.7, column Password is called authentication_string.\n\nStep 7:\nPlease execute this command.\n\nFLUSH PRIVILEGES;\n",

For Ubuntu 18.04 and mysql version 14.14 Distrib 5.7.22 follow the below step to reset the mysql password.\n\nStep 1\n\nsudo systemctl stop mysql\n\n\nStep 2\n\nsudo systemctl edit mysql\n\n\nThis command will open a new file in the nano editor, which you'll use to edit MySQL's service overrides. These change the default service parameters for MySQL. This file will be empty, so add the following content:\n\n[Service]\nExecStart=\nExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid --skip-grant-tables --skip-networking\n\n\nStep 3\n\nsudo systemctl daemon-reload\nsudo systemctl start mysql\n\n\nStep 4\n\nsudo mysql -u root\n\n\nStep 5\n\nFLUSH PRIVILEGES;\n\n\nStep 6\n\nUPDATE mysql.user SET authentication_string = PASSWORD('new_password') WHEREuser = 'root';\n\n\nStep 7\n\nUPDATE mysql.user SET plugin ='mysql_native_password' WHERE user = 'root';\n\n\nStep 8\n\nsudo systemctl revert mysql\n\n\nand finally \n\nsudo systemctl restart mysql\n\n\nNow enjoy",

If you know the 'root' users password, log in to mysql with that credentials. Then execute the following query to update the password.\n\nALTER USER 'root'@'localhost' IDENTIFIED BY 'new_passowrd';\n",

At first run this command:\n\nsudo mysql\n\n\nand then you should check which authentication method of your MySQL user accounts use.So run this command \n\nSELECT user,authentication_string,plugin,host FROM mysql.user;\n\n\nnow you can see something like this already :\n\n+------------------+-------------------------------------------+-----------------------+-----------+\n| user | authentication_string | plugin | host |\n+------------------+-------------------------------------------+-----------------------+-----------+\n| root | | auth_socket | localhost |\n| mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |\n| mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |\n| debian-sys-maint | *CC744277A401A7D25BE1CA89AFF17BF607F876FF | mysql_native_password | localhost |\n+------------------+-------------------------------------------+-----------------------+-----------+\n\n\nin the table that is in the above , you can see that all of your mysql users accounts status & if you have set a password for root account before you see mysql_native_password in plugin column instead auth_socket.\nAll in all for change your root password you should run :\n\nALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';\n\n\n\nBe sure to change password to a strong password of your choosing.\nThen for reload your server to put your new changes into effect run this;\n\nFLUSH PRIVILEGES;\n\n\nSo again check the authentication methods which has employed by your mysql , by this command:\n\nSELECT user,authentication_string,plugin,host FROM mysql.user;\n\n\nand now the output is :\n\n+------------------+-------------------------------------------+-----------------------+-----------+\n| user | authentication_string | plugin | host |\n+------------------+-------------------------------------------+-----------------------+-----------+\n| root | *3636DACC8616D997782ADD0839F92C1571D6D78F | mysql_native_password | localhost |\n| mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |\n| mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |\n| debian-sys-maint | *CC744277A401A7D25BE1CA89AFF17BF607F876FF | mysql_native_password | localhost |\n+------------------+-------------------------------------------+-----------------------+-----------+\n\n\nas you can see in the grant table your root account has mysql_native_password\n.\nnow you can exit MYSQL shell \n\nexit;\n\n\nThat's it.just you should restart mysql by sudo service mysql restart.\nNow you can login to mysql as a root account with your password easily.",

Echoing rogerdpack's comment: if you don't know the MySQL root password and you don't care about MySQL data/settings, you can reinstall it and reset the root's password as follows:\n\nsudo apt-get remove --purge mysql-server mysql-client mysql-common\nsudo rm -rf /var/lib/mysql\nsudo apt-get install -y mysql-server mysql-client \n\n\nDuring the installation, you can choose the root's password:\n\n",

The steps below worked for me. I'm using MySQL 8.* on Ubuntu\n\nStop MySQL service and check status to confirm the service stopped\n\n\nsudo systemctl stop mysql\nsudo systemctl status mysql\n\n\n\nEdit the systemd config file so you can access MySQL without permission check\nsudo systemctl edit mysql\n\nCopy and paste the following 3 lines\n\n\n\n[Service]\n\nExecStart=\n\nExecStart=/usr/sbin/mysqld --skip-grant-tables --skip-networking\n\n\nAfter pasting the lines CTRL+0 to save and then CTRL+X to exit\n\nReload mysql service and start it (starts the service with --skip-grant-table)\n\n\nsudo systemctl daemon-reload\nsudo systemctl start mysql\n\n\n5.Now connect to MySQL server without password\nsudo mysql -u root\n\n6.Load the grant tables by running\nmysql> FLUSH PRIVILEGES;\n\n\nReset the root password\n\n\nmysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH\nmysql_native_password BY 'YourPasswordHere';\n\n\nClose the mysql connection\n\n\nmysql> exit\n\n\nRevert the modification done on the mysql systemd file\n\n\nsudo systemctl revert mysql\n\n\nReload the mysql daemon for changes to take place.\n\n\nsudo systemctl daemon-reload\n\n\nLastly restart the MySQL service\n\n\nsudo systemctl restart mysql\n\nNow connect to mysql with the new password set in step 7\nYou can visit this link reset root password for mysql 8 for more details.",

I faced problems with ubuntu 18.04 and mysql 5.7, this is the solution\n\nTry restart mysql-server before execution the comands \n\nsudo service mysql restart\n\n\nMYSQL-SERVER >= 5.7\n\nsudo mysql -uroot -p\nUSE mysql;\nUPDATE user SET authentication_string=PASSWORD('YOUR_PASSWORD') WHERE User='root';\nUPDATE user SET plugin=\"mysql_native_password\";\nFLUSH PRIVILEGES;\nquit;\n\n\nMYSQL-SERVER < 5.7\n\nsudo mysql -uroot -p\nUSE mysql;\nUPDATE user SET password=PASSWORD('YOUR_PASSWORD') WHERE User='root';\nUPDATE user SET plugin=\"mysql_native_password\";\nFLUSH PRIVILEGES;\nquit;\n",

If you know your current password, you don't have to stop mysql server.\nOpen the ubuntu terminal.\nLogin to mysql using:\n\nmysql - username -p\n\n\nThen type your password.\nThis will take you into the mysql console.\nInside the console, type:\n\n> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';\n\n\nThen flush privileges using:\n\n> flush privileges;\n\n\nThen you are all done.",

Instead of resetting the password there is a work around on the local machine if you have setup phpmyadmin to connect without giving the password or username. Check this out by starting mysql, apache etc. I have xampp installed in my local machine. So starting the xampp will start all the necessary services. Now going to http://localhost/phpmyadmin shows me all the databases. This confirms that you have saved the username and passsword in the config file of phpmyadmin which can be found in the phpmyadmin install location. If you have xampp installed the phpmyadmin folder can be found in the root folder of xampp installation. Search for the word password in the config.inc.php file. There you will find the password and username. ",

Change the MySQL root password.\n\nThis method exposes the password to the command-line history, these commands should be run as root. \n\n\nLogin through mysql command line tool:\n\nmysql -uroot -poldpassword\n\nRun this command:\n\nSET PASSWORD FOR root@'localhost' = PASSWORD('newpassword');\n\n\n\nor \n\n\nRun this command, which sets a password for the current user ('root' for this case) :\n\n\n SET PASSWORD = PASSWORD('newpassword');\n\n",

You don't need all this. Simply log in:\n\nmysql -u root -p\n\nThen change the current user's password as the mysql> prompt:\n\nmysql> set password=password('the_new_password');\nmysql> flush privileges;\n",

You can easily change the mysql password if deployed on xampp through provided phpadmin gui.\n\nphpMyAdmin -> User Accounts -> Edit Privileges (Select the intended user) -> Change Password (Tab)\n",

\nStop MySQL\nsudo service mysql stop\nMake MySQL service directory.\nsudo mkdir /var/run/mysqld\nGive MySQL user permission to write to the service directory.\nsudo chown mysql: /var/run/mysqld\nStart MySQL manually, without permission checks or networking.\nsudo mysqld_safe --skip-grant-tables --skip-networking &\n\n\n5.Log in without a password.\nmysql -uroot mysql\n\n6.Update the password for the root user.\n\nUPDATE mysql.user SET authentication_string=PASSWORD('YOURNEWPASSWORD'), plugin='mysql_native_password' WHERE User='root' AND Host='%';\nEXIT;\n\n\nTurn off MySQL.\nsudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdown\nStart the MySQL service normally.\nsudo service mysql start\n",

Most of the answers on this topic are outdated; two major changes have occurred in MySQL up until the writing of this answer:\n\n1- the 'Password' field in the user table has been replaced by 'authentication_string' column.\n\n2- the 'Password' encryption function : PASSWORD(\"of some text\") is deprecated. \n\nPlease refer to this link for further information:dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html ",

for mysql 5.6 this command works and you can set password through the wizard:\n\nsudo dpkg-reconfigure mysql-server-5.6\n",

If you would like to change the MySQL root password, in a terminal enter:\n\nsudo dpkg-reconfigure mysql-server-5.5\n\nThe MySQL daemon will be stopped, and you will be prompted to enter a new password.",

1.Open nano / vim to create a file with the following content and Save file as ~/mysql-pwd\nALTER USER 'root'@'localhost' IDENTIFIED BY 'NEWPASSWORD';\n\n\nStop mysql sudo systemctl stop mysql\nRun sudo mysqld -init-file=~/mysql-pwd\nRestart mysql sudo systemctl start mysql\nNow login mysql -u root -p. password will be your NEWPASSWORD\n",

Set / change / reset the MySQL root password on Ubuntu Linux. Enter the following lines in your terminal.\n\nStop the MySQL Server: sudo /etc/init.d/mysql stop\n(In some cases, if /var/run/mysqld doesn't exist, you have to create it at first: sudo mkdir -v /var/run/mysqld && sudo chown mysql /var/run/mysqld\nStart the mysqld configuration: sudo mysqld --skip-grant-tables &\nLogin to MySQL as root: mysql -u root mysql\nReplace YOURNEWPASSWORD with your new password:\n\nFor MySQL < 8.0\nUPDATE mysql.user SET Password = PASSWORD('YOURNEWPASSWORD') WHERE User = 'root';\nFLUSH PRIVILEGES;\n\nIf your MySQL uses new auth plugin, you will need to use: update user set plugin="mysql_native_password" where User='root'; before flushing privileges.\n\nNote: on some versions, if password column doesn't exist, you may want to try:\nUPDATE user SET authentication_string=password('YOURNEWPASSWORD') WHERE user='root';\n\nNote: This method is not regarded as the most secure way of resetting the password, however, it works.\nFor MySQL >= 8.0\nFLUSH PRIVILEGES;\nALTER USER 'root'@'localhost' IDENTIFIED BY 'YOURNEWPASSWORD';\nFLUSH PRIVILEGES;\n\nLast step:\nAs noted in comments by @lambart, you might need to kill the temporary password-less mysql process that you started, i.e. sudo killall -9 mysqld and then start normal daemon: sudo service mysql start\nReferences:\n\nSet / Change / Reset the MySQL root password on Ubuntu Linux\nHow to Reset the Root Password (v5.6)\nHow to Reset the Root Password (v8.0)\n",

This works like charm I did it for Ubuntu 16.04.\nFull credit to below link as I got it from there. \n[https://coderwall.com/p/j9btlg/reset-the-mysql-5-7-root-password-in-ubuntu-16-04-lts][1]\n\nStop MySQL\n\nsudo service mysql stop\n\n\nMake MySQL service directory.\n sudo mkdir /var/run/mysqld\n\nGive MySQL user permission to write to the service directory.\n\nsudo chown mysql: /var/run/mysqld\n\n\nStart MySQL manually, without permission checks or networking.\n\nsudo mysqld_safe --skip-grant-tables --skip-networking &\n\n\nLog in without a password.\n\nmysql -uroot mysql\n\n\nUpdate the password for the root user.\nmake sure at atleast root account gets updated by the below query.\nmake some selection and check the existing values if you like\n\nUPDATE mysql.user SET \nauthentication_string=PASSWORD('YOURNEWPASSWORD'), \nplugin='mysql_native_password' WHERE User='root';\nEXIT;\n\n\nTurn off MySQL.\n\nsudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdown\n\n\nStart the MySQL service normally.\n\nsudo service mysql start\n",

When you use MySQL's PASSWORD() on the system where you want to change the password, it can cause the password turn up in a MySQL log in cleartext [source]. Keeping them, their backups etc. as secure as the password sounds like nightmare to me, so I rather like to do it as follows:\n\n\nOn your local machine, run this with your password:\n\n mysql -u someuser -p < <(echo \"SELECT PASSWORD('mypass');\")\n\n\nNote the space in front to prevent it from turning up in the bash history (for other distros than Ubuntu, this might work differently – source).\nOn your server machine, execute the following command to change its MySQL root password (replace myhash with your password's hash as printed by the first command):\n\nmysql -u root -p < <(echo \"SET PASSWORD FOR root@localhost = 'myhash';\")\n\nOptionally, let's be a bit paranoid: On your local machine, clear your terminal screen with clear and purge your virtual terminal scrollback, to hide the cleartext password appearing in the command above.\n",