Why user_pass column in wp_users table is varchar(64)

It is because of different encrypted algorithm. Sometimes users will override the MD5, which is the default algorithm, and add their own, which might need a little longer length to store the password.

Take a look at the Q&A’s »What data type to use for hashed password field and what length?«, having detailed information about hashes and their length, at Stackoverflow for reference.

Related Posts:

  1. MySQL Database User: Which Privileges are needed?
  2. Database synchronization between dev/staging and production
  3. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  4. Safest way to bulk delete post revisions
  5. How can I make a WordPress database portable and url independent?
  6. Why does $wpdb return strings for mysql integer values?
  7. Dealing with Many Meta Values, 30+
  8. When is it appropriate to create a new table in the WordPress database?
  9. Is it possible to switch the data layer within WordPress?
  10. store simple data in get_option()
  11. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  12. Have multiple local wordpress installs share a wp-content folder and database
  13. How to implement content from external database into WordPress text page? [closed]
  14. Cloning and syncing a WordPress website
  15. What actions affect files, DB, or both?
  16. Add search Value to wp_list_table pagination
  17. How to fix unchanged URLs in Database after running serialized search and replace script?
  18. Merging WordPress posts from different databases
  19. Should non-WordPress data get its own DB?
  20. Who is responsible for data sanitization in WordPress development?
  21. Search and replace special characters (å,ä,ö) for image attachments only in database
  22. Localhost to Staging to Development Dynamic WP-CONFIG
  23. Setup 3 Sites To Connect To 1 Database and Share Data
  24. Uknown meta entries in wp_postmeta
  25. creating new field on mysql
  26. Can local WordPress installs share /wp-content/ folder and database?
  27. SymmetricDS in dev + prod workflow?
  28. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  29. WPCLI search and replace in a particlar site dir effect another site-dir
  30. Merging development site with live site
  31. One WP Database outside localhost and two connections
  32. Get id from database
  33. Share WordPress Database
  34. MySQL Database User: Which Privileges are needed?
  35. What is an ORM, how does it work, and how should I use one? [closed]
  36. What is the difference between an ORM and an ODM?
  37. What is this JavaScript “require”?
  38. Rename a table in MySQL
  39. How should I tackle –secure-file-priv in MySQL?
  40. What is this JavaScript “require”?
  41. What is “Advanced” SQL?
  42. What’s the difference between identifying and non-identifying relationships?
  43. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  44. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  45. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  46. What are the differences between B trees and B+ trees?
  47. MySQL SELECT increment counter
  48. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  49. Example of a strong and weak entity types
  50. Oracle SQL query for Date format
  51. phpMyAdmin – Error > Incorrect format parameter?
  52. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  53. Difference between partition key, composite key and clustering key in Cassandra?
  54. How SID is different from Service name in Oracle tnsnames.ora
  55. What is a relation in database terminology?
  56. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  57. Database vs File system storage
  58. Can I have multiple primary keys in a single table?
  59. Exclude Statement in SQL
  60. How do you query for “is not null” in Mongo?
  61. What is a file based database?
  62. Is it fine to have foreign key as primary key?
  63. Storing Images in DB – Yea or Nay?
  64. Using wpdb to connect to a separate database
  65. how to Optimize WordPress database for 10 million post? [duplicate]
  66. Why is my database import losing text widget data?
  67. Keeping WP database synced across multiple developers using git
  68. WPDB Insert or if exists Update
  69. Multiple developers / editors working on a site in progress
  70. get_results using wpdb
  71. Will it break my site if I delete all transient records in wp_options table?
  72. Checking if Database Table exists
  73. Why WordPress choose data serialization over json_encode?
  74. Delete tables from database when deleting plugin
  75. What’s the simplest way to backup my WordPress database?
  76. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  77. $wpdb won’t insert NULL into table column
  78. Relaunch 4.2 utf8mb4 database upgrade
  79. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  80. Please explain how WordPress works with MySQL character set and collation at a low level
  81. Solution for database version control and deployment?
  82. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  83. How many users can WordPress handle?
  84. Get error messages when $wpdb->insert() returns false?
  85. Detecting errors generated by $wpdb->get_results()
  86. Staging sites, how do you manage synchronising updates in the DB?
  87. Does dbDelta delete columns as well?
  88. How to get the post publish date outside the loop?
  89. MariaDB as a backend database
  90. wpdb update add current timestamp not working
  91. How can I delete orphan keys in WordPress database tables?
  92. Site stuck in “Database Update Required” loop
  93. How to fetch Data in WordPress using MySQLi or $wpdb
  94. WordPress Database lost auto increment
  95. Count & Display Database Queries
  96. Connect to database using wordpress wp-config file
  97. How to delete all records from or empty a custom database table?
  98. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  99. wpdb->insert multiple record at once
  100. How to migrate a HTTPS WordPress installation to localhost?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)