Sql injection database

Datenbank anlegen

• create database sql_injections;

In die Datenbank wechseln

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