How to change wordpress adminstrator user ‘s ID from 1 to 0?

The MySQL table that stores the user data wp_users have an autoincrement on the primary key ID. The database will handle it automatically to avoid duplicated values and the minimal value is 1.

There is nothing you can do about it.
Here is the WP tables shema if you want to have a look https://codex.wordpress.org/Database_Description#Table:_wp_users

There is no such thing as admin/client distinction in the user storage.
What you might want to do is create a new user for your admin (its ID would be 2) and then rename the first user and set the right role for your client.
Of course, the next user will have ID 3 and so on…

Related Posts:

  1. http://localhost/phpMyAdmin/ unable to connect
  2. phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration
  3. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  4. mysql said: Cannot connect: invalid settings. xampp
  5. This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available
  6. Delete a database in phpMyAdmin
  7. PHPMyAdmin Default login password
  8. wamp server mysql user id and password
  9. phpmyadmin “Not Found” after install on Apache, Ubuntu
  10. Delete a database in phpMyAdmin
  11. Making someone a WordPress administrator using PhpMyAdmin
  12. Why am I unable to login to Dashboard after adding myself to admin via phpMyAdmin?
  13. Resetting menu_order to 0 for posts in PHPmyAdmin?
  14. phpMyAdmin displays error when importing database 2
  15. oembed_cache SPAM problem [closed]
  16. Delete all pages (thousands) except a few by their IDs
  17. Recovering a wordpress blog that got corrupted
  18. Importing posts content from csv
  19. duplicate wordpress site on same bdd
  20. I can not access my local PhpMyAdmin control panel
  21. wp_login.php redirects to old domain
  22. Strings from database are not shown correctly
  23. WordPress database defragmentation
  24. Cannot login to WordPress admin after update
  25. How to log in to phpMyAdmin with WAMP, what is the username and password?
  26. mysqli_real_connect(): (HY000/2002): No such file or directory
  27. MySQL Error #1133 – Can’t find any matching row in the user table
  28. MySQL: Can’t create table (errno: 150)
  29. MySQL: How to reset or change the MySQL root password?
  30. Moving WordPress from MAMP to WAMP, can’t access pages
  31. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  32. Manually delete post from database
  33. Reseting admin password through PHPMyadmin fails
  34. How to delete users with no order history through phpmyadmin sql?
  35. Moving database with phpMyAdmin
  36. Export only pages and posts with mysql dump
  37. unable to upload image locally
  38. How to do a MySQL dump from production site without using a search and replace script for local development?
  39. How to Move Local Singlesite Database to Remote Multsite Database?
  40. How Do I Merge Categories With phpMyAdmin
  41. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  42. Emojis getting converted to “?”
  43. Accidentally deleted active_plugins portion of the wp_options DB table
  44. Change sticky status of posts from phpMyAdmin
  45. Is there a way I can find wordpress posts that don’t contain a word?
  46. Users table association with users_metadata table appears broken
  47. WordPress database import: Row size too large
  48. Filter table with dropdown
  49. Backing up and restoring multiple sites efficiently
  50. Better way to migrate to server?
  51. What will happen if I delete all my attachment type posts from database?
  52. AWS Bitnami WordPress – SELECT command denied to user
  53. I want to create a 300 multi-site wordpress network using subdomains
  54. How do i edit the plugin files in DataBase via phpMyAdmin?
  55. Can’t update WordFence Options, clear data manually
  56. Post Views / Hit Counter Problem?
  57. WordPress admin creation through phpmyadmin not working
  58. Setting up WordPress Locally on WAMP for a new site (with one already)
  59. Getting Error Trying to Create Table
  60. How do I remove/reset all current widgets from the database?
  61. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  62. Clients with empty username are not receiving request new password email
  63. lost all the links in WordPress after changing hosting
  64. Changing a Child theme’s name on MAMP localhost
  65. Changing the entire permalink
  66. Way to send multiple values for column to MySQL?
  67. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  68. How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
  69. Plugin can’t write to database even though permissions appear correct?
  70. wp_option table error while importing
  71. Installing local to live WP into subdirectory
  72. Export SQL query based on custom field?
  73. Delete user with only subscriber role
  74. Can’t log into wordpress site – I have made a new user and still cant access
  75. Change word in woocommerce product category custom field
  76. Display data from phpMyAdmin with WordPress
  77. Import large database in php my admin
  78. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  79. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  80. Migrating meta_key and meta_value from old theme to new one
  81. Unable to insert two value in two different columns (WordPress database)
  82. Update WooCommerce stock status with SQL query if stock value is greater than 0
  83. why not selecting multiple rows of same standard_id using SQL query from database?
  84. SQL query to change custom field in WordPress database
  85. update_post_meta not working in template_redirect action
  86. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  87. Reset post IDs with all post meta
  88. SQL query to bulk change short code in all posts
  89. WP website showing blank page after moving from subdomain to main domain
  90. submit form data to wordpress existing database table using my plugin
  91. 403 Forbidden Localhost Wamp Apache Php
  92. Changing WordPress author name in database
  93. WordPress character set issue
  94. get backup file from wordpress database in x days
  95. Changed meta_key value in structures, now dashboard shows zero users
  96. WordPress not taking password and username
  97. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  98. Export posts with postmeta without ID?
  99. Need SQL query to find&replace image URL
  100. How to run site locally after downloading database