Mysql Allgemein: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Thomas (Diskussion | Beiträge) |
Thomas (Diskussion | Beiträge) |
||
| Zeile 1: | Zeile 1: | ||
| − | + | =Install= | |
| − | |||
apt-get install mysql-server mysql-client | apt-get install mysql-server mysql-client | ||
| − | + | =Login= | |
mysql -u root -p | mysql -u root -p | ||
| − | + | =Status prüfen= | |
*'''mysql>''' status | *'''mysql>''' status | ||
| − | + | =Datenbanken anzeigen= | |
*'''mysql>''' show databases; | *'''mysql>''' show databases; | ||
| − | + | =Mysql verlassen= | |
*'''mysql>''' exit | *'''mysql>''' exit | ||
| − | + | =Root privilegieren von jedem Host= | |
*'''mysql>''' GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'oimel'; | *'''mysql>''' GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'oimel'; | ||
*'''mysql>''' FLUSH PRIVILEGES; | *'''mysql>''' FLUSH PRIVILEGES; | ||
| − | + | =Benutzer anlegen= | |
*'''mysql>''' CREATE USER 'xinux'@'localhost' IDENTIFIED BY 'geheim'; | *'''mysql>''' CREATE USER 'xinux'@'localhost' IDENTIFIED BY 'geheim'; | ||
*'''mysql>''' FLUSH PRIVILEGES; | *'''mysql>''' FLUSH PRIVILEGES; | ||
Version vom 30. Mai 2017, 10:20 Uhr
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 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;