MYSQL 사용자 등록 쿼리

MYSQL 5.6 기준으로 사용자 등록하는 쿼리

DB명 : testdb

사용자명 : user

암호 : aaa

권한 : 관리자 권한

다른 DB에도 읽고 쓸 수 있는 권한.

create database testdb;
 
INSERT INTO user(host, user, password, Create_priv,Drop_priv,Lock_tables_priv,Alter_priv,Delete_priv,Index_priv,Insert_priv,Select_priv,Update_priv,Create_tmp_table_priv,Trigger_priv,Create_view_priv,Show_view_priv, Alter_routine_priv, Create_routine_priv, Execute_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, authentication_string)
VALUES('localhost', 'user', PASSWORD('aaa'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','')
 
INSERT INTO user(host, user, password, Create_priv,Drop_priv,Lock_tables_priv,Alter_priv,Delete_priv,Index_priv,Insert_priv,Select_priv,Update_priv,Create_tmp_table_priv,Trigger_priv,Create_view_priv,Show_view_priv, Alter_routine_priv, Create_routine_priv, Execute_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, authentication_string)
VALUES('%', 'user', PASSWORD('aaa'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','')
 
 
INSERT INTO db(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv,Alter_priv,Create_tmp_table_priv,Lock_tables_priv,Create_view_priv,Show_view_priv,Create_routine_priv,Alter_routine_priv,Execute_priv,Trigger_priv )
VALUES('localhhost', 'testdb', 'user','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
 
 
INSERT INTO db(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv,Alter_priv,Create_tmp_table_priv,Lock_tables_priv,Create_view_priv,Show_view_priv,Create_routine_priv,Alter_routine_priv,Execute_priv,Trigger_priv )
VALUES('%', 'testdb', 'user','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
 
flush privileges;

.