List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 6 2001 11:09pm
Subject:Re: Does GRANT work in 3.23.33 ?
View as plain text  
>The docs say it's worked since 3.23.11, but:
>
>mysql> GRANT ALL PRIVILEGES ON *.* TO eventi@localhost;
>ERROR 2000: Access denied for user: 'root@localhost' (Using password: YES)
>mysql> select * from user where User='root';
>+------+------+----------+-------------+-------------+-------------+--------
>-----+-------------+-----------+-------------+---------------+--------------
>+-----------+
>| Host | User | Password | Select_priv | Insert_priv | Update_priv |
>Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv |
>Process_priv | File_priv |
>+------+------+----------+-------------+-------------+-------------+--------
>-----+-------------+-----------+-------------+---------------+--------------
>+-----------+
>| %    | root | ******** | Y           | Y           | Y           | Y
>| Y           | Y         | Y           | Y             | Y            | Y
>|
>+------+------+----------+-------------+-------------+-------------+--------
>-----+-------------+-----------+-------------+---------------+--------------
>+-----------+
>1 row in set (0.02 sec)
>
>mysql>


You're missing quite a few columns in your user table.  You should also
have Grant_priv, References_priv, Index_priv, and Alter_priv.

You may need to run "mysql_fix_privilege_tables root_password".
This is a shell script, have a look at it first to see what it does.
Thread
odbc connect for mysqlBernard-Olivier Clist6 Nov
  • Re: odbc connect for mysqlPeter Harvey6 Nov
    • Does GRANT work in 3.23.33 ?Eugene Ventimiglia6 Nov
      • Re: Does GRANT work in 3.23.33 ?Paul DuBois7 Nov