用mysql -utest -p123456 db_device 可以正常连接
mysql -utest -p123456 db_device<<EOF
LOAD DATA INFILE '/var/lib/mysql/db_device/20110427.csv'
INTO TABLE T_DEVICE_DATA
CHARACTER SET utf8 FIELDS TERMINATED BY ',' ENCLOSED BY '\"'
(VARIABLE_ID,VARIABLE_VALUE,QUALITY,COLLECTION_TIME,CREATE_TIME) ;
EOF
出现连接出错ERROR 1045 (28000) at line 1: Access denied for user 'device_root'@'%' (using password: YES)
求解
mysql -utest -p123456 db_device<<EOF
LOAD DATA INFILE '/var/lib/mysql/db_device/20110427.csv'
INTO TABLE T_DEVICE_DATA
CHARACTER SET utf8 FIELDS TERMINATED BY ',' ENCLOSED BY '\"'
(VARIABLE_ID,VARIABLE_VALUE,QUALITY,COLLECTION_TIME,CREATE_TIME) ;
EOF
出现连接出错ERROR 1045 (28000) at line 1: Access denied for user 'device_root'@'%' (using password: YES)
求解
解决方案 »
- mysql绿色版Access denied for user 'ODBC'@'localhost' (using password:NO)
- PostgreSQL Windows XP下安装时遇到的问题
- 请问怎样在my sql中存入字符"\"?
- asp和mysql一起好用吗?
- 求在RedHat7.3下一启动Linux就运行PostgreSql7.1的脚本
- max_allowed_packet 怎么修改?
- 好消息,最新版Mysql已经支持简单的事务处理了,免费而精美的午餐就要来了!
- 为什麽创建存储过程会报错
- 某条特定的语句,怎么知道一秒内能执行多少次
- 【列转行】把时间列里的每一天(2015-10-10 ),转成新的列名
- mysql配置小问题
- 怎么监控一个网站的后台postgreSQL
mysql -u -p -e"sql"
mysql -utest -p123456 db_device<'test.sql'