Why Freeradius and Mysql dont work?
dskinner at bluefrog.com
Mon Jan 29 20:22:00 CET 2007
yao guoxian wrote:
> rlm_sql_mysql: Mysql error 'Host '18.104.22.168 <http://22.214.171.124>'
> 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.
GRANT ALL ON *.* TO root at 126.96.36.199 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.
More information about the Freeradius-Users