List:General Discussion« Previous MessageNext Message »
From:Carlos Mennens Date:July 14 2010 12:51pm
Subject:Re: Allowing Connections From Remote Clients
View as plain text  
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?
Thread
Allowing Connections From Remote ClientsCarlos Mennens13 Jul
  • Re: Allowing Connections From Remote ClientsPrabhat Kumar13 Jul
    • Re: Allowing Connections From Remote ClientsMichael Satterwhite13 Jul
      • RE: Allowing Connections From Remote ClientsGavin Towey14 Jul
Re: Allowing Connections From Remote ClientsCarlos Mennens14 Jul
  • Re: Allowing Connections From Remote Clientsjayabharath27 Jul
Re: Allowing Connections From Remote ClientsCarlos Mennens26 Jul