Hi everybody
I am just tired about this error, i don't know how to fix it....
I get the error:
java.sql.SQLException: null, message from server: "#HY000Host
'localhost.localdomain' is not allowed to connect to this MySQL server"
Part of the code is:
String url = "jdbc:mysql://localhost:3306/project";
db = DriverManager.getConnection(url, user, pass);
whenever i do:
mysql -h localhost -u anyone -p any
it works without any problem, but here... IT JUST DONT WORK !
thanks for your very precious help
Marcelo
Marcelo - 22 Nov 2005 20:42 GMT
I have forgotten to tell that I have already done the GRANT ALL ON
command for anyone@localhost....
thanks,
Marcelo
JScoobyCed - 23 Nov 2005 00:40 GMT
> I have forgotten to tell that I have already done the GRANT ALL ON
> command for anyone@localhost....
>
> thanks,
>
> Marcelo
That's the good thing to do, but did you grant all privileges to
anyone@localhost.localdomain
(not just localhost) ?

Signature
JSC
Marcelo - 23 Nov 2005 10:35 GMT
>> I have forgotten to tell that I have already done the GRANT ALL ON
>> command for anyone@localhost....
[quoted text clipped - 6 lines]
> anyone@localhost.localdomain
> (not just localhost) ?
yep, it works now, thanks