MySQL/MariaDB Basics (RHCE Certification Study)
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: https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/ (it’s a drop-in replacment).
##########################
Step-by-step, project-based Linux course for beginners: https://www.udemy.com/course/hands-on-linux-self-hosted-wordpress-for-linux-beginners/?referralCode=19C0A7DEE2FD53C9C09D
Free Linux Sysadmin Course Playlist: https://www.youtube.com/playlist?list=PLtK75qxsQaMLZSo7KL-PmiRarU7hrpnwK
DigitalOcean referral link: https://m.do.co/c/0380a1db56a6
Patreon: https://www.patreon.com/tutorialinux
Official Site & e-mail list: https://tutorialinux.com/
Twitter: https://twitter.com/tutorialinux
Facebook: https://www.facebook.com/tutorialinux
Podcast: http://kernelpanicpodcast.com
Comments are closed.