Hi there, the other comments may have got you where you want but as no one had mentioned your final option thought I'd mention (from /h at the mysql command line)
source (\.) Execute a SQL script file. Takes a file name as an argument. so you can run the script from the mysql prompt. cheers, noel On Friday, February 22, 2002 8:41 AM, James Austin [SMTP:[EMAIL PROTECTED]] wrote: > Hi all, > > A novice question: > > How can I do away with having to use the -u user and -p password > arguments every time I execute the mysql command? When I create a table > with a script the only way I can get it to work is with the command: > > $> mysql samp_db -u root -p < create_member.sql > $> Enter password: > > What can I do to not have to enter a user and password each time? Can I > use the script at the mysql prompt? This way I would only have to enter > the user and password once. > > Thanks very much, > Jim > > --------------------------------------------------------------------- > 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