db privs

gistfile1.txt

https://github.com/mskyttner/specify-docker/blob/master/s6init.sql

example with multipled privileges:

create user if not exists 'xx'@'%' identified by 'xx';
create user if not exists 'yy'@'%' identified by 'yy';

grant select, insert, update, delete, lock tables, 
	alter, create, drop, 
	index, grant option on specify6.* 
	to 'yy'@'%';

grant reload on *.* to 'yy'@'%';

grant select, insert, update, delete, lock tables 
	on specify6.* to 'xx'@'%';

flush privileges;