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