``` -- mysql 创建只读帐户 CREATE USER `read_only_username`@`%` IDENTIFIED BY 'read_only_password'; GRANT Select ON `db_name`.* TO `read_only_username`@`%`; FLUSH PRIVILEGES; ```