Why Freeradius and Mysql dont work?

Dennis Skinner dskinner at bluefrog.com
Mon Jan 29 20:22:00 CET 2007

yao guoxian wrote:
> rlm_sql_mysql: Mysql error 'Host ' <>'
> 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 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

More information about the Freeradius-Users mailing list