Posted on

Search Engine Optimization and Analytics

WordPress comes with various plugins for Search Engine Optimization (SEO) and web traffic Analytics. In this post, we are going to use Yoast SEO and MonsterInsights plugins and go through the process of installation and activation.

First, go to your website. For example, https://<your-website>/wp-admin/plugins.php, click “Add New” button to search for above two plugins.

You can install and activate both Yoast SEO and Google Analytics by MonsterInsights plugins with just a few clicks. Activating these plugins may need activating Google Analytics account first, for which, visit this link and follow the instructions.

https://analytics.google.com

You can see the currently installed plugins on “Plugins” section of the dashboard.

plugins

Also, you can find SEO and readability scores on the “Posts” section of the dashboard.

Conclusion

SEO and Analytics plugins help the website searchable and trackable.

Posted on

phpMyAdmin setup and SQL statements execution

This post is going to show how PHPMyAdmin can be installed on your WordPress website. The assumption is that LEMP stack is already installed. Once logged onto your server, run the following commands:

sudo apt update
sudo apt install phpmyadmin

Installation process prompts to select a web server and does not give nginx as one of the options. Tab out and hit OK to skip this step.

In the next prompt, select Yes to configure a new database for phpmyadmin with dbconfig-common.

This step creates a new database user called:

phpmyadmin

Pick a strong password. You may use a website such as following to generate a strong password.

https://strongpasswordgenerator.com/

This will create a new database user with necessary privileges.

The following step needs to be completed before restarting the nginx server for changes to take place.

Change directory to /etc/nginx/sites-available and make below change to the default file.

 

Save the changes and restart the server using the following command.

sudo systemctl restart nginx

Now, type append /phpmyadmin the website URL to see the following phpMyAdmin login page.

phpmyadmin login page

Use username root and MySQL root password to login here.

Once logged in, phpMyAdmin page looks similar to this page.

Click on “SQL” tab to run the SQL queries. (Note: Only SELECT statements are executed and UPDATE statements are skipped to avoid updating the database)

SQL Statement Execution

  1. SELECT * FROM wp_posts WHERE post_type = ‘revision’
  2. SELECT guid, wp_posts.* FROM wp_posts WHERE post_type = ‘attachment’
  3. SELECT * FROM wp_options WHERE option_name IN ( ‘siteurl’,’home’ )
  4. SELECT * FROM wp_options WHERE option_name = ‘active_plugins’
  5. SELECT * FROM wp_options WHERE option_name = ‘akismet_spam_count’
  6. SELECT DISTINCT user_email FROM wp_users
  7. SELECT wc.* FROM wp_posts wp INNER JOIN wp_comments wc ON wp.ID = wc.comment_post_ID WHERE wp.ID = ‘1’
  8. SELECT wc.* FROM wp_comments wc INNER JOIN wp_users wu ON wc.user_id = wu.ID WHERE wu.user_login = ‘ram’
  9. SELECT * FROM wp_comments INNER JOIN wp_posts ON wp_comments.comment_post_id = wp_posts.ID WHERE wp_posts.ID = ‘1’
  10. SELECT * FROM wp_users INNER JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id WHERE wp_users.ID = ‘1’
Posted on

First Post!

This is my first post after WordPress was successfully installed and running on my own website gundelli.com.

Starting from setting up a Virtual Private Server (VPS) on digitalocean.com, linking my existing domain DNS from godaddy.com to this newly setup VPS. Installing nginx webserver, WordPress and MySql database was a great experience and…

…watching the website coming up step by step was amazing.

I worked on a couple of web applications in the early 2000s using Java/JSP technologies. Back then development, testing, deployment etc., were pretty much manual steps.

WordPress and its plugins are great, to be precise made web development so easy for anyone.

At the same time, the beauty is that WordPress is so flexible for a professional to customize the website as needed using PHP and available plugins.

Conclusion

Though, I am a hardcore java professional, this first assignment made me a big fan of WordPress. And in general, web application development.