Yes, 202.117.7.243 is the MySQL server's IP.The problem is that I can not
login to MySQL on the command line.
The following is the input commands and output responses to them:
input command: ./bin/mysqld_safe --user=root
output results: Starting mysqld daemon with databases from
/home/ygx/mysql-standard-5.0.20-linux-i686/data
input command:./bin/mysql -u root -p
output results:Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
input command:./bin/mysql -u root
output results:Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.20-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Notice: the third input command is not with "-p".
I have done the following steps to reset user "root"'s password:
# killall -TERM mysqld
#./bin/mysql_safe --skip-grant-tables&
#./mysql -u root
>use mysql;
>update user set password=password('the-new-password') where
user='root';
>flush priviliges;
>quit;
But it didn't work. At first I could use #./bin/mysql_safe
--skip-grant-tables& and #./mysql -u root to enter into the command
line environmeng of mysql ,
while the two commands doesn't take effect now. The response to
#./bin/mysql_safe --skip-grant-tables& is like follows:
[EMAIL PROTECTED] mysql-standard-5.0.20-linux-i686]# bin/mysqld_safe
--skip-grant-tables &
[1] 4542
[EMAIL PROTECTED] mysql-standard-5.0.20-linux-i686]# Starting mysqld daemon with
databases from /home/ygx/mysql-standard-5.0.20-linux-i686 /data
STOPPING server from pid file /home/ygx/mysql-standard-5.0.20-linux-i686
/data/nic219.pid
070129 15:40:21 mysqld ended
2007/1/30, Dennis Skinner <[EMAIL PROTECTED]>:
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 [EMAIL PROTECTED] 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
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
