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.…
Author
Released
8/29/2018- 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
Duration
Views
Related Courses
-
Introduction
-
Lab setup1m 26s
-
1. Ubuntu Server
-
Ubuntu Server1m 21s
-
Installing Ubuntu Server5m 27s
-
-
2. Securing and Monitoring Your Server
-
Configuring the firewall6m 41s
-
Exploring the logs2m 54s
-
Monitoring the server3m 9s
-
3. Configuring and Managing the Server
-
Service management3m 8s
-
Managing users4m 28s
-
Configuring for scale3m 24s
-
4. Exploring Common Services
-
Hosting an application1m 21s
-
LXD containers4m 50s
-
Working with snaps1m 59s
-
Conclusion
-
Juju, MAAS, and Landscape2m 23s
-
Next steps20s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Installing and configuring MySQL