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
>
>
