Setting up MySQL

• apt install mysql-server

• mysql_{secureinstallation}

  • On ubuntu, mysql seems to always use auth_socket for root? So a password here makes no difference, even after running mysql_{secureinstallation}. https://serverfault.com/a/912963/25452

• https://dev.mysql.com/doc/refman/5.7/en/security.html