Mp3-Codes

More Free Music at MP3-Codes.com

just test

http://www.webmasterworld.com/php/3273144.htm

WordPress Localhost

XAMPP INSTALL

http://www.tamba2.org.uk/wordpress/xampp/

Through MySQL Command Line

1. Get an MD5 hash of your password.
   • Visit md5 Hash Generator, or…
   • Create a key with Python. or…
   • On Unix: echo -n <password> | md5sum
2. “mysql -u root -p” (log in to MySQL)
3. enter your mysql password
4. “use (name-of-database)” (select WordPress database)
5. “show tables;” (you’re looking for a table name with “users” at the end)
6. “SELECT ID, user_login, user_pass FROM (name-of-table-you-found)” (this gives you an idea of what’s going on inside)
7. “UPDATE (name-of-table-you-found) SET user_pass="(MD5-string-you-made)" WHERE ID = (id#-of-account-you-are-reseting-password-for)” (actually changes the password)
8. “SELECT ID, user_login, user_pass FROM (name-of-table-you-found)” (confirm that it was changed)
9. (type Control-D, to exit mysql client)

Note if you have a recent version of MySQL (version 5.x?) you can have MySQL compute the MD5 hash for you.

1. Skip step 1. above.
2. Do the following for step 7. instead.
   • “UPDATE (name-of-table-you-found) SET user_pass = MD5('"(new-password)"') WHERE ID = (id#-of-account-you-are-reseting-password-for)” (actually changes the password)

admin@HOME C:\xampp
# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.1.37 Source distribution

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> use wordpress;
Database changed
mysql> show tables;
+———————–+
| Tables_in_wordpress |
+———————–+
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_terms |
| wp_usermeta |
| wp_users |
+———————–+
10 rows in set (0.00 sec)

mysql> desc wp_users;
+———————+———————+——+—–+———————+
—————-+
| Field | Type | Null | Key | Default |
Extra |
+———————+———————+——+—–+———————+
—————-+
| ID | bigint(20) unsigned | NO | PRI | NULL |
auto_increment |
| user_login | varchar(60) | NO | MUL | |
|
| user_pass | varchar(64) | NO | | |
|
| user_nicename | varchar(50) | NO | MUL | |
|
| user_email | varchar(100) | NO | | |
|
| user_url | varchar(100) | NO | | |
|
| user_registered | datetime | NO | | 0000-00-00 00:00:00 |
|
| user_activation_key | varchar(60) | NO | | |
|
| user_status | int(11) | NO | | 0 |
|
| display_name | varchar(250) | NO | | |
|
+———————+———————+——+—–+———————+
—————-+
10 rows in set (0.00 sec)

mysql> select ID, user_login, user_pass from wp_users;
+—-+————+————————————+
| ID | user_login | user_pass |
+—-+————+————————————+
| 1 | admin | $P$BhvJIQqwWdmREwmBKLdiiHzPiJFmeP/ |
+—-+————+————————————+
1 row in set (0.00 sec)

mysql> update wp_users set user_pass = md5(‘xxxxxxxxxxx’) where id=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select ID, user_login, user_pass from wp_users;
+—-+————+———————————-+
| ID | user_login | user_pass |
+—-+————+———————————-+
| 1 | admin | c047dad3075547d0e3727cbb55994c39 |
+—-+————+———————————-+
1 row in set (0.00 sec)

mysql>

Test Clock

test visitors

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!