Confused about privileges
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 -- Ariste Software 200 D Street Ext Petaluma, CA 94952 (707) 773-4523 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Confused about privileges
Did you run the statement witht he mysql database as the current database? If so , you're statement probably got converted to this: grant all on mysql.* to todd identified by 'my_password' with grant option; It seems like a logical thing The grant statement applying to all databases/tables should be: *.* Chris Todd Cary 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Confused about privileges
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]
Re: Confused about privileges
Chris et al - The MySQL online manual does show *.* to be used for global priviledges, but my MySQL book only used the *. My mistake! However, the online manual does not indicate (or I am missing it) what the use of * grants. Thank you for the help...it is now working and my DB, sfyc does show in the table, db. Todd Chris wrote: Did you run the statement witht he mysql database as the current database? If so , you're statement probably got converted to this: grant all on mysql.* to todd identified by 'my_password' with grant option; It seems like a logical thing The grant statement applying to all databases/tables should be: *.* Chris Todd Cary 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 -- Ariste Software 200 D Street Ext Petaluma, CA 94952 (707) 773-4523 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
