Skip to content
Read For Learn
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP

Shared user database trick not working

I believe this is due to WordPress already seeing an admin user in the global user table, so on install, it won’t show a spot for a username. I was actually just messing with this exact same setup, and came across the same issue.

  1. If these are two both brand new site setups, you could delete the data in your users and usermeta table, and start the process of installing your second WordPress site. It should then give you the option to fill in all of the values for an admin user. Once installed, the new user you created will be an admin of your SECOND site only.

  2. Once installed, you will need to add some records into your usermeta table for your FIRST site installed. You should see two records in your usermeta table with meta_keys of “{table_prefix_of_second_site}_capabilities” and {table_prefix_of_second_site}_user_level. You will need to make the same key value pair for your FIRST site with the key of {table_prefix_of_first_site}_capabilities and value of a:1:{s:13:”administrator”;b:1;}, then another row with a key of {table_prefix_of_second_site}_user_level with a value of 10.

You should then be able to login to both sites with the admin user.

Related Posts:

  1. 2 wordpress blogs with 1 users table and 1 login
  2. How to integrate external user tables with WP?
  3. WordPress and Magento: let WordPress manage user registration and logins?
  4. In Django, how do I know the currently logged-in user?
  5. Can I programmatically login a user without a password?
  6. Can’t log in: “ERROR: Cookies are blocked or not supported by your browser. You must enable cookies to use WordPress.”
  7. Is there any way to rename or hide wp-login.php?
  8. How to login with email only no username?
  9. How can I redirect user after entering wrong password?
  10. Increase of failed login attempts, brute force attacks? [closed]
  11. Login page ERROR: Cookies are blocked due to unexpected output
  12. Separate registration and login for different roles
  13. SSO / authentication integration with external ‘directory service’
  14. Preventing session timeout
  15. How reduce wordpress login session timeout time?
  16. How to prefill WordPress registration with social details
  17. Check for correct username on custom login form
  18. Disallow user from editing their own profile information
  19. I can’t access my site via wp-admin
  20. ‘Password field is empty’ error when using autofill in Chrome
  21. Removing username from the ‘wordpress_logged_in’ cookie
  22. How to show ‘login error’ and ‘lost password’ on my template page?
  23. What is $interim_login?
  24. Custom login form
  25. How to prefill the username/password fields on the login page
  26. wp_signon returns user, but the user is not logged in
  27. Adding extra authentication field in login page
  28. Prevent wp_login_form() from redirecting to wp-admin when there are errors
  29. Redirect user using the ‘wp_login_failed’ action hook if the error is ’empty_username’ or ’empty_password’
  30. wp_signon() does not authenticate user guidance needed
  31. What exactly is ReAuth?
  32. What are the differences between wp_users and wp_usermeta tables?
  33. Login members using web services
  34. Make my wordpress blog remember my login “forever”
  35. How to check in timber if user is loggedin?
  36. How do I change the language of only the login page?
  37. Disable WordPress 3.6 idle logout / login modal window / session expiration
  38. Stop WordPress from logging me out (need to keep me logged in)
  39. Woocommerce registration page [closed]
  40. How to disable autocomplete on the wp-login.php page
  41. Share login data/cookies between multiple installations
  42. Synchronize WordPress user accounts across multiple domains and installations without using WordPress MU
  43. How to pass users back and forth using session data?
  44. How do I change the logo on the login page?
  45. Why does WordPress hide the reset password key from the URL?
  46. Is it possible to sign in with user_email in WordPress?
  47. How to use current_user_can()?
  48. Avoid to load default WP styles in login screen
  49. WordPress registration message
  50. How to fake a WordPress login?
  51. how to display the wordpress login and register forms on a page?
  52. Does wp_logout_url() destroy a session? (Logging out question)
  53. How can I send a welcome email to a user AFTER they login for the first time?
  54. Can not login with correct username and password
  55. Website Visible only to Registered users
  56. How can i increase the login expiration length?
  57. How do I use add_action from a class method?
  58. How to remove the WordPress logo from login and register page?
  59. How can I add a custom script to footer of login page?
  60. Brute force attack?
  61. Customize wp_new_user_notification_email()
  62. Need to execute a cron job
  63. Login email after registration never sent or received
  64. How can I create a separate blog that is private?
  65. How to keep always logged in development environment
  66. Add Confirm Password field in wp-login.php Password Reset page
  67. Integrate recaptcha and wp_signon – what is needed?
  68. Stop users from logging in from multiple locations
  69. I want to disable E-Mail verifcation / activation when a user signs up for my WordPress site
  70. custom login page redirect to logged in user profile page
  71. Email address or username used to login in wordpress
  72. How do I check if a post is private?
  73. Front-end login: Redirect user to the post they had created
  74. Receiving “This content cannot be displayed in a frame” error on login page
  75. My login form does not work
  76. Programmatically log in a wordpress user
  77. Action wp_login_failed not working if only one field is filled out
  78. Getting “Cookies are blocked or not supported by your browser” on login page
  79. What is the purpose of logging out after WordPress upgrade?
  80. Is it alright for two people to simultaneously be logged into a WP site as administrator?
  81. wp-login.php redirecting to HTTPS
  82. Display last login time
  83. How to customise wp-login.php only for users who are setting a password for the first time?
  84. Intentionally Force Failed Login WordPress
  85. How do I turn off the ability to login?
  86. Gaining Login Access via the Database
  87. How can I test the login for an expired session?
  88. Give visitor access to password protected page/post via external script
  89. Send reset password link to user from custom lost password form
  90. What hooks should I use for pre-login and pre-registration actions?
  91. WordPress Login Footer URL
  92. Remove built in wordpress login and use only google auth
  93. Websites defaced by uploading script using theme editor
  94. wp_login action hook not working
  95. Make wordpress admin failed login attempt return 401
  96. Cookie settings for session across WPML subdomains using custom AJAX login
  97. How to translate “wrong password” message
  98. Login redirect_to loop with reauth=1, cookie expiry set to 1 year in past
  99. User Login Form Outside the Default wp-login Form
  100. Change sign-on URLs for security purposes
Categories login Tags login, shared-user-tables
Allow users to create their own page/s
Localize tinymce in WordPress 3.9?

Recommended Hostings

Cloudways: Realize Your Website's Potential With Flexible & Affordable Hosting. 24/7/365 Support, Managed Security, Automated Backups, and 24/7 Real-time Monitoring.

FastComet: Fast SSD Hosting, Free Migration, Hack-Free Security, 24/7 Super Fast Support, 45 Day Money Back Guarantee.

Recent Added Topics

  • Bug in translation system: load_theme_textdomain() returns true, files are available and accessible but the language defaults to english
  • Custom Elementor controls not appearing in the widget Advanced tab using injection hooks
  • Get the name of the template/*html file used
  • Trying to Add Paging to Single Post Page
  • Sharing media files between live and staging servers
  • How to display the description of a custom post type in the dashboard?
  • Critical error on image display
  • Copying WP data and files into new install?
  • How to determine the DirectAdmin WordPress backup date?
  • How to get list of ALL tables in the database?
© 2026 Read For Learn
  • Database
    • Oracle
    • SQL
  • algorithm
  • asp.net
  • assembly
  • binary
  • c#
  • Git
  • hex
  • HTML
  • iOS
  • language angnostic
  • math
  • matlab
  • Tips & Trick
  • Tools
  • windows
  • C
  • C++
  • Java
  • javascript
  • Python
  • R
  • Java Script
  • jQuery
  • PHP
  • WordPress