Checklist: install and configure MySQL in Ubuntu 18.04 LTS

  • Update the repository index: # apt-get update
  • Install the MySQL Server: # apt-get install mysql-server
  • Verify status and installation: # mysql –version
  • Secure local installation: # mysql_secure_installation (at the very least remove anymous access and sample stuff)
  • Start mysql shell: # sudo mysql
  • Verify authentication for root: > SELECT user,authentication_string,plugin,host FROM mysql.user;
  • If set to auth_socket, change to mysql passwords: > ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;
  • Reload the grant tables: > FLUSH PRIVILEGES;