WPBeginner - WordPress Tutorials for Beginners

Trusted WordPress tutorials, when you need them most.
Beginner’s Guide to WordPress
WPB Cup
25 Million+
Websites using our plugins
16+
Years of WordPress experience
3000+
WordPress tutorials
by experts

MySQL ile WordPress Veritabanına Yönetici Kullanıcı Ekleme

By Editorial Staff | | Reader Disclosure

ChatGPT Perplexity X LinkedIn WhatsApp

Hiç evinizin anahtarını unutup dışarıda kaldığınızı hissettiniz mi? WordPress web sitenizde kilitli kalmak buna çok benzeyebilir. Özellikle de bilgisayar korsanları yönetici hesabınızı silmişse çok sinir bozucudur. Ama endişelenmeyin, tekrar girebilirsiniz.

Web sitenizi gizli bir arka kapısı olan bir ev gibi düşünün. Bu arka kapı web sitenizin veritabanıdır ve genellikle MySQL kodu kullanılarak erişilir. Şimdi, bu karmaşık gelebilir, ancak web sitenizde perde arkasında değişiklikler yapmak için kullanabileceğiniz bir dizi talimat gibidir.

Bu makalede, tıpkı eviniz için yeni bir anahtar yaptırmak gibi, web siteniz için yepyeni bir yönetici hesabı oluşturmak üzere MySQL’i nasıl kullanacağınızı öğreteceğiz. Bu şekilde, bilgisayar korsanlarını dışarıda bırakabilir ve kontrolü geri alabilirsiniz.

How to Add an Admin User to the WordPress Database via MySQL

Neden MySQL aracılığıyla WordPress Veritabanına Yönetici Kullanıcı Ekleyelim?

Bir keresinde bir kullanıcının sitesinin saldırıya uğradığı ve yönetici hesabının veritabanından silindiği bir sorunla karşılaştık. Bu da onları WordPress web sitelerinin dışında bıraktı.

Doğrudan WordPress web sitesine yeni bir yönetici kullanıcı oluşturarak web sitelerine erişmelerine yardımcı olabildik. Bunu, web tarayıcınızı kullanarak MySQL veritabanlarını yönetmenizi sağlayan web tabanlı bir araç olan phpMyAdmin’i kullanarak yaptık.

Bilgisayar korsanları nedeniyle veya sadece şifrenizi unuttuğunuz için WordPress yönetici alanınızın dışında kaldıysanız, aynı şeyi siz de yapabilirsiniz.

Ancak, herhangi bir MySQL düzenlemesi yapmadan önce her zaman veritabanınızın yedeğini almalısınız. Ardından, web sitenize tekrar giriş yapabildiğinizde, saldırıya uğramış WordPress sitenizi düzeltmek için yeni başlayanlar kılavuzumuzu izlemeniz gerekebilir.

Bununla birlikte, MySQL aracılığıyla WordPress veritabanına nasıl yönetici kullanıcı ekleneceğine bir göz atalım.

phpMyAdmin ile WordPress Veritabanına Yönetici Kullanıcı Ekleme

phpMyAdmin, en iyi WordPress barındırma şirketlerinin çoğunda önceden yüklenmiş olarak gelir. Hosting hesabınızın cPanel panosunun Veritabanları bölümünde bulabilirsiniz.

İşte Bluehost kontrol panelinden bir ekran görüntüsü:

Selecting phpMyAdmin on cPanel

Simgeye tıkladığınızda phpMyAdmin arayüzü açılacaktır. Sol sütundan WordPress veritabanınızı seçmeniz gerekir.

Bundan sonra, phpMyAdmin WordPress veritabanınızdaki tüm tabloları görüntüleyecektir. wp_users ve wp_usermeta tablolarında değişiklikler yapacaksınız.

You Will Be Making Changes to the wp_users and wp_usermeta Tables

wp_users Tablosuna Kullanıcı Ekleme

