To change the initial ID user by mysql
ALTER TABLE wp_users AUTO_INCREMENT=2;
although the number has to start at the next available id with no existing id higher, as in
select max(id) from wp_users;
https://stackoverflow.com/questions/1485668/how-to-set-initial-value-and-auto-increment-in-mysql
Related Posts:
- WordPress Unit Testing – Cannot Create Tables
- Insert data in database using form
- When is it appropriate to create a new table in the WordPress database?
- Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
- Importing posts from old website to new conflicting post ID’s?
- BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
- stdObject stored in database. How does one convert it to usable format?
- Database with mixed collation (utf8mb4 & utf8_general_ci)
- Moving to another host; which tables to move in a database
- WordPress mysql table double prefixes
- Change WordPress prefix for only one table?
- input data and output table [closed]
- Retrieve data from the database to table such as comments in the admin control panel
- Change options table prefix only
- Query multiple tables at once?
- Why does changing Database Table Prefixes result in loss of content?
- Can I customised default WP table
- Should I use an additional column in the DB?
- Will adding & modifying default WordPress table index break future WordPress update
- How can I query the db to access current post information?
- What is wrong here? Issue with post_id and meta_value
- How to edit custom table data in frontend
- How to map data on CSV to web pages?
- Get id from database
- Using class id from array for query
- Have WordPress Use a Different Database for users
- How is better to store at DB 1-side relationsip from CPT to many Taxonomies Terms ID’s?
- large number (bigint) for post ID issue in database
- Database table prefix different between wp-config.php and in database
- Count views without get_post_meta
- What are the differences between B trees and B+ trees?
- Storing Images in DB – Yea or Nay?
- Dealing with Many Meta Values, 30+
- What is the most secure way to store post meta data in WP?
- Corrupt WordPress Database
- Have multiple local wordpress installs share a wp-content folder and database
- Faulty restore of the database, encoding issue
- Save custom post type in different table
- Is $wpdb->prepare escaping to much? How to use it properly?
- What is the purpose of storing `siteurl` in database?
- How to log database changes during an upgrade?
- Using same database for main and subdomain
- Emojis getting converted to “?”
- Building a Scalable Resiliant WP Setup
- Search and replace special characters (å,ä,ö) for image attachments only in database
- Automate dir and DB stack creation with WP-CLI
- Moving WP from local server to live, error establishing a db connection
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- Exporting table to csv works in the admin but exports HTML data when used on the front end
- wp search-replace (not executing)
- Create table from array with prepare
- Migrate database between 2 different wordpress version
- Migrating from PDO using SQLite to clean new install using MySQL
- Change WordPress URL in sql file via Terminal
- $wpdb->insert Giving duplicates
- Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
- Where is phpMyAdmin inside WordPress?
- What can I do when an outside party hacks into my weblog and changes my display name?
- How to delete database without using any plugin?
- Cannot restore wordpress database from sql dump [closed]
- WooCommerce: remove sample & dummy data
- Is database deleted on clicking “reinstall” button in WordPress updates?
- Fill custom select field with pages/post titles
- Is my way to change WordPress server is correct?
- WordPress database products structure
- I cannot find the difference between these wp_capabilities values in wp_usermeta
- Files on Localhost, Database on Server
- Is there any way to monitor a MySQL db and check what has changed?
- DB prefix not updating
- Right way to store a large set of similar information on website? [duplicate]
- Any other way of storing plugin admin data setting
- Will memcached improve performance with WP Super Cache already running?
- I want to schedule email (date, time is in database->table) wp_schedule_event() not working
- Error establishing a database connection – WordPress setup, everything else is working
- Restore of database doesn’t show content
- Why theme settings lost when I installed https
- WordPress site migration – locked out of admin area
- WordPress users table missing indexes
- unable to use my wordpress site after moving
- How to add download link from database on custom page template?
- How to get the id of recently registered user from database?
- How can i syn wordpress user table with a stand-alone php script?
- insert data from a form:: Warning Empty query mysqli::query()
- Db connection problem on Azure Since database moved on CLEARDB
- How can we speed up wp_get_nav_menu_items()?
- Mysql Queries per Visit – Crazy High
- Media Library doesn’t allow uploads? Upload Directory
- Moving Site: Is Re-downloading Files After Changing URLs necessary?
- using same mysql user with many databases
- WP DB Location for “Next Post to Create” Index Value
- Manage 3 Layers Of Information (CTP – Posts – Then Maybe Metadata?)
- Insert double entry in DB
- Database custom table issues – incorrect result displayed
- Insert Extra fields added in the front end registration form to DB
- $wpdb->insert not working for last select option
- How to create a table [closed]
- Upload wordpress from localhost to 000webhost
- WP Multisite Users Not Linking
- Query a meta key using an array of values where the database value is a string
- I need to downgrade from 5.9.9 to latest 5.8.x – where is the db instructions executed when upgrading?