On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar <aim.prabhat@stripped> 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 cmennens@stripped
|
+-----------------------------------------------------------------------------------------------------+
| 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?
