drop database if exists lex; create database lex character set utf8 collate utf8_general_ci; use lex; create table lex ( -- id int not null auto_increment, source_code varchar(20), source_term varchar(255), target_code varchar(20), target_term varchar(255) -- primary key (id) ); grant all on lex.* to 'root'@'localhost';