A week ago, I posted on steemit.com a story about how to integrate wordpress with Blockchain steem. Here link!
Now I post from my blog that built with CMS wordpress where I installed and activated the stempress!
Let’s start with activating the steempres plugin.
As you can see in the picture you have to click on the “Activate” button and it should look like Stempress!
Now click on the settings and go to the activation menu.
Here we have to connect with the user and “Posting key” from the steem.
The “Posting key” is taken from our account on steemit.com.
Click on “SHOW PRIBATE KEY” to show your real key for login. What you see at first time it’s not your real key.
Once you log in, it should look like this!
That’s all, when you post, you have the option of posting what you write on the blog or not on steem Blockchain. See picture!
I think this is the first wordpress written post that also appears on Steem blockchain.
I wish you an excellent day!
Q: How to reset WordPress password via SQL ?
A: Login to mysql database
mysql -u wordpress -p
MariaDB [(none)]> use db_wordprs;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
MariaDB [db_wordprs]> select * from wp_users;
| ID | user_login | user_pass | user_nicename | user_email | user_url | user_registered | user_activation_key | user_status | display_name |
| 1 | admin | $P$BeI/6SDDb5x33lthRtdqaoVuO8.TfH/ | admin | email@example.com | | 2016-10-26 07:55:16 | | 0 | admin |
1 row in set (0.00 sec)
And now change / update password:
UPDATE wp_users SET user_pass= MD5(‘Your-Password’) WHERE ID = 1;
MariaDB [db_rezes]> UPDATE wp_users SET user_pass= MD5(‘Your-Password’) WHERE ID = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Metod to set file permissions and FS method in wordpress. To allow WordPress to configure wp-config.php during installation, update files during upgrades, and update the .htaccess file for pretty permalinks, give the server write permission on the files.
Change the owner of the wordpress directory and its contents to apache on Centos 7. Keep the group as staff, a group to which your user account belongs and give write permissions to the group.
[root@mailx work]# cd /var/www/html
[root@mailx html]# chown -R apache. wordpress-site2
[root@mailx html]# chmod -R g+w wordpress-site2
Add this to your wp-config.php at the end file.