List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 27 1999 2:33am
Subject:Re: damn root - why do you need to pee?
View as plain text  
At 10:25 PM -0500 8/26/99, Derek Sivers wrote:
>> >mysql> insert into user (host,user,password)
>> >       values('localhost','root',password('mypassword'));
>> >
>> I don't understand the question.  You've set the root account so that
>> it requires a password (in that final query above), and now you're wondering
>> why you need to specify a password when you connect as root?
>
>
>I was just following a tutorial.  What should I do?
>
>All the other "mysqladmin" commands, too, give me an error unless I go
>back and
>type them with a "-p" afterwards.
>
>I'm trying to follow some tutorials but they never mention the "-p" which
>makes
>me think I did something wrong in the inital setup.

No, it's just that it gets tiresome to write out all the options
every time.  It's assumed that once you set the password that you'll
have to specify it every time you connect as root thereafter.  That
is, it's normal to have to specify a password.  That's true for
root as well as every other account, since otherwise people that
you don't want to be able to connect can connect.

If you don't want to type it in every time, you might create a .my.cnf
file in your home directory and put this in it:

[client]
password=your-password-here

Make sure the file's not readable to anyone else, though:

	chmod 600 .my.cnf


--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
what is wrong with this?Denis Voitenko26 Aug
  • Re: what is wrong with this?Patrice Bulat26 Aug
  • RE: what is wrong with this?Brian Andrews26 Aug
RE: what is wrong with this?Darren L Sweeney26 Aug
  • BOOK (MySQL + mSQL) is *not* for dummiesDerek Sivers27 Aug
    • Re: BOOK (MySQL + mSQL) is *not* for dummiesDick Griffin27 Aug
      • Re: BOOK (MySQL + mSQL) is *not* for dummiesPaul DuBois27 Aug
        • Re: BOOK (MySQL + mSQL) is *not* for dummieskg27 Aug
          • OT Re: BOOK (MySQL + mSQL) is *not* for dummiesjohn27 Aug
            • Re: OT Re: BOOK (MySQL + mSQL) is *not* for dummiesPaul DuBois27 Aug
          • Re: OT Re: BOOK (MySQL + mSQL) is *not* for dummiesGarrick Staples27 Aug
        • Re: BOOK (MySQL + mSQL) is *not* for dummiesDick Griffin27 Aug
          • Re: BOOK (MySQL + mSQL) is *not* for dummiesDerek Sivers27 Aug
      • damn root - why do you need to pee?Derek Sivers27 Aug
        • Re: damn root - why do you need to pee?Paul DuBois27 Aug
          • Re: damn root - why do you need to pee?Derek Sivers27 Aug
            • Re: damn root - why do you need to pee?Paul DuBois27 Aug
              • 0 rows affectedDerek Sivers27 Aug
                • 0 rows affectedJani Tolonen27 Aug
                • 0 rows affectedsinisa27 Aug
    • Re: BOOK (MySQL + mSQL) is *not* for dummieskg27 Aug
    • Re: BOOK (MySQL + mSQL) is *not* for dummiesWayne Topa27 Aug
  • RE: what is wrong with this?Steve Edberg27 Aug
    • RE: what is wrong with this?Paul DuBois27 Aug
  • Re: BOOK (MySQL + mSQL) is *not* for dummiesChris Shenton27 Aug