& looks nice Between One & Another :p
heh
& == send to background
&& == AND DO <whatever>
; == start next syntax string (like && just syntax's are executed one
after another instead of the same time)
curt wrote:
>
> Neil Curri wrote:
> >
> > > Check the manual (this is from that fine document)
> > > regarding the --skip-grant-tables option to allow
> > > access to the user table:
> >
> > It's a fine document indeed, I just did not specify -u root when logging
> > into mysql. Since mysqld was started without grants, I suppose mysql
> > does not automatically assume I am logging in as root (logged into
> > system as root)
>
> > ... what does the "&" do?
>
> Beats me. I'm sure someone will inform the both of us...
>
> >
> > > shell> ./bin/safe_mysqld --skip-grant-tables &
> > > shell> ./bin/mysql -u root mysql
> >
> > Lovely. Got into it from there, however:
> >
> > > # make adjustments to the user table using GRANT to add 'em
> >
> > Ok, here's the prob:
> >
> > mysql> grant all on *.* to root@localhost identified by "my_password"
> > with grant option;
> > ERROR 1047: Unknown command
> >
> > I'm checking the syntax, and I believe this is correct:
> >
> > grant all # grants all privileges
> >
> > on *.* # on all databases
> >
> > to root@localhost # to mysql root user (there are two
> > # entries for root in the mysql database,
> > # though.... root@localhost and
> > # root@stripped)
> >
> > identified by "my_password" # it's wierd, I can query the mysql db for
> > # root's password, but still won't let me in
> > # using that password - I can change it too.
> >
> > with grant option # that should allow root to assign grants
> > # for other mysql users
> >
> > So, first I just tried using the grant statement again, creating an
> > additional account to be the "superuser" of mysql:
> >
> > mysql> grant all on *.* to ncurri@localhost identified by "my_password"
> > with grant option;
> > ERROR 1047: Unknown command
> >
> > Ok, so perhaps I just never reloaded the grants when I originally made
> > changes to the user table (I did this by issuing update statements on
> > the mysql database rather than using grant statements), so I tried:
> > mysql> flush grants
>
> mysql> FLUSH PRIVILEGES; # not grants. maybe that was a typo, but...
>
> >
> > Then logged out and tried logging back into mysql again with:
> > mysql -u root -p
> >
> > and entering root's password - I know what it is, I had just been able
> > to query the user table for it - I'm still locked out. Furthermore, when
> > I try logging into mysql again without specifying -p, I again receive
> > the error message:
> >
> > ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> >
> > I suppose I might be able to log back in if I kill and restart mysqld
> > without grants again, but I've had to "-9" mysqld at least 5 times
> > today... argh. Thanks for the help, afraid I'm a bit of a problem child
> > today.
>
> Back to this again:
>
> shell> ./bin/safe_mysqld --skip-grant-tables &
> shell> ./bin/mysql -u root mysql
>
> What's the data from
>
> >mysql SELECT host,user,password FROM user;
>
> ?
>
> curt
>
> >
> > --
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/php/manual.php" before
> > posting. To request this thread, e-mail mysql-thread44514@stripped
> >
> > To unsubscribe, send a message to:
> > <mysql-unsubscribe-curtpdx=inetarena.com@stripped>
> >
> > If you have a broken mail client that cannot send a message to the above
> address(Microsoft Outlook), you can use http://lists.mysql.com/php/unsubscribe.php
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/php/manual.php" before
> posting. To request this thread, e-mail mysql-thread44517@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-cfaber=fpsn.net@stripped>
>
> If you have a broken mail client that cannot send a message to the above
> address(Microsoft Outlook), you can use http://lists.mysql.com/php/unsubscribe.php
