Yes. Thank you. Just put a pair of " around password and it works fine. I had thought this could be handled in mysql, but hey, this works. rc wrote: > > one way would be....in bash - edit your .bashrc file to include the > following: > > alias mysql='mysql -u username -p password' > > On Thu, 21 Feb 2002, James Austin 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