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]
[EMAIL PROTECTED] ~]# kill `cat /var/run/mysqld/mysqld.pid` No complaint [EMAIL PROTECTED] ~]# /etc/init.d/mysqld restart Stopping MySQL: [FAILED] Starting MySQL: [ OK ] # kill `cat /var/run/mysqld/mysqld.pid` No complaint [EMAIL PROTECTED] ~]# /etc/init.d/mysqld status mysqld dead but subsys locked * end * [EMAIL PROTECTED] ~]# 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 [EMAIL PROTECTED] ~]# 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 -- View this message in context: http://www.nabble.com/Problem-on-creating-root-password-tf3479106.html#a9717062 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
