How to reset the root password in MySQL 8.0.11?

by

as here says:

This function was removed in MySQL 8.0.11

1.if you in skip-grant-tables mode
in mysqld_safe:

UPDATE mysql.user SET authentication_string=null WHERE User="root";
FLUSH PRIVILEGES;
exit;

and then, in terminal:

mysql -u root

in mysql:

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

2.not in skip-grant-tables mode
just in mysql:

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

More Related Contents:

  1. MySQL user DB does not have password columns – Installing MySQL on OSX
  2. mysql root password forgotten
  3. What data type to use for hashed password field and what length?
  4. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  5. MySQL – ERROR 1045 – Access denied
  6. Setting the MySQL root user password on OS X
  7. MySQL root password change
  8. Resetting ROOT password in MySQL 5.6
  9. MySQL password function
  10. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  11. How to change the mysql root password
  12. How to get back Lost phpMyAdmin Password, XAMPP
  13. How do you use MYSQL in ColdFusion? [closed]
  14. How do I do a bulk insert in mySQL using node.js
  15. Reorder / reset auto increment primary key
  16. Required to join 2 tables with their FKs in a 3rd table
  17. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  18. GROUP_CONCAT with limit
  19. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  20. SQL Query to show nearest date?
  21. How can I modify the size of column in a MySQL table?
  22. How to auto generate migrations with Sequelize CLI from Sequelize models?
  23. Getting all parent rows in one SQL query
  24. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  25. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  26. MySQL view performance
  27. Does MySQL Regexp support Unicode matching
  28. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  29. How to retrieve JSON data from MySQL?
  30. MySQL: Compare BETWEEN time

Leave a Comment