Mysql Allgemein

Install

 apt-get install mysql-server mysql-client

Zugriff von anderen Rechnern freischalten

• sed -i.org -e "/bind-address/s/^./#&/" /etc/mysql/mysql.conf.d/mysqld.cnf
• systemctl restart mysql.service

Login

Local

• mysql -u root -p

Remotehost

• mysql -h mysqlhostname -u root -p

Status prüfen

• mysql> status

Datenbanken anzeigen

• mysql> show databases;

Mysql verlassen

• mysql> exit

Root privilegieren von jedem Host

• mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'oimel';
• mysql> FLUSH PRIVILEGES;

Benutzer anlegen

• mysql> CREATE USER 'xinux'@'localhost' IDENTIFIED BY 'geheim';
• mysql> FLUSH PRIVILEGES;