List:General Discussion« Previous MessageNext Message »
From:Mikhail Berman Date:August 24 2006 2:19pm
Subject:RE: Allow other host
View as plain text  
Hi Andreas,

On the local host using mysql database. Execute the following command at
mysql prompt:

Mysql>grant all privileges on [database_name].* to 'user'@'remote_host'
identified by 'password'

Please read more about this at

http://dev.mysql.com/doc/refman/4.1/en/grant.html or whatever version of
MySQL you have.

Regards

Mikhail Berman

-----Original Message-----
From: news [mailto:news@stripped] On Behalf Of Andreas Moroder
Sent: Thursday, August 24, 2006 9:53 AM
To: mysql@stripped
Subject: Allow other host

Hello,

I have a mysql DB running on a Windows XP machine.
I can access it locally via mysql command, I have also a ODBC driver
installed and the test says it works ok.
When I try to connect from a remote host via JDBC I get the error
message that this host is not allowed to access the db.

How can I enable a external host to access this DB ?

It is possible to configure this from command line ?
( winmysqladmin is not working properly on this machine )

Thanks
Andreas


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

Thread
Allow other hostAndreas Moroder24 Aug
  • Re: Allow other hostjoao24 Aug
  • RE: Allow other hostMikhail Berman24 Aug