LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-06-2006, 06:31 PM   #1
mihalisla
Member
 
Registered: Jun 2006
Location: greece
Distribution: ubuntu 6.06 amd64
Posts: 132

Rep: Reputation: 15
Unhappy Problem with MySQL


Hello, and goodmorning .I'm using suse 10 distro 64 -bit and when i type in terminal mysql i get the message that could not connect to local host database server.It also says that couldn't find sql.sock in some path it gives me.
1.Do Ineed to install extra packages???
2.Do i need to move files to some other location ???
3.i tryied to "locate" the sql.host but it didn't find anything what should i do?
the error : "ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/
mysql/mysql.sock' "

Thanx for reading this message

Last edited by mihalisla; 07-06-2006 at 06:57 PM.
 
Old 07-06-2006, 07:47 PM   #2
DrOzz
Senior Member
 
Registered: May 2003
Location: Sydney, Nova Scotia, Canada
Distribution: slackware
Posts: 4,185

Rep: Reputation: 59
did you start it yet, by typing :
Code:
mysqld
and then try connecting to by typing :
Code:
mysql
 
Old 07-06-2006, 08:03 PM   #3
mihalisla
Member
 
Registered: Jun 2006
Location: greece
Distribution: ubuntu 6.06 amd64
Posts: 132

Original Poster
Rep: Reputation: 15
Yes but nothing happened
 
Old 07-06-2006, 10:26 PM   #4
DrOzz
Senior Member
 
Registered: May 2003
Location: Sydney, Nova Scotia, Canada
Distribution: slackware
Posts: 4,185

Rep: Reputation: 59
what do you mean ? Did you get the same error when trying mysql after typing mysqld ?
 
Old 07-07-2006, 02:22 AM   #5
jstephens84
Senior Member
 
Registered: Sep 2004
Location: Nashville
Distribution: Manjaro, RHEL, CentOS
Posts: 2,098

Rep: Reputation: 102Reputation: 102
mysqld-safe --user=mysql should get it started.

Last edited by jstephens84; 07-07-2006 at 02:24 AM.
 
Old 07-07-2006, 04:47 PM   #6
mihalisla
Member
 
Registered: Jun 2006
Location: greece
Distribution: ubuntu 6.06 amd64
Posts: 132

Original Poster
Rep: Reputation: 15
No i couldn't do it.It gave me an error saying mysqld : false arguement "-%"
Now what can I do???
 
Old 07-07-2006, 06:05 PM   #7
jstephens84
Senior Member
 
Registered: Sep 2004
Location: Nashville
Distribution: Manjaro, RHEL, CentOS
Posts: 2,098

Rep: Reputation: 102Reputation: 102
Maybe it's mysql-safe --user=mysql.
 
Old 07-07-2006, 06:38 PM   #8
mihalisla
Member
 
Registered: Jun 2006
Location: greece
Distribution: ubuntu 6.06 amd64
Posts: 132

Original Poster
Rep: Reputation: 15
No it doesn't work weither.
Do u know how to check my sqld daemon if it's working and how to start it?
2.how can i make an empty file mysql.sock on suse 10 ???

P.S It takes me some time to log into linux and windows so as to gain access to internet (pctel modem u see) ,so forgive me for my delay to respond
thank you
 
Old 07-07-2006, 08:35 PM   #9
btmiller
Senior Member
 
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,284

Rep: Reputation: 371Reputation: 371Reputation: 371Reputation: 371
Can you do 'service mysqld start" (no quotes) and then connect?
 
Old 07-07-2006, 11:14 PM   #10
jstephens84
Senior Member
 
Registered: Sep 2004
Location: Nashville
Distribution: Manjaro, RHEL, CentOS
Posts: 2,098

Rep: Reputation: 102Reputation: 102
ps -ef or top both of these will show processes that are running. You do not need to create mysql.sock. When you start the service it will be created and when you stop the service mysql.sock will be destroyed.
 
Old 07-08-2006, 12:46 PM   #11
mihalisla
Member
 
Registered: Jun 2006
Location: greece
Distribution: ubuntu 6.06 amd64
Posts: 132

Original Poster
Rep: Reputation: 15
I tryied ps -ef and i didn't found mysql service or any daemon anywere.When i typed mysql start in suse it gave me the same error : "ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/
mysql/mysql.sock' "
How do i start a daemon and what packages are the standard needed for mysql????

Any opinions left ???
thank you for helping me with my problem

Last edited by mihalisla; 07-08-2006 at 12:50 PM.
 
Old 07-08-2006, 02:58 PM   #12
jstephens84
Senior Member
 
Registered: Sep 2004
Location: Nashville
Distribution: Manjaro, RHEL, CentOS
Posts: 2,098

Rep: Reputation: 102Reputation: 102
Could you post your mysql config file? Maybe it is something in their.
 
Old 07-08-2006, 03:01 PM   #13
btmiller
Senior Member
 
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,284

Rep: Reputation: 371Reputation: 371Reputation: 371Reputation: 371
It's "service mysqld start" not "mysql start". What this does is uses the initialization script /etc/init.d/mysqld to start the server. Perhaps there is something that this script needs to do before the daemon can start. In any case, I'd follow jstephens84's advice and post your config file -- that "false argument" error suggests that perhaps something is wrong with it.
 
Old 07-08-2006, 03:06 PM   #14
mihalisla
Member
 
Registered: Jun 2006
Location: greece
Distribution: ubuntu 6.06 amd64
Posts: 132

Original Poster
Rep: Reputation: 15
Where can I find this file???
By the way when i type service mysqld start it says service : unknown comamnd
 
Old 07-08-2006, 03:10 PM   #15
btmiller
Senior Member
 
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,284

Rep: Reputation: 371Reputation: 371Reputation: 371Reputation: 371
On my SuSE 9.3, service is in /sbin/service. Are you doing this as root? The /sbin directory should be in root's $PATH and you need to be root to start the daemon anyway. Try becoming root and typing /sbin/service mysqld start.

The config file is actually /etc/my.cnf -- at least on one of my systems.
 
  


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
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 01:42 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
php-mysql dependancy problem after nitemare mysql upgrade. RHEL4 andrewc Red Hat 1 01-03-2006 05:16 PM
MySQL server problem after linking (mysql.sock) ewijaya Linux - General 4 01-19-2004 10:46 AM
MySQL mysql-3.23.56-1.9, rpm install problem jacsmith510 Linux - Newbie 3 09-19-2003 03:02 PM


All times are GMT -5. The time now is 09:04 PM.

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