14 lines
308 B
MySQL
14 lines
308 B
MySQL
|
|
||
|
|
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@'%';
|