List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 21 2002 10:42pm
Subject:Re: -p password
View as plain text  
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

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

-p passwordJames Austin21 Feb
  • Re: -p passwordVan21 Feb
Re: -p passwordJames Austin21 Feb
  • Re: -p passwordrc21 Feb
  • Re: -p passwordPaul DuBois21 Feb
Re: -p passwordrc21 Feb
Re: -p passwordJames Austin22 Feb
Re: -p passwordVan22 Feb
Re: -p passwordShankar Unni22 Feb
RE: -p passwordNoel Clarkson22 Feb