How to create a WP Admin user in phpMyAdmin for WordPress 4.6

I think the issue is to do with the values that you have stored in the database. Did you type it in or copy and paste? This could of led to unwanted white-space in the values stored in the DB.

Also curious as to why its being done at DB level when you can log into WordPress and do an import of a DB CSV file. This will import any blog posts, content, imagery stored there as well as other users. The reason I say this, is because it appears to be a new site setup rather than actually having to setup a new admin because of a hack (as alluded to why you would have to do it this way in the help article you linked to.)

I feel that in order to fix this issue, you are going to have to set up a new installation of WordPress with a fresh DB and start again.

Related Posts:

  1. How to show an error message after publishing a post?
  2. Unwanted redirect in admin area
  3. Too many datadabse connections – upper ceiling mysql
  4. 500 Internal Server Error after Register dialog, but with successful registration
  5. WP Database Error (Windows Server 2008 & SQL Server)
  6. How To Reset Ownership And Permissions of Wp-Content Folder, In Order to Fix HTTP Error When Uploading Images to WordPress Media Library
  7. Wp-admin is giving me an error “Sorry, you are not allowed to access this page.”. I do have access to the wp-admin besides the dashboard itself
  8. wp-admin 302 redirects
  9. class-wp-hook.php on line 288
  10. Cannot log in to the admin, no error message [closed]
  11. Uncaught SyntaxError: Unexpected Token Illegal
  12. Pages section (only) not loading after publishing large number of pages
  13. How do I fix wp-admin error when exporting reusable blocks?
  14. WordPress critical error on wp-admin page with 100% permissions
  15. Unable to access my page or WP Admin
  16. mixed contents admin panel is Unsecured
  17. How do I fix the 403 error for wp-admin/admin-ajax.php?
  18. Failed to load resource: the server responded with a status of 431 ()
  19. WordPress logged in but no access to wp-admin
  20. Can’t log into WordPress after domain change
  21. Non Object Notice Error – How to fix please
  22. WordPress blog fails to open
  23. Why when I click on a link into the WP admin panel I am redirected to a link that doesn’t contains wp-admin prefix, so I obtain 404 error
  24. Can I rename the wp-admin folder?
  25. How can I control the position in the admin menu of items added by plugins?
  26. How to remove screen options and help links in the admin area?
  27. wp_list_tables bulk actions
  28. How do I find all admin users using phpmyadmin?
  29. Can I add custom attributes while adding inline scripts?
  30. wp-admin produces a 302 redirect to itself
  31. Restrict access to admin but allow admin_post hook
  32. Disable sticky posts feature
  33. Hide username from users list
  34. Login to wp-admin “redirect_to” points to wrong URL after migration
  35. Remove HTTP: from the site URL and just keep // in it
  36. TinyMCE Autoresize
  37. WordPress wp-admin suddenly lost its style
  38. Activating Child Theme Breaks Website, Blank Page, Error 500
  39. Create Read Only Admin
  40. wp-admin is redirecting to back to home page (localhost)
  41. Rename W3 Total Cache admin menu
  42. How can I add my script to admin using script-loader.php?
  43. Cloned a site but can’t log in – redirecting to old site
  44. Can I edit the wp_post > post_content right before its inserted/updated?
  45. FORCE_SSL_ADMIN not working
  46. I get “The PHP Date/Time library is not supported by your web host.” on my CentOS host, what library to I need to install to add support?
  47. How can I allow core, plugin, theme update checks only for selected admins?
  48. wp_before_admin_bar_render action not working in back office
  49. Why am I unable to login after converting to www?
  50. why my menu is not appearing on the admin panel
  51. Can enter wp-admin when logged in with custom ajax
  52. Locked Out Of WordPress Admin Dashboard After Server Move
  53. Subscribers become Authors after Upgrade? / Mass Update of Users?
  54. map_meta_cap was called incorrectly error?
  55. Can I add my own profile.php?
  56. Add menu option to “New Post” menu in admin bar
  57. Linking table cells to network folders
  58. Remove bulk option row
  59. Admin menu in front-end
  60. How can I disable all external url Google in WordPress backend?
  61. if it possible to get all notifications from all plugins and core?
  62. wp-admin page redirecting to 404 error page
  63. Require Login Redirect to Login Page
  64. How to fix ob_end_flush() failed to send buffer of zlib output compression (1)?
  65. How to replace “Password Protected” text with icon in Admin
  66. Delete the “wp-admin” folder – what could go wrong?
  67. unsuccessful attempt to change domains- wordpress re-routing to old domain
  68. How can I limit page parent dropdown to show only author’s own pages?
  69. Nickname field isn’t appearing in Admin
  70. How to Find The Email of a WP Admin Account
  71. how can I change the font on Edit Post area (admin dashboard)
  72. Icons are missing from Visual Editor
  73. External HTTP API calls slowing down WordPress admin [closed]
  74. Creating custom admin panel pages without making a plugin?
  75. Why is my ‘export’ option missing?
  76. Change users.php WP_User_Query
  77. Blank page when viewing wp-admin
  78. Is it possible to display my theme sidebar in wordpress admin?
  79. Can’t access wp-admin after http to https change
  80. Programtically selecting image URL in Media Library modal
  81. wp-admin: “Sorry, you are not allowed to access this page.”
  82. How to access wordpress from domainB which is installed at domainA
  83. How to optimize the opening speed of admin panel?
  84. How to change the URL of sub menu page?
  85. Change wordpress admin home page
  86. Strange wp admin edit buttons issue
  87. Cannot access wp-admin after migration to another place
  88. Regular users logs in as ADMIN if Admin logged in recently
  89. Enable Excerpt field inside the post editor for pages
  90. Failed to load resource: the server responded with a status of 500 (Internal Server Error)
  91. WordPress switch domains
  92. Not able to access WP admin Page, redirected and a drop down login menu appears 401 error
  93. OSX El Capitan local install Maximum upload file size: 2 MB But php.ini set to 64M
  94. Is it possible to outsource wp-admin to another server?
  95. Wp mwnu not works at all
  96. Search box for hierarchical taxonomies in admin interface
  97. Custom Admin Message from external source to multiple users
  98. Customize a WP_Posts_List_Table class
  99. How can visitors redirect wp-admin to the homepage?
  100. Creating your own options-general.php page