MySQL Cheat Sheet: Helpful MySQL Commands For Handling Databases, Users, and Privileges

There are many commands in MySQL that web developers will use on a frequent basis. However, they do not use them often enough to have to commit them to memory. This is a list of MySQL commands I find myself using quite often.

Tutorial – After Installing MySQL on Ubutnu 18.04, Fix “Access denied for user ‘root’@’localhost'” Error

Recently, I came across an issue when installing mysql-server on Ubuntu 18.04. What I found is that after I installed mysql-server using my standard approach of sudo apt install mysql-server, and after running mysql_secure_installation, my root user was denied access to MySql when trying to access with mysql -u root -p. I would always get […]

Tutorial – How to Recursively Merge Two Objects In PHP

I was recently working on a project and found that I had to merge two very complex objects using PHP. I went to search for a solution and of course found array_merge() and array_merge_recursively(). So naturally, I thought I would start out by converting my objects into arrays and using array_merge_recursively.

Tutorial – Remove 301 Redirect from Browser Cache

As a web developer, it can become frustrating sometimes to deal with 301 redirects when developing website. For example, when using localhost, some of your projects might force SSL. In most cases, when forcing SSL, web servers will send a 301 response along with the redirect headers to point the browser back to https:// requests.

Tutorial – How To Convert an Image Into CMYK Using Gimp On Ubuntu

Gimp is a powerful image manipulation tool. It is very similar to Photoshop! If you have been using Gimp for any amount of time, you will already know its power. It an do most things that Photoshop is capable of. Compared to Photoshop, however, Gimp lacks some features that makes life so easy when you […]