Host not allowed to connect

[zeero]

Hi all, I have this problem when trying to connect to a database with the username "root" with a JSP file I wrote.

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

Sounds like a security/permission thing. Any ideas how to allow access?

Thanks

 

[KarveR]

Adding a user and associated privileges the hard way?)

from a command prompt:
#>mysql

At the 'mysql>' prompt:

use mysql;
insert into host values ("<hostname/ip>", "%", "Y", "Y", "Y", "Y", "Y","Y");
insert into user values ("<hostname/ip>", "<username>",
password("<password>"), "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y");

NOTE: The "Y" fields above define the privilages that the user or host has
to select/insert/drop/etc tables from the database. Please see the user &
host table headers if you need to change these.

*exit mysql by typing 'quit'*

For host/user/pass changes to take effect, you need to reload the MySQL
grant tables. To do this, type:
"mysqladmin reload" from the shell prompt.

If in doubt check the manual at

http://www.mysql.com

Rule No1 applies. You break it , you fix it.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[ericbrunson]

Wouldn't it be better to use the 'GRANT' command to do this? Coming from an Oracle background, this mysql mentatality of directly manipulating grant tables is highly disconcerting.

 

[KarveR]

probably ericbrunson, hence the note on the hardway(tm)

I guess its what you're used to.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[zeero]

How do I reload the MySQL grant tables under windows?

 

[ericbrunson]

mysql> FLUSH PRIVILEGES;

 

[KarveR]

mysqladmin reload" from the shell prompt.


______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.