Uploaded September 2017 | Updated September 2026, 2 weeks ago
The very basics of MariaDB (the MySQL fork used in RedHat certification exams). 99% of this also applies to 'regular' MySQL and non-RHEL Linux distributions.
0:30 Quick 3-minute intro to MySQL and MariaDB
2:50 Install MariaDB Package with yum
3:05 MariaDB service management under systemd
3:55 (usually not required) mysql_install_db script to initialize the database
4:50 secure your MySQL installation with the mysql_secure_installation script - ABSOLUTELY CRITICAL!
7:09 The main MariaDB logfile
7:38 The MariaDB unit file (for systemd service management)
9:10 The MySQL service TCP port
9:39 The main MySQL configuration file (/etc/my.cnf)
10:51 MySQL client basics (connecting to the MySQL service)
12:15 Basic MySQL shell commands (show databases, use a database, show mysql tables in a database)
13:27 Super-basic SELECT query, slow query log
RHCE Exam Extras:
14:27 - running mysql on a nonstandard port
15:46 - add a permanent firewall rule to allow the custom port
16:33 - update SELinux to allow mysqld_port_t to use that custom port
(restart mysql when you're done)
Notes on MySQL/MariaDB compatibility: mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility (it's a drop-in replacment).
##########################
Step-by-step, project-based Linux course for beginners: udemy.com/course/hands-on-linux-self-hosted-wordpress-for-linux-beginners/?referralCode=19C0A7DEE2FD53C9C09D
Free Linux Sysadmin Course Playlist: youtube.com/playlist?list=PLtK75qxsQaMLZSo7KL-PmiRarU7hrpnwK
DigitalOcean referral link: https://m.do.co/c/0380a1db56a6
Patreon: patreon.com/tutorialinux
Official Site & e-mail list: tutorialinux.com
Twitter: twitter.com/tutorialinux
Facebook: facebook.com/tutorialinux
Podcast: kernelpanicpodcast.com
The very basics of MariaDB (the MySQL fork used in RedHat certification exams). 99% of this also applies to 'regular' MySQL and non-RHEL Linux distributions.
0:30 Quick 3-minute intro to MySQL and MariaDB
2:50 Install MariaDB Package with yum
3:05 MariaDB service management under systemd
3:55 (usually not required) mysql_install_db script to initialize the database
4:50 secure your MySQL installation with the mysql_secure_installation script - ABSOLUTELY CRITICAL!
7:09 The main MariaDB logfile
7:38 The MariaDB unit file (for systemd service management)
9:10 The MySQL service TCP port
9:39 The main MySQL configuration file (/etc/my.cnf)
10:51 MySQL client basics (connecting to the MySQL service)
12:15 Basic MySQL shell commands (show databases, use a database, show mysql tables in a database)
13:27 Super-basic SELECT query, slow query log
RHCE Exam Extras:
14:27 - running mysql on a nonstandard port
15:46 - add a permanent firewall rule to allow the custom port
16:33 - update SELinux to allow mysqld_port_t to use that custom port
(restart mysql when you're done)
Notes on MySQL/MariaDB compatibility: mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility (it's a drop-in replacment).
##########################
Step-by-step, project-based Linux course for beginners: udemy.com/course/hands-on-linux-self-hosted-wordpress-for-linux-beginners/?referralCode=19C0A7DEE2FD53C9C09D
Free Linux Sysadmin Course Playlist: youtube.com/playlist?list=PLtK75qxsQaMLZSo7KL-PmiRarU7hrpnwK
DigitalOcean referral link: https://m.do.co/c/0380a1db56a6
Patreon: patreon.com/tutorialinux
Official Site & e-mail list: tutorialinux.com
Twitter: twitter.com/tutorialinux
Facebook: facebook.com/tutorialinux
Podcast: kernelpanicpodcast.com
