How to set root password to null

mysql mysql-management
Stormshadow picture Stormshadow · Jan 20, 2010 · Viewed 154.2k times · Source

How can I change the password for root user of MySQL to null -- meaning no password or '' -- from the MySQL command line client?

Answer

Stanislav Karakhanov picture Stanislav Karakhanov · Mar 26, 2016

Worked for me and "5.7.11 MySQL Community Server":

use mysql;
update user set authentication_string=password(''), plugin='mysql_native_password' where user='root';

I had to change the 'plugin' field as well because it was set to 'auth_socket'.

After that I could connect as mysql -u root without a password.

Related questions

ERROR 1396 (HY000): Operation CREATE USER failed for 'jack'@'localhost'

I seem to be unable to re-create a simple user I've deleted, even as root in MySQL. My case: user 'jack' existed before, but I deleted it from mysql.user in order to recreate it. I see no vestiges of …

Read More
mysql command for showing current configuration variables

Can not find a command that displays the current configuration of mysql from within the database. I know I could look at /etc/mysql/my.cnf but that is not what I need.

Read More
Is there a faster way to load mysqldumps?

Possible Duplicate: Speeding up mysql dumps and imports mysqldump is reasonably fast, but dumps of a medium-sized database (20-30 megs) take several minutes to load using mysql my_database < my_dump_file.sql Are there some mysql settings I …

Read More