Alter name from database USER using MYSQL

Question

I consulted the oficial doc from MYSQL: https://dev.mysql.com/doc/refman/5.7/en/alter-user.html

But does not work.

I have to Alter the username from database User.

Example:

User database:

login: john password: 123

New name:

login: johny password:123

Is it possible?

Example in mysql panel:

If i change de Login name i can... All the privileges are maintained

Answer 1

open mysql and enter into the database with your username(john) and password(123) -

now enter the following commands :

use mysql;

update user set User='johny'  where User='john';

flush privileges;

And if you also want to change the password then -

again enter into database with your username and password

now enter the following commands :

use mysql;

update user set PASSWORD=password("updated password")  where User='johny';

flush privileges;