ERROR 1143

# ./mysqldump -uroot -p test > /data/test.sql
Enter password:
mysqldump: Couldn't execute 'SHOW FIELDS FROM `info`': SELECT command denied to user ''@'%' for column 'info1' in table 'status' (1143)

# ./mysql -uroot -p

mysql> SHOW FIELDS FROM info;
ERROR 1143 (42000): SELECT command denied to user ''@'%' for column ' info1' in table 'status'

mysql> select * from test.info limit 5;
ERROR 1449 (HY000): The user specified as a definer ('test'@'%') does not exist

 

-- 계정, host 생성 
CREATE USER 'test'@'%' IDENTIFIED BY 'test';
GRANT ALL PRIVILEGES ON *.* to 'test'@'%';

FLUSH PRIVILEGES;