doubts

[abbas reji]

--0-599929911-1059996886=:4358
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Content-Id:
Content-Disposition: inline


__________________________________________________ ______________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/
--0-599929911-1059996886=:4358
Content-Type: text/plain; name="doubts.txt"
Content-Description: doubts.txt
Content-Disposition: inline; filename="doubts.txt"

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 OD**@localhost.When 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:ab*******@yahoo.com






--0-599929911-1059996886=:4358
Content-Type: text/plain; charset=us-ascii

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw
--0-599929911-1059996886=:4358--