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:
[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/29, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
