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’;