(after re ------------------------------------------------------------ ------------- abort-slave-event-count 0 activate-all-roles-on-login FALSE admin-address (No default val admin-port 33062 admin-ssl TRUE admin-ssl-ca (No default val admin-ssl-capath (No default val admin-ssl-cert (No default val admin-ssl-cipher (No default val admin-ssl-crl (No default val admin-ssl-crlpath (No default val ... 21
Null Key Default Extra Host char(255) NO PRI User char(32) NO PRI Select_priv enum('N','Y') NO N Insert_priv enum('N','Y') NO N Update_priv enum('N','Y') NO N Delete_priv enum('N','Y') NO N Create_priv enum('N','Y') NO N Drop_priv enum('N','Y') NO N Reload_priv enum('N','Y') NO N ... 23
Extra Host char(255) NO PRI User char(32) NO PRI Proxied_host char(255) NO PRI Proxied_user char(32) NO PRI With_grant tinyint(1) NO 0 Grantor varchar(288) NO MUL 24
PRIVILEGES ON *.* TO 'test'@'%' WITH GRANT O GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROC ESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORA RY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CR EATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, T RIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `test`@`%` WIT H GRANT OPTION GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BIN LOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,GRO UP_REPLICATION_ADMIN,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PERSIS T_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_ GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SERVICE_CONNECTION_ADMIN,SESSIO N_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_AD MIN,TABLE_ENCRYPTION_ADMIN,XA_RECOVER_ADMIN ON *.* TO `test`@`%` WITH GRAN T OPTION 26
asked for help about help category: "Functions" For more information, type 'help <item>', where <item> is one of the follo wing categories: Aggregate Functions and Modifiers Bit Functions Cast Functions and Operators Comparison Operators Control Flow Functions Date and Time Functions ... mysql> help Aggregate Functions and Modifiers You asked for help about help category: "Aggregate Functions and Modifier s" For more information, type 'help <item>', where <item> is one of the follo wing topics: AVG BIT_AND BIT_OR BIT_XOR ... 27
using (help_category_i d) where c.name rlike "functions|operators|geometry (c onstructors|relations)|properties|mbr|wkt|wkb|xml|gti d" and c.name != "user-defined functions" and t.name not rlike "definition" 29