Category Archives: MySQL

3) wp_users

zapmap.com/wp-admin/profile.php

  1. mysql -u [username] -p -D [database_name]
  2. desc [table_name];
  3. UPDATE wp_users SET user_pass = MD5( ‘[new_password]’ ) WHERE user_login = ‘[username]’;
  4. UPDATE wp_users SET user_login = ‘[new_username]’ WHERE user_login = ‘[old_username]’;

mysql -u root -p -D wp480
desc wp_users;

UPDATE wp_users SET user_login = ‘Francisco’ WHERE user_login = ‘Frank’;

UPDATE wp_users SET user_pass = MD5( ‘def456’ ) WHERE user_login = ‘Francisco’;

For More Information

Class Reference/WP Query ¬ę WordPress Codex – WordPress.org Codex

Displaying_Posts_Using_a_Custom_Select_Query – WordPress.org Codex

Understanding MySQL in WordPress by Scott Taylor

 
https://core.trac.wordpress.org/browser/

http://www.wpbeginner.com/wordpress-performance-speed/

http://zapmap.com/virgin/wp-admin/about.php

https://codex.wordpress.org/Backing_Up_Your_Database

https://codex.wordpress.org/Database_API

https://codex.wordpress.org/Database_Description

https://codex.wordpress.org/FAQ_Developer_Documentation

https://codex.wordpress.org/Metadata_API

https://wordpress.org/plugins/tags/mysql/

http://zapmap.com/category/mysql/

MySQL in WordPress 3.9

MySQL Profiler

http://zapmap.com/virgin/wp-admin/options-permalink.php

PHP/MySQL CPU performance statistics

http://zapmap.com/virgin/wp-admin/profile.php

http://zapmap.com/wp-admin/profile.php

https://codex.wordpress.org/Resetting_Your_Password

https://codex.wordpress.org/Restoring_Your_Database_From_Backup

https://www.sublimetext.com/

The WordPress Database Demystified

Tour of the WordPress Database

https://code.tutsplus.com/tutorials/understanding-and-working-with-taxonomies-and-terms-in-wordpress–cms-21051

http://wordpress.tv/

http://www.wpbeginner.com/