Kommandon

sudo service mysql restart

Skapa en ny user

grant all privileges on *.* to 'username'@'localhost' identified by 'password';

Databaser

create database sqlintro; show databases; use sqlintro

id int unsigned auto_ increment primary

TEST = NAME create table test (id int unsigned auto_increment, primary key (id)) engine=innodb; show tables; show test; select * from test; alter table test add body varchar(255) not null; describe test; alter table test add body varchar(255) notnull; insert into test (body) values ("Hope this works");