mysql-management

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.

What you are looking for is this: SHOW VARIABLES; You can modify it further like any query: SHOW VARIABLES LIKE ‘%max%’;

yes this bug is there. However, I found a small workaround. Assume the user is there, so drop the user After deleting the user, there is need to flush the mysql privileges Now create the user. That should solve it. Assuming we want to create the user admin @ localhost, these would be the commands: … Read more