MySQL on openSuse 10.3
 

Hello, I installed mysql with php via yast. When i type in service mysql start i get an error
Starting MySQL/etc/init.d/mysql: line 159: Kill: (10084) - no such process

If i try /etc/init.d.mysql start, i get the same message. If i go to that directory the mysql file is there. Does anyone know whats going on here? im lost

Are you certain that the the service isn't called mysqld instead of mysql. Anyway, you should use mysql-safe to manually start the mysql server.

Look in /usr/share/doc/mysql/ for manual.pdf or download the manual from the mysql website. ( A newer version may be called refman-<version>.pdf. Also read the startup script and see if it calls mysql-safe. Also refer to the mysql-safe man page.
Using mysql-safe is the preferred method of starting the mysql server, but an init startup script may either call it or incorporate it.

Did you previously have mysql-max installed. If so, you need to uninstall mysql-max first, otherwise the startup script may try to start the wrong program. ( See page 140 of the manual )

Even if the manual doesn't exist in /usr/share/doc/mysql/, there should be some notes. You may also want to have the service start at certain runlevels when you boot.
However, there are important instructions in the manual on setting passwords for the initial root account which doesn't have a password. It is very important to do this.

you can check whether it is already running with
ps -e | grep mysql

and if not start the server as su:

sudo /etc/init.d/mysql start

if it still gives errors take a look at /var/log/messages or /var/log/warn and post what you find there related to mysql

Thanks for the reply guys, Yes im sure that it is mysql. When i did mysqld it told no sure process. anyways i check the log like you said and i didnt see anything in there for mysql. There is a log file call mysql.log. When i check that, there was nothing in there for today. I uninstalled everything that connects with mysql and reinstalled it my self. Which i was avoding and the reason i did it with YAST. But in the end i get the same errors. So im going to try 1 more time to reinstall this. When i go to the systen service window and try to enable mysql like that, I end up getting a unspecified error. Do you think this could be a bug with mysql. This is version 5.0.45

Whatever, I just ran the start command again and it started. I didnt change anything, i post my last message and then tried it again, for grins and giggles and what do you know it start. What ever, thanks everyone for you help