ramysqlinsert, rasql

[CS Lee]

hi guys,

Have anyone tried to insert or query mysql data to the db with username and
password using either rasql or rasqlinsert, it seems not working for
me(user without password is fine though) -

rasql -t -15s -r mysql://tester:12345678@localhost/argusdb/argustable
rasql[9069]: 21:04:01.674994 mysql_real_query error Access denied for user
'tester'@'localhost' to database 'argusdb'

rasql -t -15s -r mysql://tester@localhost/argusdb/tbl_argus
rasql[9080]: 21:05:02.903700 mysql_connect error Access denied for user
'tester'@'localhost' (using password: NO)

I have actually configured the user tester with password 12345678, and I
can login to the database using mysql client  -

mysql -u tester -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 177
Server version: 5.1.63-0ubuntu0.11.10.1 (Ubuntu)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> use argusdb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed


-- 
Best Regards,

CS Lee<geek00L[at]gmail.com>

http://geek00l.blogspot.com
http://defcraft.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20120614/a38e938a/attachment.html>