mysqladmin missing

2002-11-02 Thread aman mysql 
Hi
I downloaded the mysql in RPM format and installed on my RH Linux 7.3 box.
There is no mysqladmin, though there was no error. Do i need something else
or should i be downloading te tar-ball and installing that?
Aman

-
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

access MySQL server from remote windows m/c

2002-10-27 Thread aman mysql 
Hi all
How do I access a remote MySQL server (on LINUX platform), from a windows
application.
What drivers I need to download and from where?
How do I set permissions on the mysql server to let be accessed by the
remote windows machine.
Thanks alot
Aman

-
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

fetching specific date from datetime field

2002-10-09 Thread aman mysql 

Hi All

My mysql database is set up having a field cdate
- cdate datetime

has the format

-00-00 00:00:00

If I want to fetch rows for say the date 2000-12-19, I do it using perl
(it's a tediuos code)
Is there a way to do it using sql queries
Also how can I get betwee two specific date that I may mention.

Thanks
Sincerely
Aman

-
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

new user's login

2002-09-10 Thread aman mysql 

Hi
I added a new user in mysql using the following
mysqlinsert into user
values('localhost','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N','
N','N','N','N','N','Y','Y');
mysqlinsert into user
values('%','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N','N','N','
N','N','N','Y','Y');
mysqlFLUSH PRIVILEGES;

I am trying to connect from the shell by
shellmysql -p -u aman
Enter password:
ERROR 1045: Access denied for user: 'aman@localhost' (Using password: YES)

Why so?
Thank you
Aman

-
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