[FIX] mysql_secure_installation not setting the root password
I recently helped my buddy move from Centos 7 to Ubuntu 18.04. In the process, we noticed one of his custom websites was a little messed up. It was throwing a lot of errors in regards to mysqli_connect getting a boolean value instead of the query. We found out this was due to a difference between MariaDB (Centos 7) and plain old MySQL (Ubuntu). So we fixed this by removing MySQL and installing MariaDB. However, there was something else wrong. No user could log in to the root account on MySQL using a password, they would get the old access denied for root@localhost error. …
Continue reading