List:General Discussion« Previous MessageNext Message »
From:jayabharath Date:July 27 2010 4:44am
Subject:Re: Allowing Connections From Remote Clients
View as plain text  
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 <carloswill@stripped>wrote:

> 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?
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

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