Category: DevOps

  • SSH to Siteground on Windows

    Step 1: Creating the key Create your SSH key in the Siteground panel. Give it a password and set a name for it. You can use the tutorial here: https://www.siteground.com/kb/access-site-ssh-connection/ You will need the ssh-add command which comes with the OpenSSH Authentication Agent Properties. To enable the agent, you need to open up the Services…

  • Get last inserted row ID from WordPress database using

    added after the insert query Source: https://stackoverflow.com/questions/1576018/how-to-get-last-inserted-row-id-from-wordpress-database

  • Fix XAMPP MySQL server shutdown unexpectedly

    IMPORTANT: do NOT delete ibdata1 file. You could destroy all your databases. Instead, first try using the MySQL backup folder which is included with XAMPP. So do next steps: Rename folder mysql/data to mysql/data_old Make a copy of mysql/backup folder and name it as mysql/data Copy all your database folders from mysql/data_old into mysql/data (except…

  • Configure LAMP on Ubuntu

    A very good tutorial can be found here: https://chabolla.dev/wamp-lamp-stack-install-on-windows/ and another one here: https://www.how2shout.com/how-to/how-to-install-apache-mysql-php-phpmyadmin-on-windows-10-wsl.html – don’t try them both at the same time, rather take them one at a time. However, if after following it, for some reason, mysql or phpmyadmin does not work, try one of the following fixes Very useful stuff 1. If,…