linux  webserver  database

mariaDB / MySQL

Notizzettel!

# Apache muss installiert sein

"Maria DB installieren"

sudo apt-get install mariadb-client mariadb-server

sudo mysql_secure_installation
    Enter current password for root (enter for none): {Enter}
    Switch to unix_socket authentication [Y/n] y
    Change the root password? [Y/n] y
    Remove anonymous users? [Y/n] y
    Disallow root login remotely? [Y/n] y
    Remove test database and access to it? [Y/n] y
    Reload privilege tables now? [Y/n] <

sudo mariadb -u root -p
    USE mysql;
    UPDATE user SET plugin='mysql_native_password' WHERE User='root';
    FLUSH PRIVILEGES;
    exit;

sudo /etc/init.d/mariadb restart

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

"phpMyAdmin"

sudo apt-get install phpmyadmin
    TCP/IP
    127.0.0.0.1 ! WICHTIG
    3306

sudo nano /etc/apache2/apache2.conf
    Include /etc/phpmyadmin/apache.conf

sudo /etc/init.d/apache2 restart

#http:///phpmyadmin

"Neu Konfigurieren"
sudo dpkg-reconfigure phpmyadmin