I’ve seen this question so many times. There are many tutorials out there explaining why we should be using mysql_ functions in PHP. I remember a time in PHP, when this was the only way to interact with your MySQL databases.
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.
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 […]