Hi Carlos, >From your trailing mail I noticed the below GRANT. This will just give 'cmennens'@'ideweb1.iamorlando.com' access to mysql but not any databases.
*Access to mysql:* | GRANT USAGE ON *.* TO 'cmennens'@'ideweb1.iamorlando.com' IDENTIFIED BY PASSWORD '****************' | In addition to the above, you need to give privileges to databases. I had given few examples below...check it. *Full Access to all Databases:* GRANT ALL PRIVILEGES ON *.* TO 'cmennens'@'ideweb1.iamorlando.com' *Full Access to a particular Database:(for e.g., "DB1")* GRANT ALL PRIVILEGES ON DB1.* TO 'cmennens'@'ideweb1.iamorlando.com' *SELECT Privilege to all Databases:* GRANT SELECT ON *.* TO 'cmennens'@'ideweb1.iamorlando.com' Regards, Jay MySQL DBA Datavail Corp. On Wed, Jul 14, 2010 at 6:21 PM, Carlos Mennens <carlosw...@gmail.com>wrote: > 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=jbhara...@gmail.com > >
