[01:15] <jo-erlend> Trying to setup a website on Ubuntu 20.04LTS. It used to be so easy, but now I can't even understand where to begin. I've installed the lamp-server task. In the past, it used to configure users and passwords, but it doesn't anymore. The Ubuntu help doesn't mention it at all and obviously searching leads to old info. Any hints?
[01:19] <mybalzitch> apache runs as a specific user, put your stuff in /var/www/html/ chown it to that user, bam, website
[01:20] <jo-erlend> mybalzitch, that's a great bam as long as you don't need a database, which I do. I am not able to find out how to set a root user password.
[01:21] <mybalzitch> why are you giving root a password
[01:21] <jo-erlend> You understand I'm talking about the mysql root user?
[01:21] <mybalzitch> https://www.digitalocean.com/community/tutorials/how-to-install-mariadb-on-ubuntu-20-04
[01:22] <mybalzitch> you understand thats the first result on google
[01:23] <jo-erlend> Yes, but it's 8 years old and it doesn't work.
[01:23] <mybalzitch> Last Validated onMay 12, 2020
[01:24] <mybalzitch> you ran sudo mysql_secure_installation ?
[01:24] <jo-erlend> No, I told you that I installed the lamp-server task on Ubuntu 20.04LTS.
[01:25] <mybalzitch> and those instructions are for 20.04
[01:25] <mybalzitch> for a mysql database server
[01:26] <mybalzitch> except everyone uses mariadb now, since oracle are jerks
[01:26] <CodeMouse92> SOME of us still use MySQL still...
[01:26] <CodeMouse92> Mainly because it's what the software we use requires.
[01:27] <mybalzitch> lol
[01:28] <jo-erlend> If this is a necessary step, I don't understand why Ubuntu help doesn't mention it at all.
[01:28] <mybalzitch>  It is intended to be a drop-in replacement for MySQL.
[01:29] <jo-erlend> I mean, it's not easy to guess that you must run "sudo mysql_secure_installation" after having installed MySQL.
[01:29] <leftyfb> jo-erlend: either way, mysql/mariadb both do not set a password for root and disable setting a password for root by default. This has been the case for multiple years now. Is there any particular reason you need to set a root password for mysql?
[01:31] <jo-erlend> leftyfb, probably only that I haven't used it in many years.
[01:32] <leftyfb> jo-erlend: setting up a public web server isn't meant to be a guessing game. You're meant to know what you're doing and/or learn to research current technologies and best practices. Otherwise, you'll just be contributing to the spam/bots/malware that is ravaging the internet at large
[01:33] <leftyfb> jo-erlend: Is there any particular reason you need to set a root password for mysql?
[01:34] <jo-erlend> leftyfb, well, I'm going to use phpmyadmin and I thought it would be useful for it to be allowed to do stuff.
[01:34] <leftyfb> jo-erlend: don't
[01:34] <jo-erlend> Don't what?
[01:35] <leftyfb> jo-erlend: don't poke more holes in your system with phpmyadmin. Learn to use the mysql client
[01:36] <jo-erlend> why should that be necessary for an offline system that only I will ever have access to?
[01:36] <leftyfb> jo-erlend: this machine won't be connected to the internet at all?
[01:36] <jo-erlend> No.
[01:37] <leftyfb> jo-erlend: then how will you receive security updates?
[01:37] <leftyfb> and bug fixes
[01:37] <jo-erlend> From my mirror.
[01:37] <leftyfb> jo-erlend: https://www.tecmint.com/disable-root-login-access-to-phpmyadmin/
[01:38] <jo-erlend> I'm really just experimenting, because I haven't done any of these things in years and many things have changed.
[01:40] <leftyfb> jo-erlend: lxd would be great for this then. Keeping it on the default network
[01:41] <jo-erlend> Yes, but my qemu+kvm setup is good enough.