Re: Problem on creating root password

Hi Maciej,

[quote]
Try running mysqld_safe with additional
parameter: --log-error=/var/lib/mysql/my.err. Then check what has been
written into that file.[/quote]

[root@server ~]# kill `cat /var/run/mysqld/mysqld.pid`
No complaint

[root@server ~]# /etc/init.d/mysqld restart
Stopping MySQL:                                          [FAILED]
Starting MySQL:                                            [  OK  ]

# kill `cat /var/run/mysqld/mysqld.pid`
No complaint

[root@server ~]# /etc/init.d/mysqld status
mysqld dead but subsys locked
* end *

[root@server ~]# mysqld_safe --skip-grant-tables & --log-error=/var/lib/mysql/my.err
[1] 4579
bash: --log-error=/var/lib/mysql/my.err: No such file or directory
[root@server ~]# Starting mysqld daemon with databases from /var/lib/mysql

* end *
Hung here.

# find / -name my.err
find: /proc/4175/task: No such file or directory
/var/lib/mysql/my.err
find: /var/named/chroot/proc/4175/task: No such file or directory
* end *

# cat /var/lib/mysql/my.err
A mysqld process already exists at  Wed Mar 28 23:53:04 HKT 2007
070328 23:54:07  mysqld started
070328 23:54:07  InnoDB: Started; log sequence number 0 43634
/usr/libexec/mysqld: ready for connections.
Version: '4.1.20'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  So
urce distribution
070328 23:56:06 [Note] /usr/libexec/mysqld: Normal shutdown

070328 23:56:06  InnoDB: Starting shutdown...
070328 23:56:09  InnoDB: Shutdown completed; log sequence number 0 436
34
070328 23:56:09 [Note] /usr/libexec/mysqld: Shutdown complete

070328 23:56:09  mysqld ended
* end *


satimis