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 <[EMAIL PROTECTED]> 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
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
