Category Archives: MySQL

– Welcome –

socialnetworks

Welcome to WordPress-Saratoga

  • Attendance: / Sign-in Sheet / password
  • Survey 1: Macintosh, Windows, Unix?
  • Survey 2: Freelance, Startup Team Member, Corporate Employee?
  • Survey 3: Beginner, Intermediate, Advanced User?
  • Fundamentals
    • Blogging
      • Write & post, categorize & tag; fresh content, from time to time.
      • Content consists of text, photos, and/or audio/visual media.
      • Accept comments from visitors.
    • WordPress.com
      • Free Hosted Service, Themes, and Widgets (limited)
      • Optimal Resource Utilization, Load Balancing
      • Automatic Version Updating
    • WordPress.org
      • Host a CMS* website on server of own choosing.
      • Unlimited Customization, Access to Code
      • Maintenance is your own Responsibility!
  • This Month’s Question?
  • Introduce Yourself
    • Name, Title, and Background
    • Tell us about your experience with WordPress so far.
    • Where do you plan to go with WordPress?
  • Next Month?
  • Other Groups 

 <- Twitter Site

* Content Management System (CMS) is a computer program that allows publishing, editing and modifying content on a website as well as maintenance from a central interface. Such systems provide procedures to manage workflow in a collaborative environment.


Pulse Check

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/