How to install MySQL 8.0 on Ubuntu 18.04

  • The system under Ubuntu control 18.04
  • Access to user account with sudo privileges
  • Terminal window (ctrl-alt-T)
  • APT Package Manager (installed by default)

INSTALLING MYSQL ON UBUNTU

PASSWORD VERIFICATION PLUGIN

  • Low: passwords must be at least 8 characters long.
  • Medium (default): passwords must be upper case, lower case, 1 digit, and 1 special character.
  • Strong: compares a password to a dictionary file to prevent dictionary or brute-force attacks

CHANGE ROOT PASSWORD

CONFIGURE MYSQL SECURITY

  • Remove anonymous users?
  • Ban root from logging on remotely?
  • Delete the test database and access it?
  • Reboot the privilege tables now?

CONCLUSION

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Akademily

Akademily

We conduct reviews, guides and comparative tests of gaming laptops, monitors, graphics cards, keyboards, mouses, headsets and chairs to help you buy the best ga