How to set root password to null

by

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.

More Related Contents:

  1. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  2. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  3. 1052: Column ‘id’ in field list is ambiguous
  4. Codeigniter – multiple database connections
  5. Column count doesn’t match value count at row 1
  6. How to add levenshtein function in mysql?
  7. How to search JSON data in MySQL?
  8. MySQL > Table doesn’t exist. But it does (or it should)
  9. Is the primary key automatically indexed in MySQL?
  10. How do I modify a MySQL column to allow NULL?
  11. Connect to mysql in a docker container from the host
  12. Is there ANY_VALUE capability for mysql 5.6?
  13. Set NOW() as Default Value for datetime datatype?
  14. MySQL update CASE WHEN/THEN/ELSE [duplicate]
  15. MySQL SELECT DISTINCT multiple columns
  16. SQL DELETE with JOIN another table for WHERE condition
  17. How to connect to a MySQL Data Source in Visual Studio
  18. DOs and DONTs for Indexes [closed]
  19. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  20. How can I implement single table inheritance using Laravel’s Eloquent?
  21. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  22. MySQL – ORDER BY values within IN()
  23. mysql_fetch_row() vs mysql_fetch_assoc() vs mysql_fetch_array() [duplicate]
  24. Mysql select where not in table
  25. How to format number with “.” as thousands separator and “,” as decimal separator?
  26. Using DISTINCT and COUNT together in a MySQL Query
  27. Which DATATYPE is better to use TEXT or VARCHAR?
  28. Error installing mysqlclient for python on Ubuntu 18.04
  29. Array data type, split string,
  30. How can I make a table in MySQL called “order”?

Leave a Comment