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 […]