Can't access to admin account

[mariodelzo]

Hi people, i have the next problem, I can't access to the admin account in sugar crm after I was clicking on checkbox for group user in the account admin, That is the reason why I was getting the error message not a valid username. Now, how can i restore it, or create a new admin account.

I really appreciate your time to help its very important to me.

Mario Delzo
Contact Center Support

[kuske]

do not click on anything
You can reset this flag in mySQL admin or phpmyadmin by the sql command

update users set is_group=0 where user_name='admin';

[mariodelzo]

do not click on anything
You can reset this flag in mySQL admin or phpmyadmin by the sql command

update users set is_group=0 where user_name='admin';

*******************
Ok, i did it , that you suggest , but i have the next message:

mysql> update users set is_group=0 where user_name='admin';
ERROR 1046 (3D000): No database selected

What's my error?, please...

Thanks

[JVWay]

Type 'USE <databasename>' without the quotes and replace <databasename> with the name of your database. Do this before any other command.

[mariodelzo]

Many Thanks Kuske, i found my error, the solution was:
mysql> use sugarcrm;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update users set is_group=0 where user_name='admin';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0


Now , i can administrated my SugarCRM, thank you very much, i'll apreciated.

Mario Delzo
Contact Center