Loretta wrote:
> 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
Loretta, hi I'm a 2000 user but this will work for you as well:
follow each step below:
- click start button
- click run
- type in "command" (without quotes) and hit OK
- at the DOS Prompt
- if not on the drive you have mysql installed (default is C:) then type
"[drive letter]:" (without quotes) and hit enter
- type "cd\mysql\bin" (without quotes) and hit enter
- type "mysql" (without quotes) and hit enter
if your mysql is up and running you will get the mysql prompt: mysql>
you're there.... should be able to enter your command to add yourself as a user
to your database.
tip in your autoexec.bat file add this line:
SET USER=[your username] where your username is the one assigned to the database.
this will make it
faster when you need to login to do database work.
example = SET USER=Loretta
Hope this helps.
Bruce A. Flinn
---------------------------------------------------------------------
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
