system

dnf list kernel-devel
dnf -y install cockpit
dnf -y install htop 
dnf -y install glances
dnf -y install wget 
dnf -y install telnet 
dnf -y install firewall-config
dnf -y install gcc
dnf -y install sysstat
dnf -y install gnome-disk-utility
dnf -y install smartmontools
dnf -y install lshw
dnf -y install iotop
dnf -y install atop
dnf -y install iftop
dnf -y install fd-find
dnf -y install font-manager
dnf -y install caja caja-xattr-tags caja-open-terminal caja-image-converter caja-extensions-common.noarch caja-actions.x86_64 caja-actions-devel

servers

dnf list httpd
dnf list mariadb-server
dnf install php.x86_64 phpMyAdmin  php-bcmath.x86_64 php-gd.x86_64 php-geshi.noarch php-mbstring.x86_64 php-mcrypt.x86_64 php-pdo.x86_64 
dnf -y mycli

desktop

dnf -y install @kde
dnf -y install @cinnamon-desktop
dnf -y install @lxde-desktop
dnf -y install @lxqt-desktop
dnf -y install gnome-tweak-tool

software

dev

dnf -y install geany-plugins-spellcheck.x86_64 geany.x86_64 geany-plugins-geanyprj.x86_64 
dnf -y install R.x86_64 libxml2-devel mesa-libGL-devel mesa-libGLU-devel
dnf install texlive-framed texlive-titling
dnf install eclipse

office

dnf -y install libreoffice

multimedia

dnf -y install gimp.x86_64 inkscape.x86_64 krita

see also

rpm db pbs

first try

rpm --rebuilddb

else

rm -f /var/lib/rpm/* ; rpm --initdb