PHPMyAdmin - Create New Admin account for website

Question

I am attempting to add an admin user to our website, and none of the credentials work. My goal is to add an adminstrator by creating a query, and mostly all websites I have found are for wordpresses.

My prefix is "cal_users", not "wp_users". I need help, and if someone were to give me the code to copy and paste for the query that would be wonderful. I am using phpmyadmin.

Welcome to StackOverflow Chase! Please review http://stackoverflow.com/help/how-to-ask for tips on crafting a good question. In this case you should be more specific about what you've tried and how it isn't working. — eebbesen, Sep 10 '15 at 21:49

score 1 · Answer 1 · answered Sep 10 '15 at 21:58

1

it must be something like this

update 'cal_usermeta' 
set meta_value='a:1:{s:13:"administrator";b:1;}', meta_value='10' 
where meta_key='wp_capabilities' 
and meta_key='wp_user_level' 
and user_id='[ID from cal_user]';

remember to change the userID

answered Sep 10 '15 at 21:58

Nicolas Martinez

15
11

is that the exact code for the query i will use? i just want the exact code to copy and paste so i can hit go. – Sep 10 '15 at 22:04
without the user id it´s hard, you need the user id – Nicolas Martinez Sep 10 '15 at 22:06
honestly, i've been assigned this project as a learning tool. So, if i seem clueless, i kind of am. so how do i find the user id? – Sep 10 '15 at 22:07
do "select * from cal_user" the first col is call ID – Nicolas Martinez Sep 10 '15 at 22:10
the user id is just a number. so i can choose any user i want, and give them administrator privilges? – Sep 10 '15 at 22:12
yup. with that number in the script you must gave him administrator privilges – Nicolas Martinez Sep 10 '15 at 22:14
can you make the code for me so i can just copy and paste it? i'm sorry, i'm just new to this. – Sep 10 '15 at 22:57
sure I can, but i need the user ID – Nicolas Martinez Sep 10 '15 at 23:05
the username is MattDickinson the id is 2 – Sep 11 '15 at 11:41
update 'cal_usermeta' set meta_value='a:1:{s:13:"administrator";b:1;}', meta_value='10' where meta_key='wp_capabilities' and meta_key='wp_user_level' and user_id='2'; – Nicolas Martinez Sep 11 '15 at 17:43
is the code you told me to copy and paste the only thing i need to do? and by the way i appreciate all your help – Sep 12 '15 at 02:31

Nicolas Martinez · Answer 2 · 2015-09-14T19:38:27.623

-1

copy and paste this

update cal_usermeta set meta_value='a:1:{s:13:"administrator";b:1;}', meta_value='10' where meta_key='wp_capabilities' and meta_key='wp_user_level' and user_id='2';

edited Sep 14 '15 at 19:38

answered Sep 11 '15 at 17:44

Nicolas Martinez

15
11

wait, i've a cuestion. do you need this for a wordpress site or only to manage phpmyadmin? bc this code works for wordpress – Nicolas Martinez Sep 14 '15 at 19:57
ill send you the link i need to get into. its a website, not phpmyadmin – Sep 14 '15 at 20:22
thats not a wordpress site, is someone makeit in node.js or angular.js i can't help you with that, unless you showme how is the database, but that is a security breach and you can lost your work in that way – Nicolas Martinez Sep 14 '15 at 20:49
so how do i add an adminstrative account to it though? – Sep 14 '15 at 21:25
IDK, in the admin panel it must been a user list and you can mod it there – Nicolas Martinez Sep 14 '15 at 21:29
by admin panel do you mean once i login inside the link i gave you – Sep 14 '15 at 21:41
the same link / place – Nicolas Martinez Sep 14 '15 at 22:13
Please learn to *edit your answer* instead of posting multiple variants on the same thread. One answer per question is the SO ideal. – APC Oct 19 '15 at 02:28

PHPMyAdmin - Create New Admin account for website

2 Answers2