Re: mysqladmin missing

2002-11-02 Thread aman mysql
Thanks. If I have an old copy of Mysql on the system and want to uninstall that, how would I make sure that all the database associated should get deleted, or do I do it manually? Thanks Aman - Original Message - From: "Frederic Trudeau" <[EMAIL PROTECTED]> To: &quo

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 po

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

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

new user's login

2002-09-10 Thread aman mysql
Hi I added a new user in mysql using the following mysql>insert into user values('localhost','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N',' N','N','N','N','N','Y','Y'); mysql>insert into user values('%','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N','N','N',' N','N','N','Y','Y'