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