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
