MYSQL commands for Jboss path settings

C:\Users>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N
O)

C:\Users>mysql -u root -p;
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)

C:\Users>mysql -u root -p
Enter password: *******


mysql> show grants for localhost;
ERROR 1141 (42000): There is no such grant defined for user 'localhost' on host
'%'
mysql> show grants for jbossapp@localhost;
GRANT USAGE ON *.* TO 'jbossapp'@'localhost' IDENTIFIED BY PASSWORD '748ccfd16
dfc5360'       |
| GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON `databasename(test)`.* TO 'jbossapp'@
'localhost'    |
| GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON `collection`.* TO 'jbossap
p'@'localhost' |

3 rows in set (0.04 sec)

mysql> grant select,update,delete,insert,references on test.* to jbossapp@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> show grants for jbossapp@localhost;

| GRANT USAGE ON *.* TO 'jbossapp'@'localhost' IDENTIFIED BY PASSWORD '748ccfd16
dfc5360'       |
| GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON `collection`.* TO 'jbossap
p'@'localhost' |
| GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON `acnmain`.* TO 'jbossapp'@
'localhost'    |
| GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON `acnhr`.* TO 'jbossapp'@'l
ocalhost'      |

4 rows in set (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)