How to change username of Administrator user in SolusVM?

Question

How to change username of the Administrator user in SolusVM?

Answer

It is not possible to change the username of an Administrator user via the SolusVM interface.

As a workaround, it is possible to change the username of an administrator via a direct query in SolusVM database.

1. Connect to the SolusVM Master node via SSH

2. Create a database backup

3. Change username for Administrator user:

   # echo 'update administrators set username="new_username" where adminid=ID;' | awk -F: '{ system("MYSQL_PWD='"'"'" $3 "'"'"' mysql -u " $2 " "$1) }' /usr/local/solusvm/includes/solusvm.conf

   where:

   new_username - the necessary username for Administrator user.

   ID - ID of the necessary Administrator user - it can be found in SolusVM > Configuration > Administrators.

   How to find ID of an Administrator user in SolusVM?