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
