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. Error 403 on wp-admin – Redirection to upgrade.php
  25. Organizing Code in your WordPress Theme's functions.php File?
  26. How to check if a user is in a specific role?
  27. Can I rename the wp-admin folder?
  28. How do I Enqueue styles/scripts on Certain /wp-admin Pages?
  29. Changing Admin Menu Labels
  30. Adding custom columns to custom post types
  31. Adding Fields to the Category, Tag and Custom Taxonomy Edit Screen in the WordPress Admin?
  32. adding custom stylesheet to wp-admin
  33. Can’t change language (only “English (United States)”)
  34. Is there ANY way to remove comments function and section totally?
  35. How to use “menu_order” field for posts?
  36. “Too many redirects” ONLY when trying to access wp-admin page
  37. How to restrict dashboard access to Admins only?
  38. Admin Page Redirect
  39. Disable dragging of meta boxes?
  40. Toggle admin metabox based upon chosen page template
  41. Unable to login and wp-login.php redirects to wp-admin%2F&reauth=1?
  42. When moving a WP site, why does wp-admin redirect to old site?
  43. How to disable the “Post Lock/Edit Lock”?
  44. adding the category to the admin column for a custom post type?
  45. How can we make managing lots of pages in WordPress Admin better?
  46. Change page title in admin area
  47. do_shortcode() within Admin Page
  48. How can I control the position in the admin menu of items added by plugins?
  49. Changing the ‘wp-admin’ URL to whatever I want
  50. Unit testing in the WordPress backend (is_admin() is true)
  51. Admin ajax request return 0 with die()
  52. How to prevent access to wp-admin for certain user roles?
  53. How to remove screen options and help links in the admin area?
  54. How to remove the core embed blocks in WordPress 5.6?
  55. How to increase the file size limit for media uploads?
  56. Create WP tutorial for users with admin pointer using next button for navigation
  57. I’m getting a 404 message when I try to access wpadmin
  58. Taxonomy dropdown metabox in the back-end
  59. wordpress wp-admin css not loading
  60. Sort admin menu items
  61. How to order by post meta name in wp admin?
  62. How set defaults on wpLink()
  63. Remove dashboard, use Pages tab as default
  64. How to eliminate weird 404 errors in wp-admin?
  65. How to redirect/rewrite all /wp-login requests
  66. Show all post tags on post edit screen/sidebox
  67. How to hook in and modify the new revisions UI (3.6+)?
  68. How to display a static HTML page while setting up a WordPress site?
  69. Limit widget to certain sidebar?
  70. How can I uninstall a language?
  71. Check if user is admin by user ID
  72. My wordpress site gets redirected automatically to the old site any known solution for this?
  73. Best way to present options for home page in admin?
  74. Use a different domain for SSL
  75. Remove specific items from Quick Edit menu of a Custom Post Type?
  76. How to filter by post-format in admin?
  77. Unable to login to my wordpress site. reauth=1 redirection loop
  78. Add “external” link to admin menu in the backend
  79. How to Layer 7 Load Balance WordPress Backend and Frontend?
  80. Disable image attachment links
  81. How can I improve the line break handling in the WYSIWYG editor?
  82. wp_list_tables bulk actions
  83. Custom column for changing post status via ajax
  84. How do I change the login logo URL and hover title?
  85. Custom login redirects to wp-admin on wrong password
  86. How to remove comments option from wp-admin bar and modify profile icon
  87. Remove “Time to upgrade” message from dashboard
  88. Add header and footer to WP backend
  89. js error on post editing page
  90. How to search post by ID in wp-admin
  91. Remove ‘Custom..’ option in tinyMCE colour swatch
  92. sortable custom column in media library
  93. How to add a custom metabox to the Menu Management admin screen?
  94. how do I force a single column layout in screen layout
  95. How can I enable Google Analytics on a file download link?
  96. What is the best method to close off the backend?
  97. How to add custom submenu links in wp-admin menus?
  98. How to list ALL Pages in the dashboard?
  99. .htaccess in wp-admin produces a redirect loop
  100. Change Login URL Without Plugin
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)