I am using cockroach db v2.1.4 and created some databases on that. Now i want to create username “admin” but i am not able to create admin user, it’s shows “pq: a role named admin already exists”, So i tried to set password for admin user but it’s showing that user admin is not exists. So can anyone help me to understand the logic behind it, Why i am not able to create admin user or password.
Also i am not able to set password for root user.