MySQL start problem

Fayble · 04-17-2006, 04:45 PM

I successfully installed RPM of mysql-server, mysql-client, mysql-shared on my Fedora Core 5.

Starting MySQL with: /etc/init.d/mysql start returns me FAILED.

So, I type: mysqld_safe &: MySQL is now up and running. I can now stop it. But, If I stop and try to restart MySQL fails back.

I've to start always by mysql_safe &!

What is wrong?

mailbinoy · 04-17-2006, 10:46 PM

can u post the output for the following commands
/etc/ini.d/mysql resrart
which safe_mysqld
does mysql prompt come up after u start mysql with safe_mysqld and run mysql

Fayble · 04-18-2006, 12:06 PM

This is the output:

Code:

[root@localhost ~]# mysqld_safe &
[1] 2959
[root@localhost ~]# Starting mysqld daemon with databases from /var/lib/mysql

[root@localhost ~]# /etc/init.d/mysql restart
Shutting down MySQL..STOPPING server from pid file /var/lib/mysql/localhost.localdomain.pid
060418 18:59:34  mysqld ended

                                                           [  OK  ]
Starting MySQL...................................          [FALLITO]
[1]+  Done                    mysqld_safe
[root@localhost ~]# mysqld_safe &
[1] 3127
[root@localhost ~]# Starting mysqld daemon with databases from /var/lib/mysql

[root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.20-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye
[root@localhost ~]#

Thanks for your help.

Harry Seldon · 04-18-2006, 01:16 PM

Have you checked /var/lib/mysql/mysqld.log for any specific error codes?

Fayble · 04-19-2006, 12:45 AM

Trying to start MySQL:

Code:

[root@localhost ~]# /etc/init.d/mysql start
Starting MySQL...................................          [FALLITO]
[root@localhost ~]#

And this is my last entry for /var/lib/mysql/localhost.localdomain.err:

Code:

060419 07:38:35  mysqld started
InnoDB: Error: pthread_create returned 13
060419 07:38:36  mysqld ended