Databases are commonly hosted on Linux servers. Learn how to install and secure MySQL in this video.
- [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.…
- Installing Ubuntu Server
- Configuring remote access with SSH
- Configuring the firewall
- Configuring networking with Netplan
- Managing users
- Configuring for scale
- Securing an HTTP server with TLS
- Hosting an application
- Setting up a forwarding DNS server
- Sending email with Postfix
Skill Level Beginner
Lab setup1m 26s
1. Ubuntu Server
2. Securing and Monitoring Your Server
3. Configuring and Managing the Server
4. Exploring Common Services
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.