Re: Confused about privileges

[Gleb Paharenko]

Hello.


> grant all on * to todd identified by 'my_password' with grant option;

May be you wanted '*.*' instead of '*'? See:

 grant all on *.* to todd identified by 'my_password' with grant option;


> mysql -u todd -p sfyc

You should specify the database name not a table name ('sfyc' is a table
name). See:
  http://dev.mysql.com/doc/mysql/en/mysql.html

  
 


Todd Cary <todd@stripped> wrote:
> I have created a table, "sfyc" and as root I issued the following:
> 
> grant all on * to todd identified by 'my_password' with grant option;
> 
> However, "todd" cannot access "sfyc" with
> 
> mysql -u todd -p sfyc
> 
> And the mysql db contains the following:
> 
> user table
> +-----------+------+
> | host      | user |
> +-----------+------+
> | %         | todd |
> | linux     | root |
> | localhost | root |
> +-----------+------+
> 
> db table
> +------+---------+------+
> | host | db      | user |
> +------+---------+------+
> | %    | mysql   | todd |
> | %    | test    |      |
> | %    | test\_% |      |
> +------+---------+------+
> 
> tables_priv;
> +------+-------+------+------------+
> | host | db    | user | table_name |
> +------+-------+------+------------+
> | %    | mysql | todd | localhost  |
> +------+-------+------+------------+
> 
> If I issue the following command, no changes take place in the above tables:
> 
> grant all on sfyc to todd identified by 'my_password' with grant option;
> 
> Do I need to do an "insert SQL command" to specifically enter the 
> information?
> 
> Todd
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com