By nibi on

Hi,

I have a problem with role asigned to user1 and I can't go to admin site.
How I can edit user role from phpmyadmin?
I don't find the table in the bd...

thanks in advance

⋅ Categories: Drupal 7.x

Comments

jaypan’s picture

jaypan
Location Victoria, BC
commented

It's rarely a good idea to directly mess with the database, and pretty much never a good idea to do so if you don't know what you are doing - and since you are asking this question, I think it's safe to say you don't know what you are doing.

Why don't you tell us what your problem is, and maybe we can help you to solve it.

Contact me to contract me for D7 -> D10/11 migrations.

nibi’s picture

nibi commented

Hi, thanks for your reply,

I have a website with 2 navigation modes depending if role "mycollection" is active or not,
if it's actived I restrict access to all admin pages for theme purposes,
I accidentally activated the role "mycollection" to user1...

I have bd's backups but for long time ago because I stopped the project and now I returned to launch and testing it
I'm not a mysql or php expert, but I manage well, simply I can't find the table with the relation user/role.

thanks and sorry for my poor english...

yelvington’s picture

yelvington commented

Much safer to use drush

http://drushcommands.com/drush-6x/user/user-remove-role/

nibi’s picture

nibi commented

I do not have that module installed and I can't install modules because the role "mycollection" is active in my user-1 and I locked the administration pages for that "mycollection" role

jaypan’s picture

jaypan
Location Victoria, BC
commented

Drush is not a module, it's a command line tool for doing things on Drupal, from outside of Drupal.

If you have not used Drush, it's worth the time to figure out. It's probably the single most important Drupal tool that I use. If you are Windows it can be a headache to figure out and get working though.

Contact me to contract me for D7 -> D10/11 migrations.

nibi’s picture

nibi commented

wow! , thank you very much.
Forgive my ignorance but I thought that drush needed a module to run, now it makes sense and really very useful.

thans again