14 lines
308 B
SQL
14 lines
308 B
SQL
|
|
CREATE SCHEMA IF NOT EXISTS `floranet`;
|
|
|
|
CREATE ROLE IF NOT EXISTS 'floranet' ;
|
|
|
|
GRANT Create temporary tables ON floranet.* TO 'floranet';
|
|
|
|
GRANT Execute ON floranet.* TO 'floranet';
|
|
|
|
GRANT Lock tables ON floranet.* TO 'floranet';
|
|
|
|
CREATE USER IF NOT EXISTS 'floranet'@'%';
|
|
|
|
GRANT floranet TO floranet@'%'; |