I'm running MySQL in Ubuntu, default installation.
How can I change the username from
root
admin
After connecting to MySQL run
use mysql;
update user set user='admin' where user='root';
flush privileges;
That's it.
If you also want to change password run
update user set password=PASSWORD('new password') where user='admin';
before flush privileges;
.