In my Mysql and Redhat 7.2,,
I can running following query commander at the test user prompt:
test$ mysql -D Message -e "select name from User"
the system dont't need me to input a user password running above command then it can query a record. But , the above command don't run in the shell that is be run in the test user env . the system output the error:
ERROR 1045: Access denied for user: 'test@localhost' (Using password: NO)
In shell like this:
NUMBER=mysql -D Message -e "select Fax from UserCorrespondence where UserID='$OWNER' and Active=1"
Why for above ??? please help me .
thinks .
