PHPMYADMIN Root reset

The latest version of PHPMYADMIN won’t allow root to login without a password, and you can only login to the phpmyadmin user.

Here’s how you work around it.

 

 

 

 

sudo mysql -u root

 

CREATE USER 'set-new-user'@'localhost' IDENTIFIED BY 'set-your-password';

GRANT ALL PRIVILEGES ON *.* TO 'your-suername'@'localhost';

FLUSH PRIVILEGES;

exit

sudo service service mysql restart

If that fails, try this:

 
sudo mysql -u root
use mysql;
update user set plugin='' where User='root';
flush privileges;
\q

Use 1GB of Raspberry Pi RAM as a SWAP drive

If you have little use for the 2GB of RAM in a Raspberry Pi, then you could always use 1GB of it for a SWAP drive, this should improve performance for anyone running their Pi on a SD card.

If you want to use a SSD or USB Drive then checkout my easy as Pi tutorials here: https://the-bionic-cyclist.co.uk/category/raspberry-pi-tutorials/

As usual this is a quick and easy setup:
install ZRAM

sudo wget -O /usr/bin/zram.sh https://raw.githubusercontent.com/ric96/zram_rpi3/master/zram.sh

Make it executable.

sudo chmod +x /usr/bin/zram.sh

Edit this file to run on startup

sudo nano /etc/rc.local add line before exit 0 /usr/bin/zram.sh &

Source: (always check before installing from any source) https://github.com/ric96/zram_rpi3

HTOP – Real time feedback from your Raspberry Pi

 

 

 

 

 

What is HTOP? Simply put, it’s a real-time feedback system to let you see what your Raspberry Pi is doing, what applications are running, and how much processing power is being used as well as where your RAM is being accessed and by what.

 

 

 

 

 

 

sudo apt-get install htop

It’s tiny and installs in seconds.

After that run htop by typing….

htop

 

Simples 🙂

Install Plex Server on a Raspberry Pi

Combine this with an SSD and even SSL to reap even more benefits https://the-bionic-cyclist.co.uk/raspberry-pi-tutorials/

 

 

Another easy tutorial from yours truly.

First the update:

Code: Select all

sudo apt-get update

Code: Select all

sudo apt-get upgrade

Now make sure HTTPS is installed

Code: Select all

sudo apt-get install apt-transport-https

Add a crypto key for the day2dev repository

Code: Select all

wget -O - https://dev2day.de/pms/dev2day-pms.gpg.key  | sudo apt-key add -

Now add the repository

Code: Select all

sudo nano /etc/apt/sources.list

or if that fails:

Code: Select all

sudo nano /etc/apt/sources.list.d/pms.list

add this line:

Code: Select all

deb http://dev2day.de/pms/ jessie main

update the repository list

Code: Select all

sudo apt-get update

Finally install Plex

Code: Select all

sudo apt-get install -t jessie plexmediaserver

Total time around 3 minutes

Now visit your server your rapberry pi’s IP and port 32400

Example: https://192.168.1.2:32400

Install Nextcloud cloud server on a Raspberry Pi

Nextcloud is a personal cloud server, you’re not relying on Apple cloud or Google or Dropbox to hold and secure (laughable) your data. If you have a Raspberry Pi at home you can host your own cloud server. There are desktop apps for Windows and Macs and apps for almost ALL mobile operating systems too.

The most popular self-hosted file share and collaboration platform

I’ve gone for the personal route because I find the free cloud server really don’t offer enough storage space, and security is a joke for most of them. Plus with the SSL guide you can make sure your is as secure as possible.

For easy reference:

Code:

sudo apt-get update

Code:

sudo apt-get install apache2

Code:

sudo apt-get install apache2 php7.0 php7.0-curl php7.0-gd php7.0-imap php7.0-json php7.0-mcrypt php7.0-mysql php7.0-opcache php7.0-xmlrpc libapache2-mod-php7.0

Code:

sudo service apache2 restart

Download link: https://download.nextcloud.com/server/releases/nextcloud-14.0.0.zip

Code:

sudo wget https://download.nextcloud.com/server/releases/nextcloud-11.0.2.zip

Code:

sudo mv nextcloud-11.0.2.zip /var/www/html

Code:

cd /var/www/html

Code:

sudo unzip -q nextcloud-11.0.2.zip

Make a folder for the data!!!

Code:

sudo mkdir -p /var/www/html/nextcloud/data

Code:

sudo chown www-data:www-data /var/www/html/nextcloud/data

Code:

sudo chmod 750 /var/www/html/nextcloud/data

Next, set the correct ownerships on Nextcloud “config” and “apps” directories:

Code:

cd /var/www/html/nextcloud

Code:

sudo chown www-data:www-data config apps

Create a Login for Nextcloud

In a browser, surf to your new Owncloud web page. Use the URL:
http://your Pis IP address/nextcloud

For example, the address of my Pi is 192.168.1.9. So I go the the URL: http://192.168.1.9/nextcloud

Increase upload size from 2mb

Code:

sudo nano /etc/php5/apache2/php.ini

Change these two lines:
post_max_size = 8M
upload_max_filesize = 2M
to:
post_max_size = 20M
upload_max_filesize = 20M

Code:

sudo service apache2 restart

Now setting up your own cloud isn’t good enough, you also need to secure all traffic and data, to encrypt the data on the drive use the plugin in the admin panel, for SSL use this tutorial.
Check domain and hostname

Code: Select all

domainname -b mysite.ddns.net

Code: Select all

sudo nano /etc/hostname

Make the domain name stick

Code: Select all

sudo nano /etc/sysctl.conf