From: Prabhat Kumar Date: July 13 2010 7:25pm Subject: Re: Allowing Connections From Remote Clients List-Archive: http://lists.mysql.com/mysql/222192 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=001485ea880c4a4ad6048b49d556 --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@stripped > > -- 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--