GRRR!! how can I create admin through phpmyadmin?

long story how I got to this point, but the bottom line is this:

1) I need to create an admin user through phpmyadmin
2) I did, set user level to 10, and the wp_capabilites to a:1:{s:10:”administrator”;b:1;}

but it didn’t work. the admin only has permission to *log in* and that’s all. what do I need to do to get this account acting as admin? it looks right to me…thanks!