List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 27 1999 2:17am
Subject:Re: damn root - why do you need to pee?
View as plain text  
At 10:02 PM -0500 8/26/99, Derek Sivers wrote:
>I can't do anything with root in MySQL without the "-p" !!
>
>Is it because I set up something wrong when I installed MySQL?
>Is it because I set the config to load MySQL automatically at bootup (on a
>home
>workstation Linux PC.)?
>
>Is there some big global variable I'm missing?
>I've been working with this manual and online tutorials for about 5 hours, and
>still can't do anything with it without typing "-p" and entering my password.
>
>(So I can't do any PHP calls from a web browser either.  It tells me..)
>Warning: MySQL Connection Failed: Access denied for user: 'root@localhost'
>(Using password: NO) in
>/usr/local/httpd/htdocs/musicthoughts/test/hot1.php3 on line 6
>
>I've done the commands:  (without any errors)
>
>mysql> insert into
>host(host,db,Select_priv,Insert_priv,Update_priv,
>Delete_priv,Create_priv,Drop_priv)
>       values('localhost','%','Y', 'Y', 'Y', 'Y', 'Y', 'Y');
>
>and:
>
>mysql> insert into
>host(host,db,Select_priv,Insert_priv,Update_priv,
>Delete_priv,Create_priv,Drop_priv)
>       values('derek', '%','Y', 'Y', 'Y', 'Y', 'Y', 'Y');
>
>and
>
>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?

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