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
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)

##########################

[networkfreddy]

my guy sense of humor is priceless lmao *Subscribed

[kevinrickey]

Nice work and presentation! Thanks Man, happy Holidays, 4 years late.

[niklaswennerstrand]

You asked if someone would like to see more tutorials about MariaDB. My answer is that there are many tutorials on MySql and MariaDB but not so many tutorials about systemd. You have done a basics tutorial of systemd but I would like to see more about that subject.

[smurf___]

I love the commentary.

Fantastic videos man!

[powergm]

I was laughing the whole time :D thanks for this!

[kevindiazramirez]

9:41 "my.cnf"
Walked right into that one

[Vagelis_Prokopiou]

Nice video. Yes, a pure SQL video would be nice. And a Postgresql one even nicer.

[Lightbeerer]

You put the port in the wrong option group - it will have no effect in the mysqld_safe option group! The client-server option group is probably the best place for it. Also, any problems with losing data and data corruption are generally gone since InnoDB/XtraDB became the default storage engine, which happened in MariaDB 5.5. Other than that it was a fine video, and the remaining criticism is probably fair enough :)

[matthewexline]

I use Ubuntu on my personal laptop and decided I wanted to play with some database stuff again... I used to work with SQL Server on Windows machines once upon a time. I couldn't even figure out how to get MariaDB onto my machine at first lol. This tutorial worked for me... with some tweaking. I had to randomly use a lot of SUDO in order to get things to work properly from time to time, which worried me greatly. Figuring out that I had to use "apt-get" instead of the "yum" command to even initially start the download was kinda step one though lol.

[ChillerDragon]

Btw if you get stuck at the password of the secure script as I did make sure you execute it as root.

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

This is the error I got and prefixing the script with sudo solved it :)

[mikerollin]

On my Mariadb install on PopOS 21.10 I have /var/log/mysql rather than /var/log/mariadb. The naming convention of using mysql interchangeably with Mariadb is a bit confusing.

[dcorderoch]

thank you for the video, it's good to see someone actually using the mysql_secure_installation script before setting up the rest, and talking about the problems with mysql, rather than simply focusing on how to get to the SQL commands to prove that 'it works right after installing'
could you do this kind of video for postgresql? or if not, do you have any recommendations for books, blogs, or the like for setting up and using postgresql? for starters, something like the mysql_secure_install script, but for postgresql, I have read the documentation, and it is good, but it's kind of overwhelming, there's way too much information, but strangely not enough simple use case examples, I get that the point of that is probably that you have to get to know the thing to the point where you can get the most out of it, but it's kind of difficult to get to know it because the initial curve is so high (specifically the configuration in Linux)
also, are you familiar with certifications like the Cisco, RHCSA, COMPTIA, Linux Foundation, etc. which one would you recommend? (I'm still in college, and I thought getting one of those before, or around the time I graduate would be useful when job hunting)
thanks again for the videos!

[DavidThorarinsson]

Great intro to MySQL! Thanks, have questions though. Are MySQL and MariaDB fully compatible? If a product has been written for either one, will it work with the other? Trying to figure out where the differences lie - if you have an app that specifically states support for MySQL, and you are running CentOS/RHEL, should you simply go ahead and use MariaDB or should you go through the pain of installing MySQL?

[francesco]

It would be great to do a SQL video, or is there already one? really like your videos!

[aameen]

Can you show us how to install and setup PostgreSQL?
When I tried to install it, it was a nightmare. I had to use 'su -l postgres', add postgres to 'sudoers', modify 'postgresql.service', ...
YouTube videos on this topic are garbage and so is the official documentation on installation. Luckily there is a page for it on ArchWiki.
I'm still afraid of trying to install it again.

[shiv_kvsiva]

Please help to get more videos onmariadb galera, db administration etc

[nrzr]

Guys what you can tell about stability MariaDB vs Mysql ?

[soiralknarf]

Is getting the RHCSA difficult Dave? How long should I study for it?

[MercuryTheWhite]

so salty! lol very entertaining watch :)