Web server
----------

dnf install httpd mariadb-server php phpMyAdmin

/etc/httpd/conf.d/userdir.conf
    # UserDir disabled
    UserDir public_html

    AllowOverride Indexes

systemctl restart httpd

chmod  go+rx $HOME
mkdir $HOME/public_html
echo 'Hello' > $HOME/public_html/index.html
echo 'Options +Indexes' > $HOME/public_html/.htaccess

firefox http://localhost/~zdenek


MySQL database
--------------

systemctl start mariadb

mysql -u root

   show databases;
   create database mydb;
   use mydb;

   show tables;
   create table colors (name varchar(80) not null primary key, red int, green int, blue int);
   insert into colors values ("blue", 0, 0, 255);
   select * from colors;
   describe colors;

   CREATE USER 'uzivatel'@'localhost' IDENTIFIED BY 'heslo';
   GRANT ALL ON mydb.* TO 'uzivatel'@'localhost';

mysql -u root < setup.sql

mysql -u uzivatel --password=heslo --database=mydb --table < ucebna-structure.sql

firefox http://localhost/phpMyAdmin