I put this line (with no space after the -p) in the .bashrc file and sourced it;
alias mysql='mysql -u root -p"big_secret"' It gets me in ok. Van suggested the mysql way putting this in a .my.cnf file in my home directory. [client] user=username password=big_secret I know this is basic stuff, but I've got good help and a good book... thanks Paul DuBois wrote: > > At 14:30 -0800 2/21/02, 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. > > I don't see how it *could* work. When the password is given on the > command line, it must follow the -p with no intervening space. > > > > >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
