Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 10-18-2007, 11:55 PM   #1
Registered: Mar 2005
Location: upstate ny
Posts: 42

Rep: Reputation: 15
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
Old 10-19-2007, 01:44 AM   #2
LQ Guru
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 678Reputation: 678Reputation: 678Reputation: 678Reputation: 678Reputation: 678
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.
Old 10-19-2007, 02:34 AM   #3
Senior Member
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,589

Rep: Reputation: 145Reputation: 145
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
Old 10-19-2007, 08:28 AM   #4
Registered: Mar 2005
Location: upstate ny
Posts: 42

Original Poster
Rep: Reputation: 15
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
Old 10-19-2007, 08:31 AM   #5
Registered: Mar 2005
Location: upstate ny
Posts: 42

Original Poster
Rep: Reputation: 15
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


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 03:13 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 04:35 PM
MySQL setup openSuSE 10.2, no super user? Enil8 Linux - Software 2 05-25-2007 10:03 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:01 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration