IHK SQL Cheat Sheet (DRAFT) by sudoKnechtRootrecht

oda so:


CREATE USER 'dbot'@'%' IDENTIFIED BY '*';

GRANT USAGE ON . TO 'dbot'@'%' IDENTIFIED BY '*' WITH MAX_QU­ERI­ES_­PER­_HOUR 0 MAX_CO­NNE­CTI­ONS­_PE­R_HOUR 0 MAX_UP­DAT­ES_­PER­_HOUR 0 MAX_US­ER_­CON­NEC­TIONS 0 ;

CREATE DATABASE IF NOT EXISTS

dbot

;

GRANT ALL PRIVILEGES ON

dbot

. * TO 'dbot'­@'%';