init MySQL

create schema

create database demo character set utf8mb4 collate utf8mb4_general_ci;

rename schema

SELECT CONCAT('RENAME TABLE $1.', table_name, ' TO $2.', table_name, '; ')
FROM information_schema.TABLES 
WHERE table_schema='$1'

Change collation

ALTER DATABASE <database_name> 
	CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE <table_name> CONVERT TO 
	CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
	
ALTER TABLE <table_name> MODIFY <column_name> VARCHAR(255) 
	CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

add user

create user 'user_id'
    identified by '비밀번호';

grant select, show view on schema.* to 'user_id';

grant all privileges on schema.* TO 'user_id';

grant all privileges on `schema-name`.* TO 'user_id';

## revoke
revoke select, show view on schema.* FROM 'user_id';

alter password

//SET PASSWORD = PASSWORD(‘your_new_password’);
ALTER USER 'user_id' IDENTIFIED BY 'NEW_USER_PASSWORD';

FLUSH PRIVILEGES;

MySQL Error Code

1175

SET SQL_SAFE_UPDATES =0;

MySQL Lambda 함수 호출

https://docs.aws.amazon.com/ko_kr/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.Lambda.html

MySQL Export