Here is the command :
mysqladmin -u root -p password 'mysql'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
here is mysql.trace file:
......
get_charsets_dir: info: charsets dir='/opt/Pmysql/3.23.30g/share/mysql/charsets/'
get_charsets_dir: info: charsets dir='/opt/Pmysql/3.23.30g/share/mysql/charsets/'
server_init: general: IP Socket is 3306
server_init: general: UNIX Socket is /opt/Pmysql/3.23.30g/tmp/mysql.sock
server_init: info: server started
init_io_cache: info: init_io_cache: cachesize = 8192
open_table: info: inserting table 233110 into the cache
open_table: info: inserting table 233d20 into the cache
open_table: info: inserting table 102362b8 into the cache
mi_get_status: info: key_file: 1024 data_file: 0
mi_get_status: info: key_file: 2048 data_file: 428
mi_get_status: info: key_file: 3072 data_file: 302
init_read_record: info: using rr_sequential
init_io_cache: info: init_io_cache: cachesize = 16384
init_read_record: info: using rr_sequential
init_io_cache: info: init_io_cache: cachesize = 16384
init_read_record: info: using rr_sequential
init_io_cache: info: init_io_cache: cachesize = 16384
close_thread_tables: info: thd->open_tables=102362b8
~THD(): info: freeing host
open_table: info: inserting table 1023c710 into the cache
open_table: info: inserting table 233c68 into the cache
mi_get_status: info: key_file: 1024 data_file: 0
mi_get_status: info: key_file: 1024 data_file: 0
mi_rnext: error: Got error: -1, errno: 137
close_thread_tables: info: thd->open_tables=233c68
~THD(): info: freeing host
open_table: info: inserting table 1023c818 into the cache
init_read_record: info: using rr_sequential
init_io_cache: info: init_io_cache: cachesize = 8192
close_thread_tables: info: thd->open_tables=1023c818
~THD(): info: freeing host
handle_connections_sockets: general: Waiting for connections.
create_new_thread: info: creating thread 1
create_new_thread: info: Thread 1 created
?func: info: handle_one_connection called by thread 1
?func: info: check_connections called by thread 1
?func: general: New connection received on socket (8)
?func: general: Host: localhost
vio_read: error: Got error 11 during read
?func: info: vio_read returned -1, errno: 11
thr_alarm: info: reschedule
process_alarm: info: sig: 14 active alarms: 1
?func: general: Capabilities: 9357 packet_length: 0 Host: 'localhost' User: 'root'
Using password: no Access: 16383 db: '*none*'
mysql_change_db: general: Use database: mysql
vio_read: error: Got error 11 during read
do_command: info: vio_read returned -1, errno: 11
thr_alarm: info: reschedule
process_alarm: info: sig: 14 active alarms: 1
do_command: general: Command on socket (8) = 1 (Quit)
~THD(): info: freeing host
end_thread: info: Adding thread to cache
create_new_thread: info: Thread 2 created
?func: info: check_connections called by thread 2
?func: general: New connection received on socket (8)
?func: general: Host: localhost
vio_read: error: Got error 11 during read
?func: info: vio_read returned -1, errno: 11
thr_alarm: info: reschedule
process_alarm: info: sig: 14 active alarms: 1
?func: general: Capabilities: 8325 packet_length: 0 Host: 'localhost' User: 'root'
Using password: yes Access: 32768 db: '*none*'
~THD(): info: freeing host
end_thread: info: Adding thread to cache
process_alarm: info: sig: 14 active alarms: 0
~
Michel TIGNYEMB
FTeB
01 46 12 69 45
