shell 報錯'@'localhost' (using password: YES)'root

標籤：

 shell中寫了簡單的一段

energy.sh內容：

#!/bin/bashhost=127.0.0.1user=******passwd=******dbname=******tablename=device_value_300sct007p01_yearMONTH=$(date +%Y-%m)sqlstr="insert into device_value_300sct007p01_year (id,year,month,device_id,device_value_id,value,type) select replace(uuid(), ‘-‘, ‘‘),substring(month,1,4),month,device_id,device_value_id,sum(value),type from device_value_300sct007p01_month where month = ${MONTH} group by month,device_id,device_value_id"mysql -h $host -u$user -p$passwd -D $dbname -e ‘select * from device_value_300sct007p01_year‘

最簡單的一個查詢，就是報錯‘@‘localhost‘ (using password: YES)‘root ，使用者名稱密碼都正確
最後發現原因：多了\r，指令碼是在windows下寫的，由於windows和linux分行符號不一致導致

sh  -x energy.sh   

+ host=$‘127.0.0.1\r‘+ user=$‘******\r‘+ passwd=$‘******\r‘+ dbname=$‘******\r‘+ tablename=$‘device_value_300sct007p01_year\r‘++ date +%Y-%m+ MONTH=$‘2015-03\r‘+ sqlstr=‘insert into device_value_300sct007p01_year (id,year,month,device_id,device_value_id,value,type) select replace(uuid(), ‘\‘‘-‘\‘‘, ‘\‘‘‘\‘‘),substring(month,1,4),month,device_id,devi‘group by month,device_id,device_value_idalue_300sct007p01_month where month = 2015-03++ -h $‘127.0.0.1\r‘ $‘-uroot\r‘ $‘-pyunho201311\r‘ -D $‘xcloud\r‘ -e ‘select * from device_value_300sct007p01_year‘energy.sh: line 9: -h: command not found+ mysql $‘\r‘ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: NO)

每個變數後都多了\r，導致使用者名稱密碼錯誤
解決方案：

刪除檔案中的\r

tr -d "\r" <energy.sh  >energy1.sh

再次運行

sh  energy1.sh

 

+----------------------------------+------+---------+--------------------+-----------------+-------+------+| id                               | year | month   | device_id          | device_value_id | value | type |+----------------------------------+------+---------+--------------------+-----------------+-------+------+| a9be43fcd5cfc6c3e7e07aac6fd20621 | 2015 | 2015-02 | 110000001000000031 |               1 |  2.00 | sum  || a9be43fcd5cfc6c3e7e07aac6fd20622 | 2015 | 2015-03 | 110000001000000031 |               1 |  3.00 | sum  || a9be43fcd5cfc6c3e7e07aac6fd20623 | 2015 | 2015-04 | 110000001000000031 |               1 |  4.00 | sum  || a9be43fcd5cfc6c3e7e07aac6fd20627 | 2015 | 2015-01 | 110000001000000031 |               1 |  1.00 | sum  |+----------------------------------+------+---------+--------------------+-----------------+-------+------+

 

shell 報錯'@'localhost' (using password: YES)'root