Sql injection database: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
| Zeile 2: | Zeile 2: | ||
*create database sql_injections; | *create database sql_injections; | ||
=In die Datenbank wechseln= | =In die Datenbank wechseln= | ||
| − | * | + | *use sql_injections; |
| + | |||
=Tabelle anlegen= | =Tabelle anlegen= | ||
*create table users (id int(16), username varchar(16), password varchar(16)); | *create table users (id int(16), username varchar(16), password varchar(16)); | ||
Aktuelle Version vom 2. Juni 2021, 14:34 Uhr
Datenbank anlegen
- create database sql_injections;
In die Datenbank wechseln
- use sql_injections;
Tabelle anlegen
- create table users (id int(16), username varchar(16), password varchar(16));
Tabelle füllen
- insert into users values(1,"hans.will","geheim");
- insert into users values(2,"rudi.burkart","secret");
- insert into users values(3,"erwin.lehmann","weisniemand");
User anlegen und Rechte zuteilen
- use mysql;
- create user 'xinux'@'localhost' identified by 'suxer';
- grant all privileges on sql_injections.* to 'xinux'@'localhost' ;
- flush privileges;
- quit