CREATE DATABASE `lyg_gnyy` CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_general_ci';

CREATE USER `lyg_gnyy`@`%` IDENTIFIED BY 'gnyy@ABCD1234';

GRANT Alter, Alter Routine, Create, Create Routine, Create Temporary Tables, Create View, Delete, Drop, Event, Execute, Grant Option, Index, Insert, Lock Tables, References, Select, Show View, Trigger, Update ON `lyg\_gnyy`.* TO `lyg_gnyy`@`%`;