On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar <aim.prab...@gmail.com> wrote: > GRANT ALL PRIVILEGES ON *.* TO username@'tuna.iamghost.com' IDENTIFIED BY > PASSWORD 'password'; > > *.* ie for all databases , if want on particular DB > > GRANT ALL PRIVILEGES ON MyDATABASE.* TO username@'tuna.iamghost.com' > IDENTIFIED BY PASSWORD 'password';;
Thank you! I checked to make sure I have the following account: mysql> select User, Host from user; +-----------+------------------------+ | User | Host | +-----------+------------------------+ | cmennens | ideweb1.iamorlando.com | | cmennens | localhost | | jmadeline | localhost | | mediawiki | localhost | | mrbs | localhost | | phpbb | localhost | | root | localhost | | roundcube | localhost | +-----------+------------------------+ 8 rows in set (0.00 sec) So from above I have a user 'cmennens'@'ideweb1.iamorlando.com' and now I verify I have access: mysql> SHOW GRANTS FOR 'cmennens'@'ideweb1.iamorlando.com'; +-----------------------------------------------------------------------------------------------------+ | Grants for cmenn...@ideweb1.iamorlando.com | +-----------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'cmennens'@'ideweb1.iamorlando.com' IDENTIFIED BY PASSWORD '****************' | +-----------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) So it would appear this user has grants or access, no? Am I missing something? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
