Why Freeradius and Mysql dont work?

[Dennis Skinner]

yao guoxian wrote:
> rlm_sql_mysql: Mysql error 'Host '202.117.7.243 <http://202.117.7.243>'
> is not allowed to connect to this MySQL server'

I assume this is a test server and is tightly controlled....

Login to MySQL as root on the command line.
Type this:

GRANT ALL ON *.* TO root at 202.117.7.243 IDENTIFIED BY 'mysql-root-pass';

That will let you do what you are trying to do.  Then go read the MySQL
documentation on server security.  You really should not be using the
root account.  Create a new user for radius queries and only give it the
access it needs.  Then REVOKE the rights I just had you GRANT above.

-- 
Dennis Skinner
Systems Administrator
BlueFrog Internet
http://www.bluefrog.com