How to create a WordPress Admin from Database

14,765 Comments / Uncategorized / By

Lets suppose you are about to work in an existing WordPress website, and the client only gives you the cPanel details. How would you get into the WordPress backend? You could obviously ask your client to create an admin user for you. But wouldn’t it be cool if you could just create an admin access right from the database?

You might need to create logins directly from the database for many reasons. Your website might be recently hacked and the hacker deleted you from the administrator list. Whatever be the reason, it is always quicker to create user through database rather than the dashboard itself.

Okay enough talking, lets start the tutorial.

1. Login to your cPanel and locate phpmyadmin. Locate your database and go to wp_users table.

Wordpress-Developer-NewCastle-Blog-How-to-Create -Admin-User-From-Database-image-1

2. Open wp_users table and Click Insert at the top

3. Enter username, password (MD5) and email address and click on go!

Please not that you don’t need to enter any values in ID as it is auto assigned. Also select MD5 option on user_pass field before entering your password, this lets you save password as a text which is encrypted later on.

4. Find the user you just created in the wp_users table and note the user ID, you will need it.

Here in this example user ID is 2.

5. Go to wp_usermeta table and click insert

6. Enter the following information to assign administration capabilities.

user_id: Enter the user ID you previously remembered.
meta_key: wp_capabilities
meta_value: a:1:{s:13:”administrator”;b:1;}

Note: replace wp_ with your table prefix if you need to. See how your tables are named. If its named abc_users, then use abc_capabilities. I hope you get it! Once you enter all the data, click on GO.

7. On the same wp_usermeta table, click insert again, and enter the following values:

user_id: Same user ID
meta_key: wp_user_level
meta_value: 10

Click on “Go”. And boom, you have now created admin user right from the database. Isn’t that cool. Please comment down if you need any help.

14,765 thoughts on “How to create a WordPress Admin from Database”

    2. IDnspLU

      What is Tamoxifen and how does it work purchase cialis online cheap Although various animal models have been employed to identify molecular mechanisms involved in gastric tumorigenesis, there is a need for mouse models that allow for the consecutive induction of mutations to mimic advanced human disease

      Reply
  4. website

    Does your website have a contact page? I’m having problems locating it
    but, I’d like to shoot you an e-mail. I’ve got some creative ideas for
    your blog you might be interested in hearing. Either way, great site and I look forward to seeing it develop over time.

    Reply
    2. opAaZzf

      Based upon my high FSH levels and age I was close to 40, four REs in a row told me I shouldn t expect to ever have my own child and, while some were willing to try IVF at least once, they made it clear that they thought it would be a waste of time best viagra alternative Good news is that mum has surpassed the 3 5years life expectancy, it s different for all cases

      Reply
  5. website

    That is a very good tip especially to those fresh to the blogosphere.
    Short but very precise info… Many thanks for sharing this one.
    A must read article!

    Reply
  6. website

    My brother recommended I would possibly like this blog.
    He was once totally right. This post truly made
    my day. You can not consider simply how much time I had spent for this information! Thank you!

    Reply
    2. PYJykB

      In a clinical trial of patients with type 2 diabetes and prior failure on glyburide, patients started on metformin hydrochloride tablets 500 mg and glyburide 20 mg were titrated to 1000 20 mg, 1500 20 mg, 2000 20 mg or 2500 20 mg of metformin hydrochloride tablets and glyburide, respectively, to reach the goal of glycemic control as measured by FPG, HbA 1c and plasma glucose response see CLINICAL PHARMACOLOGY Clinical Studies how should i take viagra for best results

      Reply
  7. kpktoto

    Remarkable things here. I’m very glad to peer your article.
    Thanks a lot and I’m having a look ahead to contact you. Will
    you please drop me a mail?

    Reply
    2. AIGnQLpXu

      The guidelines also say that estrogen and progesterone supplements, while often justified for menopause symptoms, should not be taken to prevent heart disease cialis Tamoxifen clearly reduced the estrogen induced increase of apolipoprotein AI, HDL2 cholesterol and total HDL cholesterol

      Reply
  10. slot xo

    คนใดที่ต้องการมาเล่นSLOTXOเกมส์สล็อตออนไลน์ทำเงินเลยที่นี้ เรามีแจกโบนัสเยอะ ที่ xoslotvip.com สามารถเล่นทั้งวัน ทุกท่านจะไม่มีคำว่าเบื่อเหงาะอีกต่อไป คนใดที่มีดวงหรือของดีมาเช็คกันหน่อย ทางเรามีบริการดีๆมากมายไม่ว่าจะเป็นฝาก-ถอน AUTOรวดเร็วทันใจภายใน5 วินาที หรือ ทดลองเล่นสล็อตฟรี ที่ไม่ต้องฝากเงินเข้ามา
    ทางเว็บเกมสล็อตมีเงินรางวัลคอยให้ทุกท่านมารับไปอยู่ และเรานั้นยังมีเกมยิงปลาที่สามารถหาเงินได้เร็วใช้เวลาไม่นาน เล่นกับสหายก็ได้ เล่นผู้เดียวก็ดี มีให้เล่นกันแล้วบนโทรศัพท์เคลื่อนที่
    ไม่ต้องเดินทางไกล โหลดแอพลิเคชั่นมาไว้ เล่นได้ตลอดวัน อีกทั่งยังมีแอดมินคอยบริการตลอด 24 ชั่วโมง สมัครเลยวันนี้ รับโปรโมชั่นสล็อตออนไลน์ได้ทุกวัน เว็บไซต์สล็อตที่ยอดเยี่ยมในไทย
    ไม่มีประวัติการฉ้อฉลสามารถไว้ใจได้ 100% มีเกมจากทางค่ายXO สล็อตให้เล่นมากกว่า300เกมส์ โดยตัวเกมได้ดีไซต์มาได้อย่างยอดเยี่ยมมีสีสันเล่นไม่น่าเบื่อ
    เล่นได้ผ่านคอมพิวเตอร์หรือไอแพดได้ทุกรุ่นทุกยี่ห้อ ไม่ว่าจะเป็นAndroid รองรับทุกระบบปฎิบัติการ สล็อตออนไลน์ เว็บเดียว ที่ได้เอาเกมสล็อตมากไม่น้อยเลยทีเดียว จากทุกค่ายมาให้เพื่อนๆทุกคนได้ทดสอบเล่น สามารถเข้ารับเครดิตฟรีได้เลยสมัครสมาชิกเกมสล็อตกับทางเราเว็บใหญ่สล็อต และก็สำหรับคนใดที่เล่นมิได้เงินหรือเสียตังค์พวกเราก็มีการแจกวิธีการเลือกเว็บสล็อตที่ทางเราได้ไปสอบถามจากนักพนันที่เล่นเป็นอาชีพ รับรองสามารถทำรางวัลแจ๊คพอตได้แน่นอน slot xo

    Reply
    1. LkNbyyFZ

      After about 1 year I started noticing that my joints in my fingers were starting to swell to the extreme that I couldn t make a fist nor type which was why I hadn t posted much dosis levitra Since I forgot to take the prometruim could I be miscarrying

      Reply
  13. สล็อตโจ๊กเกอร์

    สล็อตโจ๊กเกอร์ เราคือ เว็บไซต์พนัน ที่เปิดให้บริการ สล็อตโจ๊กเกอร์ มากกว่า 500 เกม 500 รูปแบบ
    เว็บสล็อตออนไลน์ JOKER ของเรา มีผู้เล่น มากกว่า
    1 แสนคน สามารถร่วมสนุกและทำกำไรจาก สล็อตJOKER
    ได้อย่างไร้กังวล สล็อตโจ๊กเกอร์ มาพร้อมโหมด ทดลองเล่นสล็อต JOKER เครดิตฟรีสล็อต 10,000 บาท มีสูตรเกมสล็อต JOKER ฟรี และโปรโมชั่นอีกเพียบ เปิดให้บริการ ทางเข้า JOKER GAMING ตลอด 24 ชม.

    สามารถร่วมสนุกกับ JOKER สล็อต
    ได้อย่างไร้ขีดจำกัด สมัครสมาชิกใหม่ JOKERSLOT ตอนนี้ ฝาก 10 รับ 100 ล่าสุด และโปรโมชั่นอีกมากมาย ได้ที่ เว็บพนันสล็อต JOKER ตลอด 24 ชม.

    Reply
  14. cfa level 1 notes stores

    Hey there! This post couldn’t be written any better!
    Reading this post reminds me of my old room mate! He always kept
    chatting about this. I will forward this write-up to
    him. Fairly certain he will have a good read.
    Many thanks for sharing!

    Reply
    2. ielCkcJV

      In other words, threshold elevations in metabolic presbyacusis are the result of an energy starved cochlear amplifier magasin levitra Early exposure also appears cardioprotective, whereas later exposure may actually increase your risk for cardiovascular disease

      Reply
  15. PG SLOT เว็บตรง

    ค่ายตรง pgมาแรงจนกระทั่งผลักไม่อยู่ เล่นง่าย
    จ่ายทุกบิล ทำเทิร์นน้อยสำหรับโบนัส
    แล้วก็ โปรโมชั่นที่ท่านเลือก ได้รับการผลักดันจากเว็บ pgslotgame.vip ที่เปิดให้บริการสล็อต พีจีมานานกว่า 3 ปี เหมาะกับผู้เล่นทุกระดับ ไม่ว่าจะเป็นผู้เล่น
    ทุนน้อย ทุนหนัก ก็สามารถเล่นได้
    มีบุคลากรรอดูแลท่าน ตลอด 24 ชั่วโมง พร้อมระบบฝากถอนออโต้ใช้งานง่ายไม่ต้องโหลดappicationสามารถเข้าเล่นผ่านหน้าเว็บไซต์ได้ทันที มีผู้เล่นมากมายก่ายกองจากทั่วทุกประเทศในโลก สมัครเป็นสมาชิกกับพวกเราวันนี้ รับโบนัสฟรี 50% นอกนั้นยังมีการแจกสูตรเล่นสล็อตฟรีๆทุกวัน รวมเกมส์สล็อต พีจีตื่นเต้นตื่นเต้นไม่ว่าจะเป็นเกมส์เกมสล็อตแตกง่ายได้เงินจริงหรือกีฬาบอลจากลีกชั้นหนึ่งทั่วโลก แล้วก็รวมทั้งฟุตบอลรายการต่างๆเยอะแยะ ที่เปิดให้ท่านมาเพลินมากยิ่งกว่าทุกหนทุกแห่ง เปิดประสบการณ์ที่สนุกที่สุด ได้กำไรมากที่สุด
    เพราะเราเป็นเว็บสล็อตไม่ผ่านเอเย่นต์ที่ดีที่สุดในไทย การันตีเรื่องของการจ่ายเงินแน่ๆ เพราะเหตุว่าเว็บของเรานั้นมีความยั่งยืนมั่นคงรวมทั้งปลอดภัย100% PG SLOT เว็บตรง

    Reply
    1. becejelty

      More recently, the effect of the anti receptor activator of nuclear factor kappa B ligand denosumab on breast cancer survival was investigated, showing contrasting results 31, 32 mom relieves viagra accident Our bodies are made mostly of water, but that doesn t mean we have an endless supply

      Reply
    1. becejelty

      The one exception is the canine distemper vaccine, which does actually help prevent a dog from being infected cialis 20 mg The best validated scores predict severe AKI requiring dialysis and include the Cleveland Clinic Score and the Mehta Score 34, 35

      Reply
  24. cfa curriculum changes site internet

    It’s perfect time to make a few plans for the future and it is time to be happy.
    I have learn this publish and if I may I wish to
    recommend you some attention-grabbing issues or advice.
    Perhaps you can write next articles referring to this
    article. I want to read even more things approximately it!

    Reply
    1. RwnEqBjuG

      When lymph vessels are damaged, excess fluid remains in tissues after blood is pumped to those areas, and has difficulty being removed from the body can i buy cialis online Often, clinicians are called upon to manage drug eruptions in this setting while affected individuals are kept on the triggering therapy because of life saving or life sustaining benefits

      Reply
    1. becejelty

      cialis pills Pregnant ewes OVX on day 83 of pregnancy and placental slices cultured in vitro secretes 2 3 fold more estradiol 17beta, PSPB, PGE, and progesterone than placental slices from 90 day intact pregnant ewes, but placental PGF 2alpha secretion by placental slices from intact or OVX ewes did not change Denamur R, Kann G, Short R V

      Reply
  30. SamUnota

    [url=http://celebrex.company/]celebrex 200 mg for sale[/url] [url=http://erectafiltab.online/]erectafil 20[/url] [url=http://modafinila.online/]provigil online pharmacy[/url] [url=http://canadianpharmacy.company/]online pharmacy europe[/url]

    Reply
    3. CagyWD

      If an enhancement is needed following IOL implantation, we would not perform a topography guided enhancement if a toric IOL was used or if the IOL was placed in the sulcus, as this would introduce lenticular astigmatism that cannot be measured by the topography guided platform generic viagra what does it look like 2010 Sep; 195 3 792 8

      Reply
    3. NPtWxyx

      generic 5 mg cialis It is not yet known how the observed chromosomal changes produce both increased hematopoietic stem cell proliferation and increased apoptosis that results in the paradoxical combination of normal or increased bone marrow cellularity and pancytopenia seen in patients with tMDS

      Reply
    1. xfOAyIUv

      It s always recommended to discuss this in depth with your specialist plastic surgeon cialis 10mg In humans, the first phase occurs prenatally and is primarily dictated by genetic factors 14, while the second phase takes place postnatally and relies on a complex interplay between environmental and genetic factors 17

      Reply
    1. ariniaRit

      C F Quantification of myelination level, measured as percentage of area occupied by the staining, measured in the corpus callosum C, D, external capsule E and cortex F of mCSF or saline treated animal fed with cuprizone or normal diet buy cialis online no prescription Adjuvant ifosfamide and cisplatin in patients with completely resected stage I or II carcinosarcomas mixed mesodermal tumors of the uterus A Gynecologic Oncology Group Study

      Reply
    1. seasmal

      Both of these changes were blocked by immediate posttraining administration of the protein synthesis inhibitor anisomycin, which also blocked the contextual fear memory amazon priligy Reduced hepatic content of dehydroepiandrosterone sulphotransferase in chronic liver diseases

      Reply
    1. pAQZftDv

      However, NCOA4 deletion did not prevent the decreased PHD enzyme activity following FPN overexpression Supplemental Figure 6F where to buy cialis online safely For detection, membranes were incubated with either a HRP conjugated donkey anti sheep antibody 1 5000, R and D Systems Cat HAF016, RRID AB_562591, and imaged with a UVP ChemiDoc It imaging system with a BioChemi HR camera; or with a donkey anti goat IRDye 800CW 1 10000, LI COR Biosciences Cat 925 32214, RRID AB_2687553, a donkey anti mouse IRDye 800CW 1 10000, LI COR Biosciences Cat 926 32212, RRID AB_621847, or a donkey anti rabbit IRDye 680RD 1 10000, LI COR Biosciences Cat 926 68073, RRID AB_10954442 and imaged using the Odyssey CLx Infrared Imaging System LI COR

      Reply
    1. eSamZNgl

      Together, these data show that Np65 and Np55 are both present in wild type cochlear tissue, although they exhibit differential patterns of cellular expression can viagra make you last longer Missense mutations of these cysteines and small deletions in this region cause severe forms of human muscular dystrophy 49, 50

      Reply
    1. seasmal

      depression Your story sounds just like mine, only I take Femara, not Arimidex which is pretty much the same thing is generic cialis available Some OTC sleep aids combine antihistamines with acetaminophen Tylenol PM and Aspirin Free Anacin PM, while others combine antihistamines with alcohol Nyquil

      Reply
    3. xdbiTB

      Reduced fibronectin levels and reduced ECM turnover appear to be hallmarks of the quiescent mammary microenvironment buy cialis 5mg online Tamoxifen is classified as a SERM selective estrogen receptor modulator, meaning that it can either block or activate the action of estrogen, depending upon the location of the estrogen receptors in the body

      Reply
    2. naIlYw

      Chaparro CM, et al chad johnson viagra We would like to thank Professor Iris Benzie, Chair Professor of Biomedical Science at the Hong Kong Polytechnic University for her contribution to the ideas discussed in this manuscript and Professor Brian Tomlinson, Department of Medicine Therapeutics at The Chinese University of Hong Kong for the provision of the drugs used to test antioxidant properties

      Reply
    1. lFEtytRzZ

      Because spironolactone acts as a diuretic, it is also important to drink plenty of water cialis online cheap Hepatotoxicity The severity of the ofloxacin induced liver injury ranges from mild and transient serum enzyme elevations to self limited jaundice to acute liver failure

      Reply
    1. OCVZQTZlX

      It ll usually disappear on its own in a year or so cialis 10mg Among the artifacts that exist, as long can metoprolol er be cut in half as it involves the use of space, there will be more or less star gold

      Reply
    2. MEYVtG

      071 PRINCIPEN VON HALLER Susp chewable viagra In stark contrast however, was treatment of the cells with either paclitaxel or vinblastine in the presence of P gp inhibitor 29 for two hours, followed by an extended P gp inhibitor exposure for 22 hours after washing the cells free from non internalized chemotherapeutic

      Reply
    1. DomSweemo

      The mechanistic target of rapamycin complex 1 mTORC1 serves as an intracellular energy sensor and a master regulator of a variety of fundamental cellular processes including transcription, translation, protein and lipid synthesis, autophagy, cell growth, and metabolism 1 cialis buy online

      Reply
    2. kMRLxLxp

      To isolate the roles of MΦs and ECs in this model we removed MΦs from the islet microenvironment Figures 1, S1; experimental scheme A and inactivated VEGFR2 signaling in ECs to discern the effects of proliferative or quiescent ECs on β cell proliferation Figures 1, S1; experimental schemes B and C cialis 20mg

      Reply
    3. WNuVBN

      In this report, the mean steroid hormone receptor level did not differ markedly between PBC and CBC generic cialis online van Schaik RH, Kok M, Sweep FC, van Vliet M, van Fessem M, Meijer van Gelder ME, Seynaeve C, Lindemans J, Wesseling J, Van t Veer LJ, Span PN, van Laarhoven H, Sleijfer S, Foekens JA, Linn SC, Berns EM

      Reply
    1. kuKxrA

      But we had practised so much beforehand, and it was a major deal just to go and play somewhere best generic cialis C6 glioma cells do not express immunoreactive ER receptors data not shown, in accordance with earlier reports demonstrating that ER mRNA and ER immunoreactivity are undetectable in malignant gliomas 20

      Reply
    3. cHNtEAS

      8 Fisher B, Costantino JP, Redmond CK, Fisher ER, Wickerham DL, Cronin WM buy generic cialis Heredity a family history of astigmatism, eye disease, or disorders such as keratoconus certain types of eye surgery, such as cataract removal A history of corneal scarring or thinning A history of excessive nearsightedness or farsightedness

      Reply
    1. AAjBTA

      Using a whole cell assay and nuclear and cytosolic radio binding experiments with 3H estradiol as tracer, we found that MNT1, M10, and M14 melanoma cell lines as well as primary tumors expressed type II estrogen binding sites that bind tamoxifen and the flavonoid quercetin with similar affinity KD 10 25 nM buy viagra and cialis online Turns out it was Hyland s

      Reply
    1. AMdHdzaZ

      Nichols and Mikayla Carver levitra dana el higado Intracerebral hemorrhage, Multiple, Simultaneous, MESH Cerebral Amyloid Angiopathy therapy, MESH Cerebral Hemorrhage diagnosis, MESH Cerebral Hemorrhage etiology, MESH Cerebral Hemorrhage therapy, MESH Cognition physiology, MESH Humans, MESH Hypertension complications, MESH Hypertension therapy, MESH Radiography methods, MESH Treatment Outcome, SCCO

      Reply
    3. icgfFdV

      Zhao Ling stretched out his hands turmeric type 2 diabetes and smiled meanly generic propecia online 74, 75 Further, a strong sodium blood pressure association that is independent of age has been identified in postmenopausal women, suggesting that postmenopausal salt sensitivity is related to hormonal changes rather than aging

      Reply
    2. pDVRrIMv

      At low doses of alcohol drinking equal to or less than 1 drink a day the risk for oral and pharyngeal cancer was increased 20 and the risk of esophageal squamous cell cancer was increased 30 buy cialis usa Endoderm organ systems are gastrointestinal and respiratory tract lining

      Reply
    1. rvWZNJ

      The differential includes infections, ulcerations from trauma, vascular diseases, pyoderma gangrenosum, Stevens Johnson syndrome, erythema nodosum, or erythema multiforme tadalafil cialis from india Related to visual field deficits Related to difficulty swallowing Related to impaired balance Related to psychomotor seizures

      Reply
    1. DomSweemo

      All female and male mice were maintained under pathogen free conditions in the animal facility at New York University School of medicine and Weill Cornell Medicine and used between 6 and 10 weeks of age buy cialis pills You can fill covered prescriptions at participating CVS retail pharmacies, through mail order, or through YNHHS Outpatient Pharmacy Services

      Reply
    2. OAVRxCDto

      For instance, if an event takes place after only one or two months of the switch to an aromatase inhibitor, it would more likely to think that this event would be due to a failure to tamoxifen therapy rather than an aromatase inhibitor cialis generic 5mg Hillege HL, Girbes AR, de Kam PJ, Boomsma F, de Zeeuw D, Charlesworth A, Hampton JR, van Veldhuisen DJ

      Reply
    2. YXXPKqho

      online cialis pharmacy com 20 E2 AD 90 20Viagra 20Pirkti 20Vilnius 20 20Acheter 20Viagra 20Gnrique 20Livraison 20Rapide viagra pirkti vilnius Phil Hughes said he could live with the first two homers, one which came on a fastball that just Гў leaked back over the plate, Гў and the other a low liner that would not have been a homer in most ballparks

      Reply
    1. PCtTXT

      Metabolite levels were measured in post mortem tissue from seven regions three that undergo severe neuronal damage hippocampus, entorhinal cortex and middle temporal gyrus; three less severely affected cingulate gyrus, sensory cortex and motor cortex; and one cerebellum that is relatively spared viagra and cannabis

      Reply
    2. uixcXH

      Department of Community Health Sciences, University of Calgary, Calgary, Alberta, Canada cialis with priligy Repeated fluid removal is also associated with protein depletion and electrolyte disturbances, which are thought to contribute to muscle loss, which is itself an independent predictor of mortality in those with recurrent ascites 34

      Reply
    1. WtYogm

      The results suggest that stimulation leads to large changes in the activity of c Myb and its ability to associate with specific target gene promoters propecia results after 3 months Diuretics such as amiloride Midamar, spironolactone Aldactone or triamterene Dyrenium are called potassium sparing agents

      Reply
    3. EkDOAexsP

      to conclude that laparoscopic ovarian drilling is as effective as gonadotropins for ovulation induction, with the added benefit of decreasing need for other forms of artificial reproductive technology and increasing likelihood of chance for another child Nahuis et al tadalafil cialis from india

      Reply
    1. seasmal

      Bang bang how long does chemo drugs raise blood sugar bang Every time the fire rhino takes a step, the ground will crack, and it is like a huge stove, the whole body is covered with flames, and it is difficult nutrition for diabetics type 2 to be hit by him without dying better business bureau online pharmacy priligy Effect of adjuvant chemotherapy followed by tamoxifen on serum lipids from 6 to 12 months

      Reply
    1. gzPpQKA

      We have handled a wide variety of claims involving pharmaceutical litigation, birth defects, as well as claims involving other injuries caused by Tylenol how does propecia work In the absence of hormone, a basalОІ galactosidase activity was detected, which corresponds to the amount found in yeast cells transformed with the control p2HG expression plasmid that does not carry hER sequences

      Reply
    2. DAEdVwf

      com 20 E2 AD 90 20Prospect 20Viagra 20Comprimate 20 20Harga 20Viagra 20Asli 20Di 20Apotik 20Kimia 20Farma prospect viagra comprimate Mexico s economy has stumbled this year amid slack U side effects of viagra We re very flexible in what people submit for the final project

      Reply