İlk olarak, wp_users tablosunu bulmanız ve tıklamanız gerekir. Bu, şu anda tabloda listelenen kullanıcıları gösterecektir.

Aşağıdaki ekran görüntüsünde demo web sitemizin tablosunda iki kullanıcı kimliği olduğuna dikkat edin, 1 ve 2. Demo sitemiz için yeni bir kullanıcı oluşturduğumuzda, bu kimliğin benzersiz olması gerekir, bu nedenle 3 sayısını yazacağız.

Yeni bir yönetici kullanıcı için bilgileri ekleyebilmek için ekranın üst kısmındaki ‘Ekle’ sekmesine tıklamanız gerekir.

Click the Insert Tab

Ekle formundaki alanlara aşağıdaki bilgileri ekleyin:

  • ID: benzersiz bir sayı seçin (örneğimizde 3 kullanacağız)
  • user_login: oturum açarken kullanılacak kullanıcı adı
  • user_pass: bir parola ekleyin ve işlev menüsünde MD5’i seçtiğinizden emin olun (aşağıdaki ekran görüntüsüne bakın)
  • user_nicename: kullanıcının tam adı veya takma adı
  • user_email: kullanıcının e-posta adresi
  • user_url: web sitenizin adresi
  • user_registered: kullanıcının takvimi kullanarak kaydedildiği tarih ve saati seçin
  • user_activation_key: boş bırakın
  • user_status: bunu 0 olarak ayarlayın
  • display_name: kullanıcının tam adı veya görünen adı
Fill In the Fields for the New User

İşiniz bittiğinde, yeni kullanıcıyı kaydetmek için ‘Git’ düğmesine tıkladığınızdan emin olun.

wp_usermeta Tablosuna Kullanıcı Ekleme

Şimdi, wp_usermeta tablosunu bulmanız ve tıklamanız gerekir. Bundan sonra, önceki adımda yaptığınız gibi ‘Ekle’ sekmesine tıklamalısınız.

Ardından, aşağıdaki bilgileri Insert formuna eklemeniz gerekir:

  • unmeta_id: bunu boş bırakın (otomatik olarak oluşturulacaktır)
  • user_id: önceki adımda kullandığınız kullanıcı kimliği
  • meta_key: bu wp_capabilities olmalıdır
  • meta_value: insert this: a:1:{s:13: "administrator";s:1: "1";}
Fill In the Fields for the New User

Bundan sonra, aşağı kaydırdığınızda, ikinci bir satır için alanlar bulmalısınız. Aşağıdaki bilgileri eklemeniz gerekir:

  • unmeta_id: bunu boş bırakın (otomatik olarak oluşturulacaktır)
  • user_id: önceki adımlarda kullandığınız kullanıcı kimliği
  • meta_key: wp_user_level girmeniz gerekir
  • meta_value: 10
Fill In the Fields for the New User

Bilgileri alanlara girmeyi bitirdiğinizde, ‘Git’ düğmesine tıklamanız gerekir. Tebrikler, yeni bir yönetici kullanıcı adı oluşturdunuz!

Şimdi, bu kullanıcı için belirlediğiniz kullanıcı adı ve şifreyi kullanarak WordPress yönetici alanınıza giriş yapabilmeniz gerekir.

Oturum açar açmaz, Kullanıcılar ” Tüm Kullanıcılar’a gitmeniz ve ardından yeni oluşturduğunuz kullanıcı adına tıklamanız gerekir.

Navigate to Users » All Users and Edit the New User

Şimdi, hiçbir şeyi değiştirmeden sayfanın en altına gidin ve ‘Kaydet’ düğmesine tıklayın.

Bu, WordPress’in yeni oluşturduğunuz kullanıcıyı temizlemesini ve gereken bazı ekstra bilgileri eklemesini sağlayacaktır.

SQL Sorgusu Kullanarak WordPress Veritabanına Yönetici Kullanıcı Ekleme

Eğer bir geliştiriciyseniz, kod kullanarak süreci hızlandırabilirsiniz.

