unable to connect to mysql database

i am getting

java.sql.SQLException: General error: Access denied for user: '@192.168.0.104' to database 'Drishtee'

exception

i am using mmsql driver

although when i try to connect test database provided by mysql it gets connected

also when i try to connect to System database mysql i get

java.sql.SQLException: General error: Access denied for user: '@192.168.0.104' to database 'mysql'

someone please help me

thanks

[505 byte] By [parul_patidar] at [2007-9-26 6:45:03]

«« unable to connect to mysql
»» problems loading pages with java

# 1

Your problem is with the access rights in your database. From the error, it seems that the host you are connecting from was not granted access rights into the database. Chapter 6 of the mysql manual (which is browsable at www.mysql.com) has detailed procedures to follow in enabling such access rights.

For the record, I had a similar problem a while ago which I fixed by inserting the host's ip I was connecting from on the HOST table, added the host on the DB table.

Be sure to read chapter 6 of the manual as it is extremely detailed on this subject.

mbatha_98 at 2007-7-1 16:07:47 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

unable to connect to mysql database

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified