________________________________________________________________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/
Sir,
My name is Reji.Iam studying for a master degree in computer applications.Iam new
to mySQL.I don't know how to connect java with mySQL.Iam using home pc.Following are
the tools that iam using.
operating system :windowsXP
java :jdk1.3 on D:\jdk1.3
mySQL :ver 12.21 server version 4.0.14-nt for win95/98 (i32) on
c:\mysql
SSl :not in use
connection :local host via TCP/IP
tcp port :3306
MySQL control center :mysqlcc-0.9.2-win32 on F:\mysqlcc
connector/j :mysql-connector-java-3.0.8-stable on d:\jdk1.3\bin
(copied both com and org in another folder(comorg) and put
it in the bin folder of jdk
I have the following problems:
(1) I can't make a connection to mySQl through java.When I tried to run it,an error
is displayed as follows:
ClassNotFoundException:com.mysql.jdbc.Driver
SQLException : No suitable driver
(2) I can't change the user [EMAIL PROTECTED] I tried it using the grant option,
(GRANT ALL PRIVILEGES ON MYDATABASE.* TO REJI@'%' IDENTIFIED BY '' WITH GRANT
OPTION;), an error is displayed as follows:
ERROR 1044:Access denied for user:'@localhost' to database 'hhtransport'
When i tried it with the console manager(control center),the message
displayed is 'user created sucessfully'.But when I use mysql the same error(1044)
occurs.Please give me a solution to these problems.
Thanks
REJI.M.S
MUDUVILAKOM
THOTTAVARAM
ATTINGAL(PO)
TRIVANDRUM
KERALA
INDIA
PIN695101
EMAIL:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
