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@nic219 mysql-standard-5.0.20-linux-i686]# bin/mysqld_safe --skip-grant-tables &
[1] 4542
[root@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@lboro.ac.uk <A.L.M.Buxey@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