If you want to change WordPress user ID for some reason (such as security), you not only need to change the ID column in the users table, but you also need to change it in a few other places (such as all the posts and comments made by that user).
[more...]This page explains how to change user email address in the WordPress database directly with a SQL query.
General user email change SQL query
The email address for each user is stored in the wp_users table in the column named user_email.
You need to update the value in this column,
[more...]This page explains how to change WordPress username (login) with a SQL query directly in the database.
General user login change SQL query
Usernames are stored in the wp_users table, in a column named user_login (not username, not user_name, not login - common mistakes).
You can easily change a particular user's
[more...]This page explains how to change WordPress user password with a SQL query directly in the database.
Where passwords are stored in WordPress DB
Passwords are stored in the wp_users table in a column named user_pass (not user_password, not just password - common mistakes).
Password encryption in WordPress
One thing which
[more...]This page explains how to change user level with a SQL query directly in the WordPress database.
What is user level and what it does
Although user levels have been oficially deprecated since WordPress 3.0, they are still supported for back compatibility and may still have a meaning in
[more...]