Posts Tagged ‘ user ’

How to Work with MySQL – Basic Tasks

2017/09/16
By
Modified: 2017/09/10
How to Work with MySQL – Basic Tasks

This material is tested with MySQL 5.1 and 5.5 on various Windows versions. This article covers these topics: -010- MySQL Data Location -020- Shortcut to MySQL Command Shell -030- Create a New Database -035- Delete an Existing Database -040- Display a List of All DB Users -050- Display a List of All Tables -060- List All Fields in a Table -070- Free ODBC Connector is Available -080- Create a New User -085- Change User Password -090- Delete a User -100- Grant User Rights to a D/B and Show It -110- Save Database into a Dump File -120- Restore Database From a Dump File -130- Rename Database -140- Backup Database -150- Automate…

Read more »


New User Registration in WordPress 3.X

2017/06/10
By
Modified: 2017/04/30
WordPress-User-Registration

There is a certain magic in many well-constructed marvels.  This definitely applies to a WordPress.  Just recently I needed to fix something inside user registration procedure, and with very limited PHP knowledge, I was able to figure out, what was going on and fix the problem. On the way there, I couldn’t help but admire, how well everything is documented and linked-in to minimize code duplication.  There is an obvious truth in saying that “the best things in life are free”. When user clicks on a link to register, a wp_login.php page opens up.  This page is a conglomerate of  3 different page-forms: — login, — register and — recover a password. Proper…

Read more »

IE10 is not saving passwords and user names

2017/04/27
By
Modified: 2017/03/03
IE10 is not saving passwords and user names

I hope this post will help a lot of frustrated users out there. PROBLEM: IE10 was working fine, but at one point it stopped saving user names and passwords for web sites. This most securely-configured browser, so switching was not an option.   Here is my solution.  Please see, if it works for you. SOLUTION: For extra security I’ve checked Delete browsing history on exit (see image 1).  I did it without understanding, what it is I am requesting to delete.  To solve my problem, I had to uncheck Cookies and website data on the very next Delete screen (see image 2).  Now IE10 is preserving user names in passwords for visited…

Read more »

Work with MySQL – Basic WordPress Queries

2017/04/24
By
Modified: 2017/04/30

This article was born, as I was searching for ways to handle thousands of registered WordPress users, who never do anything, never return to the site, and never even change their default password.               Table of Topics -1030- List all registered users sorted by date -1060- Group registered users by email domain name -1090- Users who ever posted articles -1120- List of registered users who ever posted comments -1150- List of users, who posted messages in your bbPress Forum -1180- Group users by year and month of registration -1210- Count users in different roles -1240-  Users who never changed their default password -1270-  Users who changed their default password -1300-…

Read more »