To delete a paste from a Stikked installation that you have database access do the following:
Visit the post you like to delete: e.g http://example.com/stikked/htdocs/view/267c4d64
From this URI we need to get the part after view which is the pid (paste ID) of the paste you want to delete. In this case we get 267c4d64.
Then, you need to login to your MySQL DB. In case you are connecting via a terminal you would be using a similar command to this:
mysql -D MY_DB -h MY_HOST -u MY_USER -p
Replace MY_DB, MY_HOST and MY_USER with your credentials, afterwards you will be prompted for you password (if any).
Once in the MySQL console, issue the following:
DELETE FROM `pastes` WHERE `pid` = "267c4d64";
The above line will find the paste we want to delete and perform the deletion.
If you want to see the structure of the pastes table issue the following: SHOW COLUMNS FROM `pastes`;
A) Create a firewall rule in your VPC Network that allows you to connect to your database from outside the network: https://console.cloud.google.com/networking/firewalls/list B) From your remote machine repair your database using mysqlcheck. On Fedora you can install it by installing the MariaDB package as follows: sudo dnf install mariadb -y;…
Following you will find the commands to perform the installation of the LAMP stack (Apache, MySQL, PHP) and phpMyAdmin on a GNU/Linux CentOS 7. In this guide we kept the information to the bare minimum about what is what. Installation To perform the installation, please execute the following as a…
Recently a client got locked out of a MySQL deployment managed by a XAMPP. They requested us to reset the password for the root account. To do so, we followed the following procedure: Using a text editor, we opened the following file, which is the MySQL configuration file: C:\xampp\mysql\bin\my.ini We…
