LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 02-19-2005, 04:09 AM   #1
compu73rg33k
Member
 
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316

Rep: Reputation: 30
mysql start problems.


I installed Slackware 10.1 and didn't do anything to mysql. When I ran /etc/rc.d/rc.mysql | start , I received this message

Code:
root@Suzzy:~# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
050219 03:05:16  mysqld ended
 
Old 02-19-2005, 04:14 AM   #2
reddazz
LQ Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 75
You need to switch to root using the "su" command, then switch to the "mysql" user using the same command then run "mysql_install_db".
 
Old 02-19-2005, 04:16 AM   #3
Artanicus
Member
 
Registered: Jan 2005
Location: Finland
Distribution: Ubuntu, Debian, Gentoo, Slackware
Posts: 827

Rep: Reputation: 31
I quess the typos were just typos, and you actualy meant:
/etc/rc.d/rc.mysqld start
?

Anyways, It seems something goes wrong with the startup.. (doh) You realy should set a root password fpr mysqld before using it.. After that, it worked for me just great.

Another thing, I did a few tests, and I get the exactly same output that you had if I allready have mysqld running and attempt to start it again.. So, make sure it isnt running allready.. (;
 
Old 02-19-2005, 04:47 AM   #4
compu73rg33k
Member
 
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316

Original Poster
Rep: Reputation: 30
Yeah I stopped it and tried starting it and that's what I got.

How do I switch to the user mysql while as root?

Last edited by compu73rg33k; 02-19-2005 at 04:49 AM.
 
Old 02-19-2005, 05:56 AM   #5
reddazz
LQ Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 75
#su mysql
 
Old 02-20-2005, 03:02 PM   #6
compu73rg33k
Member
 
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316

Original Poster
Rep: Reputation: 30
Okay ran the mysql_install_db but I still am unable to start it.
 
Old 02-20-2005, 03:18 PM   #7
reddazz
LQ Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 75
Well, thats usually how I get it to work. Maybe do a google search and you may get some other helpful tips.
 
Old 02-27-2005, 09:49 PM   #8
compu73rg33k
Member
 
Registered: Feb 2004
Distribution: Ubuntu
Posts: 316

Original Poster
Rep: Reputation: 30
Alright well I still have this problem and I really need to get it resolved becuase I'm starting to learn PHP and such.

I did a tail -f /var/lib/msyql/Suzzy.err and I received
Code:
050227 20:41:55  mysqld started
050227 20:41:55 Can't start server : Bind on unix socket: No such file or directory
050227 20:41:55 Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ?
050227 20:41:55 Aborting

050227 20:41:55 /usr/libexec/mysqld: Shutdown Complete

050227 20:41:55  mysqld ended
 
  


Reply


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
Problems with MySQL on SuSE: Can't Connect (/var/lib/mysql/mysql.sock) neocookie Linux - Software 8 02-08-2008 12:48 AM
mysql start problems Ab3n Linux - Newbie 3 05-05-2005 02:20 AM
MySQL install and start problems tommytomato Fedora 4 09-07-2004 06:20 AM
MySql error 2002, Cannot start mysql djchris Linux - Software 5 04-13-2004 07:12 PM
MySQL server start up problems spectrumver1 Linux - Software 2 12-09-2003 08:56 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:04 AM.

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