Thanks to all of you. <br> I can connect to MySQL using MySQL command-line program.<br> The problem seems having been resolved , yet not completely. I logined as super user "ygx" other than "root". And "FreeRADIUS гл MySQL" works again. I didnt make any other changes except editing
sql.conf to login as user "ygx".<br> The problem maybe exist in the table "user " of the database "mysql", which is as follow:<br><span style="color: rgb(255, 0, 0);">mysql> select Host,User,Password from user;
</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">+-------------------------------+--------+-----------------------------------------------------------------------------------+</span><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);">| Host | User | Password |</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">
+-------------------------------+--------+-----------------------------------------------------------------------------------+</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">| localhost | root | *639C78D0EC361EE7FBD5E7B2EE7D4356079DB335 |
</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">| <a href="http://202.117.54.251">202.117.54.251</a> | root | *639C78D0EC361EE7FBD5E7B2EE7D4356079DB335 |</span><br style="color: rgb(255, 0, 0);">
<span style="color: rgb(255, 0, 0);">| % | ygx | * 95FF347796503B19B351447515672881EB314534 |</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">| % | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
</span><br style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">+------------------------------+---------+-----------------------------------------------------------------------------------+</span><br style="color: rgb(255, 0, 0);">
Note that user 'root' has different Password .<br><br>Regards<br>Guoxian. <br><br><div><span class="gmail_quote">2007/5/15, Alan Dekok <<a href="mailto:aland@deployingradius.com">aland@deployingradius.com</a>
>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">yao guoxian wrote:<br>...<br>> rlm_sql_mysql: Couldn't connect socket to MySQL server
<br>> root@202.117.54.251:radius<br>> rlm_sql_mysql: Mysql error 'Access denied for user<br>> 'root'@'<a href="http://202.117.54.251">202.117.54.251</a>'<br><br> Can you connect from that IP to MySQL using the MySQL command-line
<br>program? If not, check the ACL's on the machine running MySQL.<br><br> Alan DeKok.<br>--<br> <a href="http://deployingradius.com">http://deployingradius.com</a> - The web site of the book<br> <a href="http://deployingradius.com/blog/">
http://deployingradius.com/blog/</a> - The blog<br>-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a><br></blockquote></div><br>