RE: -p password

rompt. 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 &

Re: -p password

>>alias mysql='mysql -u root -p"big_secret"' Another, more reliable way, is to use the long-form options and say mysql --user=root --password=big_secret -- Shankar. - Before posting, please check: http://www.mysql.com

Re: -p password

James Austin wrote: > > 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 > passwo

Re: -p password

y, 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 bein bash - edit your .bashrc file to incl

Re: -p password

shockingly enough it works like this: alias mysql='mysql -u username -p"password"' On Thu, 21 Feb 2002, 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 ha

Re: -p password

follow the -p with no intervening space. > >rc wrote: >> >> one way would bein bash - edit your .bashrc file to include the >> following: >> >> alias mysql='mysql -u username -p password' >> >> On Thu, 21 Feb 2002, James Austin wr

Re: -p password

ed in mysql, but hey, this > works. > > rc wrote: > > > > one way would bein bash - edit your .bashrc file to include the > > following: > > > > alias mysql='mysql -u username -p password' > > > > On Thu, 21 Feb 20

Re: -p password

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 bein bash - edit your .bashrc file to include the > following: > > alias mysql='mysql -u user

Re: -p password

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:

-p password

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 $&