Create MySQL Admin user

If you want to create a MySQL admin user that can connect from anywhere, feel free to tweak the string below: #create SQL Admin user CREATE USER ‘clusterAdmin’@’%’ IDENTIFIED BY ‘YOUR_cool_password_here’; GRANT ALL PRIVILEGES ON *.*...

Segmentation faulty tree

So i just came across this problem: as i was working with a Raspberry pi, i got the following message: “Segmentation faulty tree” as i was trying to install a few packages on my raspbian jessie. Luckily, it was a quick fix: sudo rm /var/cache/apt/*.bin apt...

Google Cloud Platform – FTP

So if you’re getting an error similar to this: “500 I won’t open a connection to 10.142.0.9 (only to…” if you’re trying to use FTP on a VM on Google Cloud, fear not, it’s an easy fix. You can do this 2 ways: 1 – FTP -p...

MySQL 5.7 – reset root password

So there’s been a change in the way you reset the MySQL root password in MySQL 5.7 as in the “password” field got removed, so the old way of resetting the password doesn’t work anymore: | authentication_string | text | YES | | NULL | | So...

Reset wordpress file/folder permissions

If you need a quick and easy fix for broken wordpress permissions – feel free to copy/paste the lines below. These will reset them to defaults. cd /your/wordpress/folder find . -type d -exec chmod 755 {} \; # Change directory permissions rwxr-xr-x find . -type f...