Installing and configuring MySQL

- [Instructor] One of the common uses for a Lennox server…is to host a database.…There are all kind of database server packages…out there for different uses.…Graph databases like Neo4j,…NoSQL databases like Mongo…and traditional relational databases like MySQL…and even Microsoft Sequel Server.…In this video, I'll focus on setting up MySQL.…A very common backend for services like Wordpress…and other popular software.…To install the packages we need to support a MySQL server.…I'll run apt install mysql-server.…

Once that's installed, I'll run a tool called…mysql_secured_installation that comes with these packages.…To secure my server using some best practices.…I'll read the prompts that follow along here.…This will enable de validate password plug in…which allows us to set some standards for passwords.…Lets use strong passwords…and then we'll set a password…for the route user on the database.…We'll remove the anonymous users…and we'll disallow route log in remotely.…So to log in with a route user…we'll have to do it from this machine.…