mysql-continued-more
a blank table will contain: information_schema innodb mysql (tables with the users!)
CREATE /*!32302 TEMPORARY */ TABLE t (a INT);
Note that this is a comment that becomes an active statement in MySQL only, executed only by servers from MySQL 3.23.02 or higher.
if you use mysql dump on amazon rds
Users rdsadmin and rdsrepladmin are Amazon specific users...
You won't need to protect yourself against your own mysql when exported and import causes the error: ERROR 1465 (HY000) at line 2232: Triggers can not be created on system tables
-- /*!50003 CREATE*/ /*!50017 DEFINER=`rdsadmin`@`localhost`*/ /*!50003 trigger block_proc_d before delete on proc
-- for each row
-- BEGIN
-- DECLARE foo varchar(255);
-- if old.Definer = "rdsadmin@localhost" then
-- select CANNOT_DELETE_RDSADMIN_PROC into foo;
-- end if;
-- END */;;
-- /*!50003 CREATE*/ /*!50017 DEFINER=`rdsadmin`@`localhost`*/ /*!50003 trigger block_user_u before update on user
-- for each row
-- BEGIN
-- DECLARE foo varchar(255);
-- if old.User = "rdsadmin" then
-- select CANNOT_UPDATE_RDSADMIN_USER into foo from mysql.user;
-- end if;
-- if old.User = "rdsrepladmin" then
-- select CANNOT_UPDATE_RDSREPLADMIN_USER into foo from mysql.user;
-- end if;
-- if new.super_priv = 'Y' or
-- new.shutdown_priv = 'Y' or
-- new.file_priv = 'Y' or
-- new.repl_slave_priv = 'Y' then
-- select CANNOT_GRANT_PRIV into foo from mysql.user;
-- end if;
-- END */;;
| GRANT SELECT, INSERT, UPDATE, DELETE ON *.* TO 'USERNAME'@'%' IDENTIFIED BY PASSWORD '*D4A850A4D4A595881FAA40CE7B980F4ADA1C58DA' |