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 <carlosw...@gmail.com>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.prab...@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