syntax error for changing user role from database

Found it.

It was a field in phpMyAdmin which is set to a semicolon(;) by default.

I have changed it to an unused char and the query ran normally.

enter image description here

Related Posts:

  1. Delete all post meta except featured image
  2. Set Display Name to first and last name (phpmyadmin SQL Query)
  3. Emojis getting converted to “?”
  4. How to replace values in WordPress DB using phpMyAdmin
  5. Delete all post meta except featured image Using SQL
  6. Accidentally deleted active_plugins portion of the wp_options DB table
  7. WordPress database import: Row size too large
  8. WordPress Database Huge wp_usermeta Table
  9. Connection refused on locahost after importing database?
  10. Changing root password in PHPMyAdmin for WordPress Database when going live
  11. Can’t update WordFence Options, clear data manually
  12. Post Views / Hit Counter Problem?
  13. How to migrate a database from a server to another
  14. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  15. Files on Localhost, Database on Server
  16. Backing up WordPress database and files
  17. wp_option table error while importing
  18. Installing local to live WP into subdirectory
  19. Delete user with only subscriber role
  20. Can’t log into wordpress site – I have made a new user and still cant access
  21. Is there any way to monitor a MySQL db and check what has changed?
  22. DB prefix not updating
  23. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  24. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  25. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  26. Is there any defects for using same database prefix in WordPress for multiple sites?
  27. Migrating meta_key and meta_value from old theme to new one
  28. What is recommended data type and encryption type for password in a database
  29. Duplicate database to roll back theme & content changes
  30. WP website showing blank page after moving from subdomain to main domain
  31. How to retrieve user data based on role using SQL?
  32. WordPress character set issue
  33. Missing latest posts and options after DB migration via phpMyAdmin
  34. Check if a database is well installed
  35. Changed meta_key value in structures, now dashboard shows zero users
  36. Options table – where does my values go?
  37. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  38. Help required with local wordpress setup
  39. #1067 – Invalid default value for ‘post_date’ when trying to create a new column
  40. WordPress Admin login problems- PLEASE HELP [closed]
  41. Deleting WordPress posts and media files based on author via MYSQL database
  42. Database table prefix different between wp-config.php and in database
  43. What is an ORM, how does it work, and how should I use one? [closed]
  44. What is the difference between an ORM and an ODM?
  45. What is this JavaScript “require”?
  46. Rename a table in MySQL
  47. How should I tackle –secure-file-priv in MySQL?
  48. What is this JavaScript “require”?
  49. What is “Advanced” SQL?
  50. What’s the difference between identifying and non-identifying relationships?
  51. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  52. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  53. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  54. What are the differences between B trees and B+ trees?
  55. MySQL SELECT increment counter
  56. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  57. Example of a strong and weak entity types
  58. Oracle SQL query for Date format
  59. phpMyAdmin – Error > Incorrect format parameter?
  60. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  61. Difference between partition key, composite key and clustering key in Cassandra?
  62. How SID is different from Service name in Oracle tnsnames.ora
  63. What is a relation in database terminology?
  64. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  65. Database vs File system storage
  66. Can I have multiple primary keys in a single table?
  67. How to create a foreign key in phpmyadmin
  68. importing a CSV into phpmyadmin
  69. Exclude Statement in SQL
  70. How do you query for “is not null” in Mongo?
  71. What is a file based database?
  72. Is it fine to have foreign key as primary key?
  73. Storing Images in DB – Yea or Nay?
  74. Using wpdb to connect to a separate database
  75. how to Optimize WordPress database for 10 million post? [duplicate]
  76. MySQL Database User: Which Privileges are needed?
  77. Why is my database import losing text widget data?
  78. Database synchronization between dev/staging and production
  79. Keeping WP database synced across multiple developers using git
  80. WPDB Insert or if exists Update
  81. Multiple developers / editors working on a site in progress
  82. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  83. get_results using wpdb
  84. Will it break my site if I delete all transient records in wp_options table?
  85. Checking if Database Table exists
  86. Why WordPress choose data serialization over json_encode?
  87. What’s the simplest way to backup my WordPress database?
  88. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  89. $wpdb won’t insert NULL into table column
  90. Relaunch 4.2 utf8mb4 database upgrade
  91. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  92. Safest way to bulk delete post revisions
  93. Please explain how WordPress works with MySQL character set and collation at a low level
  94. Solution for database version control and deployment?
  95. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  96. How many users can WordPress handle?
  97. Get error messages when $wpdb->insert() returns false?
  98. Detecting errors generated by $wpdb->get_results()
  99. Staging sites, how do you manage synchronising updates in the DB?
  100. Does dbDelta delete columns as well?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)