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.
systemd is quite the moving target but I would like to see a comprehensive (so far) tutorial. Other than reading Lennart's BLOG and watching his presentations, and the RHEL portals I do not know of any really thorough sources. Well, OK Dave's awesome work here of course.
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 :)
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.
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.
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?
Ah, thanks for asking this -- I should have linked to this in the video: mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/ -- except in the gnarliest of edge cases, MariaDB is a drop-in replacement for MySQL. Just match up the version numbers and you're good to go.
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!
Postgres is awesome, I hope to do a series on that soon. The postgres manual is insanely good (and free!), but is a bit lacking in the step-by-step tutorial department. I'd recommend LPIC/Linux Foundation or RHCSA if you absolutely want to get a certification.
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 :)
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', ... UA-cam 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.
Yep, it can be a bit tricky (different distros and Unix OSs do the setup a bit differently), but once you know how it's straightforward. I've been getting a lot of requests for Postgres, so I'll try to start making some videos on that soon!
I don't have an RHCSA (or any certs, really -- just about 10yrs of working experience). I'm just slowly making videos that cover the core knowledge and practical skills covered on the test. Maybe someone else here can answer your question?
my guy sense of humor is priceless lmao *Subscribed
Nice work and presentation! Thanks Man, happy Holidays, 4 years late.
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.
systemd is quite the moving target but I would like to see a comprehensive (so far) tutorial. Other than reading Lennart's BLOG and watching his presentations, and the RHEL portals I do not know of any really thorough sources. Well, OK Dave's awesome work here of course.
I'm working on a 'basics of systemd' video/series right now. About to start another project so it might take a little while, though.
Take your time. Do it right. Appreciate your hard work.
9:41 "my.cnf"
Walked right into that one
I love the commentary.
Fantastic videos man!
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 :)
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.
I was laughing the whole time :D thanks for this!
Nice video. Yes, a pure SQL video would be nice. And a Postgresql one even nicer.
I definitely prefer postgres -- will try to make some Postgres videos soon!
tutoriaLinux Cool! Be good man.
Yes! Thanks Dave! You came through again :)
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.
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?
Ah, thanks for asking this -- I should have linked to this in the video: mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/ -- except in the gnarliest of edge cases, MariaDB is a drop-in replacement for MySQL. Just match up the version numbers and you're good to go.
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!
Postgres is awesome, I hope to do a series on that soon. The postgres manual is insanely good (and free!), but is a bit lacking in the step-by-step tutorial department. I'd recommend LPIC/Linux Foundation or RHCSA if you absolutely want to get a certification.
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 :)
Please help to get more videos onmariadb galera,db administration etc
Guys what you can tell about stability MariaDB vs Mysql ?
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', ...
UA-cam 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.
Yep, it can be a bit tricky (different distros and Unix OSs do the setup a bit differently), but once you know how it's straightforward. I've been getting a lot of requests for Postgres, so I'll try to start making some videos on that soon!
Please do more mariadb videos
It would be great to do a SQL video, or is there already one? really like your videos!
great video! keep up the good work ;)
Is getting the RHCSA difficult Dave? How long should I study for it?
I don't have an RHCSA (or any certs, really -- just about 10yrs of working experience). I'm just slowly making videos that cover the core knowledge and practical skills covered on the test. Maybe someone else here can answer your question?
Thanks Dave
Thank you
+1 for sql as well.
so salty! lol very entertaining watch :)
Lol I love the sarcasm.
nice, i3.