Bu SQL sorgusunu veritabanınıza bırakmanız yeterlidir:

INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('3', 'demo', MD5('demo'), 'Your Name', 'test@example.com', 'http://www.example.com/', '2022-09-01 00:00:00', '', '0', 'Your Name');
 
 
INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '3', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
 
 
INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '3', 'wp_user_level', '10');
Hosted with ❤️ by WPCode
1-click Use in WordPress

‘databasename’i çalıştığınız veritabanı olarak değiştirdiğinizden emin olun.

Ayrıca, ilk yöntemde açıkladığımız gibi, diğer değerleri yeni kullanıcı için istediğiniz değerlerle değiştirmeyi unutmayın.

Drop This SQL Query Into Your Database

WordPress Yöneticisi Kilitlendiğinde Yapılması Gerekenler Hakkında Uzman Kılavuzları

Artık MySQL aracılığıyla nasıl yönetici kullanıcı ekleyeceğinizi bildiğinize göre, WordPress yönetici alanından kilitlendiğinizde web sitenizi nasıl düzelteceğinizle ilgili bazı makaleleri görmek isteyebilirsiniz.

Umarız bu eğitim, MySQL aracılığıyla WordPress veritabanına nasıl yönetici kullanıcı ekleyeceğinizi öğrenmenize yardımcı olmuştur. Ayrıca nihai WordPress güvenlik kılavuzumuzu veya yaygın WordPress hataları ve bunların nasıl düzeltileceği listemizi de görmek isteyebilirsiniz.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

Popular on WPBeginner Right Now!

Disclosure: Our content is reader-supported. This means if you click on some of our links, then we may earn a commission. See how WPBeginner is funded, why it matters, and how you can support us. Here's our editorial process.

The Ultimate WordPress Toolkit

Get FREE access to our toolkit - a collection of WordPress related products and resources that every professional should have!

Download Now

Reader Interactions

