Tipps zu mySQL und MariaDB

Root-Passwort neu setzen

• Variante 1

  systemctl stop mariadb
  mysqld_safe --skip-grant-tables
  #... von weiterer Console aus: 
  mysql -u root
  MariaDB [(none)]> USE mysql;
  MariaDB [(none)]> UPDATE user SET password=PASSWORD('neues_passwort') WHERE User='root' AND Host = 'localhost';
  MariaDB [(none)]> FLUSH PRIVILEGES;
  MariaDB [(none)]> quit;
  # von erster Console aus:
  CTRL z
  systemctl start mariadb

• Variante 2

  systemctl stop mariadb
  systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
  systemctl start mariadb
  mysql -u root
  MariaDB [(none)]> USE mysql;
  MariaDB [(none)]> UPDATE user SET password=PASSWORD('neues_passwort') WHERE User='root' AND Host = 'localhost';
  MariaDB [(none)]> FLUSH PRIVILEGES;
  MariaDB [(none)]> quit;
  systemctl stop mariadb
  systemctl unset-environment MYSQLD_OPTS
  systemctl start mariadb

Tunnel für DB-Zugriff von Windows aus

plink.exe -v -pw geheim nutzername@1.2.3.4 -L 6603:localhost:3306