tags: #sql #mysql #admin #dbadmin
```sql
show databases; # list databases
describe mysql.user; # show schema for user database
select host, user from mysql.user; # list users
```
## Creating Users
```sql
create database db1;
grant all on db1.* to 'mrflibble'@'%' identified by 'hexvision';
```
## Trivial Example --- Key Value Store
```sql
create table data(id int auto_increment primary key, name varchar(128), data blob);
```
See SimpleKeyValueStore. Note that this isn't the best use of an [SQL](/aw/db/sql) database,
nor is such a database the best choice if all you want is a key-value store. But perhaps
you're in a position that [MySQL](HomePage) is all you have (e.g. if you are on a
shared web host that gives you a simple [LAMP stack](/aw/web/lamp)).