240 yorumLeave a Reply

  1. I wanted to delete all spam emails registered in my site. I went to myPhpAdmin and deleted all including mine (without knowing). I searched the web ’til I landed at this page.

    Good Job! It worked!

    Yanıtla

  2. Not sure where I went wrong but I get this when trying to login: You do not have sufficient permissions to access this page.

    Yanıtla

    • Hello Donato,

      Change the “wp_” prefix of “wp_capabilities” and “wp_user_level” to whatever prefix you have set. Example, if you changed your wordpress prefix as “mysite_” then the insert command should be:

      INSERT INTO `databasename`.`mysite_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, ‘4’, ‘mysite_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);

      INSERT INTO `databasename`.`mysite_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, ‘4’, ‘mysite_user_level’, ’10’);

      Yanıtla

  6. Thank you for this… very easy to follow! I never would have intuitively thought I would have to add two record in the same table. Thank you again.

    WordPress add admin record… I never thought I would have gotten this done in 5 minutes.

    Yanıtla

  7. Thank you! I love when things work! I went through the instructions as stated above and everything worked out. Just a tip – if you changed the prefix of your database tables from wp_ to something else, make sure to replace it in the code above.

    Yanıtla

  8. Thanks, Dasha! You’re a life saver! Was stumped until I saw I needed to also change the DB prefix for ‘wp_capabilities’ and ‘wp_user_level’!

    Yanıtla

  10. Hi, thanks for the clear tips. It nearly worked – but had to change a:1:{s:13:”administrator”;s:1:”1″;} with a:1:{s:13:”administrator”;s:1:”1″;} – looks the same, just replace all the quotes (which are curly quotes) with normal quotes. Or don’t be lazy andwrite it instead of cut and paste. Otherwise the new user I created didn’t have admin access. Phew that was difficult,

    Yanıtla

  11. omg.. what a life saver. Just a tip you need to update the wp_capabilities meta_key value to ‘a:1:{s:13:”administrator”;b:1;}’. And for some reason it still didn’t allow me to login. So then I just typed in the new username I created and clicked on forgot password. WP sent me a password reset link and all was well.

    Yanıtla

  12. I was able to gain access with the original process but now my dashboard is blank. Any ideas on what I need to do? thanks

    Yanıtla

  13. As of today you also have to add another entry (and probably not the wp_user_level, not sure about that though), wp_capabilities with a value of a:1:{s:13:”administrator”;b:1;}

    Yanıtla

  14. You’ve got a small bug. you’ll need to update the wp_capabilities meta_key value to ‘a:1:{s:13:”administrator”;b:1;}’ for this to work correctly, otherwise great article

    Yanıtla

  15. Thank you for the tutorial – very useful. However, it would be handy if there was a note that ‘wp_capabilities’ and ‘wp_user_level’ use default database prefix, i.e. ‘wp_’. If a site uses a custom DB prefix that it should be used in those strings instead.

    Yanıtla

  16. After finding your sollution i tweaked it a bit you can actually do everything in 2 queries without having to remember the id you create.

    Both queries have to be executed in the same action (so the same SQL input box).

    INSERT INTO `wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`)
    VALUES
    (NULL , ‘username’, MD5(‘password’), ‘User Name’, ’email@domain.ext’, ”, NOW(), ”, ‘0’, ‘User Name’);

    INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
    VALUES
    (NULL, LAST_INSERT_ID(), ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’),
    (NULL, LAST_INSERT_ID(), ‘wp_user_level’, ’10’);

    Yanıtla

  17. I followed the instructions but keep getting an “invalid username” error when trying to login.
    I’ve created 3 different users but still continue getting this error.

    Yanıtla

  18. So glad I found this. Worked like a dream once I got the correct brackets and the right code for the version of WP that was installed

    Yanıtla

  23. not working , i don’t no what mistake i have made…

    it’s showing this error

    “”” You do not have sufficient permissions to access this page. “”

    Yanıtla

    • It seems like the latest version of WordPress has tweaked their meta keys and values to:

      dqf_capabilities -> a:1:{s:13:”administrator”;b:1;}
      dqf_user_level -> 10

      I saw the insufficient permissions prompt before noticing this, then changing the keys and values fixed it!

      Yanıtla

  24. Was ok one day and then the next – lost my admin access. Thanks for this – saved me a heap of frustration. Plus I’ve learnt some sql to boot!

    Cheers!

    Yanıtla

  26. Hello,

    I had a blog hosted at web host A and moved to another webhost recently. I don’t have the account with web host A any longer but have the full backup of the WP blog on my computer. I restored the backup to this new webhost B and the database as well. The blog is accessible fine. But I’m not able to login to wp-admin using any of the three admin user logins I have in the database. I checked the database from phymyadmin and all the three users are there fine.

    I also tried to change passwords of these users. I get the link to change the password, but when I try to login to wp-admin using the new password, even then I get the same WP login screen without any error shown.

    I also tried the method you gave above, to create a new user. I did as per all the steps and also tried what the commenters have suggested, but still I’m not able to login.

    I tried deleting all the tables for this blog and then again imported the database. Doing this and trying to logging in just gives a message that the database needs to be updated before I can login. So, clicking the yes, I again get the login screen and the above process repeats – getting the same WP login screen with no error.

    Note that I’m using the WP Better Security plugin and even tried deleting the plugin using FTP, but the same thing, still.

    Can you tell me what can be done in this situation and where am I going wrong? Please help.

    Thank you.

    Kind Regards,
    Raspal

    Yanıtla

    • Please check your wp-config.php file make sure that it has your new database name, username, and host information. Delete .htaccess file from the root of your site. Rename plugins directory in your /wp-content/ folder. This will deactivate all your plugins. Lastly, in phpmyadmin go to wp_options table and look for homeurl and siteurl options make sure they are pointing to your domain name. Report back if none of these steps resolve your issue.

      Yanıtla

      Admin

      • Thanks for the help. I re-checked everything you mentioned above and all those things were perfect. After 2 days of fiddling, it striked me that I hadn’t tried clearing Chrome’s cache and cookies, silly me! This simple thing solved the problems which wasted my two days’ time. Sorry to have wasted your and others’ time too who read this.

        Anyway, everyone make sure to clear your cookies and cache every few days, Cookies and cache are responsible for really wierd problems. I don’t know about others but I like to keep my cookies for ages because they contain passwords to many (not-so-important but regular) sites I visit. And I take it for granted that cookies aren’t the culprit. Turned out to be wrong! Now, I have sent myself a reminder which tells me to clear the cookies and cache from all my browsers.

        Thanks again for the help. At least the options you mentioned, I will surely remember if something like this happens again. And I also learnt how to use phpmyadmin to create and even edit WP users. :) And in the process, I saw a table called lockdowns. This is created by WP Better Security plugin and I now know that I can clear this table or change the values if I am locked out of the login screen for bad logins. Thanks Syed and editorial staff!

        Kind Regards,
        Raspal

        Yanıtla

  27. There is a very slight (but critical) typo in your tutorial:

    a:1:{s:13:”administrator”;s:1:”1″;} <—-this is not correct by a single character

    a:1:{s:13:"administrator";s:1:"1";} <—-this is correct, the final ″ should be a "

    The two characters look almost exactly the same, but they are slightly different.

    Yanıtla

  28. Nice, it works!
    Just chanced the a:1:{s:13:”administrator”;b:1;} for the equivalent already listed in wp-capabilities and worked fine to me.

    Yanıtla

  29. I’ve followed all these steps, but it doesn’t appear my new user I created has been given admin role. When I log in to WordPress with the username and password I just created all I am able to see is the “Profiles” tab of the dashboard. Obviously I am missing a step along the way, but I have created two new users following this and it’s happened both time. Does anyone know what I may be doing wrong?

    Yanıtla

  32. This don’t work tried loads of times and still cannot log in.

    (unmeta_id – leave this blank (it will be auto-generated)
    user_id – this will be the id of the user you created in the previous step. Remember we picked 4.
    meta_key – this should be wp_capabilities
    meta_value – insert this: a:1:{s:13:”administrator”;s:1:”1″;}

    Insert another row with the following information:

    unmeta_id – leave this blank (it will be auto-generated)
    user_id – this will be the id of the user you created in the previous step. Remember we picked 4.
    meta_key – this should be wp_user_level
    meta_value – 10 )
    this part is where i think i am going wrong , i can see user created but it does not log in

    Yanıtla

  33. a useful guide, to an issue i found of a hacker who deleted the admin alos. however upon inserting a new admin. i get the error message of INSERT command denied to user “database name” @hosting for table “wp_users”

    any ideas?

    Yanıtla

  35. Maybe a weird question, but I followed the steps and can’t login. Also watched for the brackets etc.

    So I tried ‘forgot password’ and entered my e-mail which is also in the wp_users table. But it says no user is registered with that e-mail.

    Anyone a clue what I missed?

    Yanıtla

    • OMG sorry. My fault. I didn’t changed the base URL in the database so my local copy (and login) were pointing at the original site. Feeling stupid.

      Yanıtla

  36. If you copied the code a:1:{s:13:”administrator”;b:1;} from this blog, it is possible that you got curly quotes instead of regular quotes, which will not work.

    Yanıtla

  37. There was a problem with the wp_capabilities valve you gave and the problem was with the quotes. the correct one is: wp_capabilities should be a:1:{s:13:”administrator”;s:1:”1″;}

    Anyone who wants to solve this problem should copy it exactly as it appears.

    Yanıtla

  38. I by accident logged in before adding the “usermeta” info. It of course read “You do not have sufficient permissions to access this page.” Even after I added the usermeta info I get the same thing.

    Any thoughts on this?

    Yanıtla

    • Check to see if the prefix is the same as your main database prefix. We are assuming that the user is using the default wp_ prefix. If your database prefix is something else, then it wouldn’t work.

      Yanıtla

      Admin

      • I’ve tried everything and I still keep getting “You do not have sufficient permissions to access this page.” Any ideas on why this might be happening? Thanks.

        Yanıtla

      • I was getting the same error message and I think the problem comes from the check box in the second row that says “ignore”. It was checked by default for me and I got it to work once I unchecked that box.

        Yanıtla

  39. Thank you so much this finally allowed me to get into my site. I tried every possible option to reset the admin password but nothing would work. I created the new account and logged in as administrator and was then able to export my work. Thanks again!

    Yanıtla

  40. Hi, great article, thanks! Have a different issue though, my entire wp_users table got deleted and I don’t know how to create a wp_users table using phpMyAdmin. Can anyone help? Thanks!

    Yanıtla

    • Did you try repairing your database using the WordPress repair tool? Maybe that adds it back. Otherwise, you are better off reinstalling WordPress. For future, keep good backups.

      Yanıtla

      Admin

      • using the repairing DB WordPress tool won’t create the wp_users table. What I did is deleting the unused tables from the old one, lowering it’s size and uploading it again. It worked. Thanks.

        Yanıtla

  41. After attempting to log in it sais..

    You do not have sufficient permissions to access this page

    why did this happen?

    Thanks

    Yanıtla

  44. I echo Ravi’s suggestion to copy the meta value from another admin. In my case “wp_capabilities” was actually databaseName-“_capabilities” and my admin level looked like this:  a:2:{s:13:”administrator”;s:1:”1″;s:17:”gform_full_access”;s:1:”1″;}
     
    Thanks for the great article. Saved my day.
     

    Yanıtla

    • Copying of the wp_capabiblities-value from another admin helped me to. In my case the value was a:1:{s:13:”administrator”;s:1:”1″;}. Until this change I had recieved: “You do not have sufficient permissions to access this page.”

      Yanıtla

  45. Thanks for the useful article.
     
    a:1:{s:13:”administrator”;b:1;} didn’t work for me. I had to copy the meta value from another admin user and then it worked.

    Yanıtla

  46. For those who encounter “You do not have sufficient permissions to access this page.”, replace “wp_capabilities” with your full wordpress table name, e.g. if your usermeta tables are called wp_yourtableusermeta (as opposed to wp_usermeta in this tutorial), then you need to use wp_yourtablecapabilities instead. Same goes for wp_user_level, change it to wp_yourtableuser_level. Hope this helps.

    Yanıtla

  48. In my opinion tampering with MySQL should not be on wp’beginner’, messing around with the database is simply not a beginner thing.

    I don’t know when this was posted, but the time when WordPress used MD5 has long gone. This article should be updated to use wp_hash_password instead.

    Yanıtla

  49. Hi guys, Anne here, community manager intern at Livefyre. Welcome! Just wanted to drop in and say that everyone here loves this blog; it’s full to the brim with fantastic information. Can’t wait to read more!

    Yanıtla

    • Hi,

      I hope to get some help here. My blog was hacked with some base64 stuff. I can solve 99% of all the problems but I have 2 Admins in my wp Backend that need to be removed from mysql table before I can take other actions

      Sorry, no clue how to track the adin in the table and remove them

      WP latest
      Access to the mysql database

      tks

      Kosta

      Yanıtla

Leave A Reply

Thanks for choosing to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and your email address will NOT be published. Please Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

Copyright © 2009 - 2025 WPBeginner LLC. All Rights Reserved. WPBeginner® is a registered trademark.

Managed by Awesome Motive | WordPress hosting by SiteGround

The WordPress® trademark is the intellectual property of the WordPress Foundation. Uses of the WordPress®, names in this website are for identification purposes only and do not imply an endorsement by WordPress Foundation. WPBeginner is not endorsed or owned by, or affiliated with, the WordPress Foundation.

I need help with…

Popular searches:

Starting a Blog WordPress SEO WordPress Performance WordPress Errors WordPress Security Building an Online Store