Allowing Connections From Remote Clients

I am trying to connect to MySQL server [192.168.0.100] from my PC
[10.1.10.222] using MySQL Workbench and when I test the connection, I
get the following error:

"Host 'tuna.iamghost.com' is not allowed to connect to this MySQL server."

Can someone please tell me what I need to do so I can allow remote
connections to the database from the MySQL workbench application? I
have access to MySQL via CLI.

Thank you!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Allowing Connections From Remote Clients

--001485ea880c4a4ad6048b49d556
Content-Type: text/plain; charset=ISO-8859-1

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

On Wed, Jul 14, 2010 at 12:44 AM, Carlos Mennens wrote:

> I am trying to connect to MySQL server [192.168.0.100] from my PC
> [10.1.10.222] using MySQL Workbench and when I test the connection, I
> get the following error:
>
> "Host 'tuna.iamghost.com' is not allowed to connect to this MySQL server."
>
> Can someone please tell me what I need to do so I can allow remote
> connections to the database from the MySQL workbench application? I
> have access to MySQL via CLI.
>
> Thank you!
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prabhat@gmail.com
>
>


--
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--001485ea880c4a4ad6048b49d556--

Re: Allowing Connections From Remote Clients

On Tuesday, July 13, 2010 02:25:33 pm Prabhat Kumar 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';;
>

You also need to verify that you don't have network connections turned off in
/etc/my.cnf

if you have skip-networking, comment it out
also make sure that the bind-address is set to 192.168.0.100 and not to the
localhost ip addrerss.

One caution: the ip address you indicate appears to be one of the dynamically
assigned ones by a router. If so, it's possible that it will change. You might
want to switch to a static ip address for a server.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Allowing Connections From Remote Clients

The text of the error message means that this is not a possible cause; the =
error message given is coming from the mysql server itself after failed aut=
hentication -- in this case there's no matching user@host combination.


-----Original Message-----
From: Michael Satterwhite [mailto:michael@weblore.com]
Sent: Tuesday, July 13, 2010 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: Allowing Connections From Remote Clients

On Tuesday, July 13, 2010 02:25:33 pm Prabhat Kumar 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';;
>

You also need to verify that you don't have network connections turned off =
in
/etc/my.cnf

if you have skip-networking, comment it out
also make sure that the bind-address is set to 192.168.0.100 and not to the
localhost ip addrerss.

One caution: the ip address you indicate appears to be one of the dynamical=
ly
assigned ones by a router. If so, it's possible that it will change. You mi=
ght
want to switch to a static ip address for a server.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgtowey@ffn.com


This message contains confidential information and is intended only for the=
individual named. If you are not the named addressee, you are notified th=
at reviewing, disseminating, disclosing, copying or distributing this e-mai=
l is strictly prohibited. Please notify the sender immediately by e-mail i=
f you have received this e-mail by mistake and delete this e-mail from your=
system. E-mail transmission cannot be guaranteed to be secure or error-fre=
e as information could be intercepted, corrupted, lost, destroyed, arrive l=
ate or incomplete, or contain viruses. The sender therefore does not accept=
liability for any loss or damage caused by viruses or errors or omissions =
in the contents of this message, which arise as a result of e-mail transmis=
sion. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089,=
USA, FriendFinder.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Allowing Connections From Remote Clients

On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar wrot=
e:
> 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             =C2=
=A0|
| 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@ideweb1.iamorlando.com
                    =C2=
=A0         |
+----------------------------------------------------------- ---------------=
---------------------------+
| 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 somethi=
ng?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Allowing Connections From Remote Clients

Guys - I am no expert but I don't think this is a DNS or rDNS issue.
All resolution appears to be working fine. When my PC (tuna) attempts
to connect to the MySQL server via MySQL Workbench, it says "Failed to
Connect to MySQL at mysql.iamghost.com:3306 with user root
Host 'tuna.iamghost.com' is not allowed to connect to this MySQL
server. It resolves the correct name for the server and the client, I
just don't know how to allow my client (tuna) to be able to connect to
MySQL server.

Any thoughts?

I really want to connect to my database using this tool but I am
missing something. MySQL is rejecting incoming connections from my
host machine that I have WorkBench installed on. Please help.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Allowing Connections From Remote Clients

--002215048dc75b2981048c57299f
Content-Type: text/plain; charset=ISO-8859-1

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

> On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar
> 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@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=jbharathj@gmail.com
>
>

--002215048dc75b2981048c57299f--