If I understand correctly, you can achieve your goal in either of 2 ways. The first, is to copy sql.exe to one of your path directories (i.e. Windows or Windows\System) or include "MySQL\bin" in your DOS path statement. This will allow you to run mysql from a DOS prompt.
The second method is to download a copy of MyCC from the MySQL.com website. This program allows you access in a Windows environment. Good Luck! -----Original Message----- From: Loretta [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 10:24 PM To: [EMAIL PROTECTED] Subject: GRANT Hi. I am the only user of MySQL in a Win98 environment. I am developing an ASP front end to access the database to add, update and delete records in the database for a Church. I am having problems with the connection to the database. I am able to connect to the database and print out the fields in a table with no difficulty. However, I am not able to add any records let alone delete or update records through the front end. I believe my difficulty lies in the need to: grant select, insert, delete, create, drop on database.* to person@localhost identified by 'password'; The problem is in order to do this as per the manual I have to get the shell> prompt which I so far have not be able to do so that I can issue the following command: mysql --user = root mysql and then issue the grant command. Could someone please tell me how to get to the shell> prompt in a windows environment? I recognize shell> from my limited exposure to UNIX, but am not familiar with it in windows. I need to know which directory to go to do the required tasks. I have no problems getting into \mysql\bin to create databases and tables. Thank-you for any help. Loretta --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
