actually someone sent an email to the list suggesting using .my.cnf file, which is probably better than using the .bashrc file....
On Thu, 21 Feb 2002, James Austin wrote: > 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