Dear Santosh,
if you change the grant table entries (e. g. in mysql.user) manually,
you will have to execute
FLUSH PRIVILEGES
from the MySQL command line in order to tell the server to reload the
grant tables.
Granting privileges is better with the GRANT command, which will
automatically make the server reload the grant tables. Example:
GRANT ALL ON my_database.some_table TO "java_user"@"remote_address"
IDENTIFIED BY "my_password"
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "santosh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 10:07 AM
Subject: help please
Hai all,
I am using MySQL version 3.23.36 , i have a problem it would be great if
some body can help me out. The problem is:
I want to add the loginid and password to the server so that i can
connect to the mysql server and create tables programatically i.e. JAVA.
So what i have done is i have added the loginid ,password,hostname and
all permissions set to Y, in the table "user" of the "mysql"
database . But when i try to connect through a program it gives an error
as "Bad hand shake".
can anybody reply giving some assistence to this problem please.
Hoping for your early reply...
thanks in advance
santosh
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
