Why Freeradius and Mysql dont work?
yao guoxian
yaoguoxian at gmail.com
Wed Jan 31 04:37:20 CET 2007
Where is the default config file and how to config it?
I copyed surpport-files/my-medium.cnf to /etc/my.medim.cnf and its
content is as follow:
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
user =root
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
Is anything wrong with it?
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:
[root at nic219 mysql-standard-5.0.20-linux-i686]# bin/mysqld_safe
--skip-grant-tables &
[1] 4542
[root at nic219 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/29, A.L.M.Buxey at lboro.ac.uk <A.L.M.Buxey at lboro.ac.uk>:
>
> Hi,
>
> > But i couldn't use " mysql -u root -p rootpass" to enter the command
> line
> > enviroment any longer. The output is :ERROR 1045 (28000): Access denied
> for
> > user 'root'@'localhost' (using password: YES). Seems strange,isnt?
> Anyway, I
> > might better re-install Mysql.
>
> not strange at all - does that default config file have a root exclude or
> a default password entry? have you installed or created the privileges
> table
> (check the mysql table for user/password/host entries)
>
> alan
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070131/b09409b6/attachment.html>
More information about the Freeradius-Users
mailing list