Mysql Allgemein

MySQL

Install

 apt-get install mysql-server mysql-client

Login

 mysql -u root -p

Status prüfen

• mysql> status

Datenbanken anzeigen

• mysql> show databases;

Mysql verlassen

• mysql> exit

Root privilegieren

• 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;