LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 03-04-2009, 12:25 PM   #1
peteyperson
Member
 
Registered: Jan 2009
Distribution: openSUSE 11.1, with KDE 4
Posts: 71

Rep: Reputation: 16
MySQL 5.0.67: Unable to install & run. Error /var/lib/mysql/mysql.sock' (2)


Hi,

I have been unable to install MySQL 5.0.67 correctly. MySQL 5.1.31 also problematic.

Successfully ran 'mysql_install_db'.


You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

cd /usr ; /usr/bin/mysqld_safe &
[1] 21074
linux-qj5v:/usr # nohup: ignoring input and redirecting stderr to stdout
Starting mysqld-max daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/linux-qj5v.site.pid
090304 17:23:31 mysqld ended


I have tried running command: /usr/bin/mysql_secure_installation from Terminal in Root, and just 'mysql' in root.

'ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'

I've tried installing via a .tar.gz file instead. This doesn't generate the icons in the menu for Admin, db design & query tools, and also won't run.

I can find references to this problem in various Google entries, but not a solution that fixes the issue. Anyone have any advice?

Thanks,
Petey

Last edited by peteyperson; 03-04-2009 at 12:27 PM.
 
Old 03-04-2009, 01:46 PM   #2
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,106

Rep: Reputation: 805Reputation: 805Reputation: 805Reputation: 805Reputation: 805Reputation: 805Reputation: 805
Did you run mysql_install_db with the --user=mysql option? If you didn't, that's going to be a problem.

Also, look to see what's in /var/lib/mysql; the owner and group are mysql, set by mysql_install_db --user=mysql.
 
Old 03-04-2009, 02:16 PM   #3
peteyperson
Member
 
Registered: Jan 2009
Distribution: openSUSE 11.1, with KDE 4
Posts: 71

Original Poster
Rep: Reputation: 16
I stumbled on an article on Apache:
http://en.opensuse.org/Linux_Apache_...P_Server_(lamp)

This showed a way to get into Software > Software Mgmt in YAST Control, and then enable MySQL. Once done, Terminal could reach MySQL completely and I setup a secure install, removing test db and anon users.

I now have the SQL prompt and will play around and see if seems to functioning correctly. A Show databases; command listed:

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
+--------------------+
2 rows in set (0.00 sec)

That looked right.

Petey


Quote:
Originally Posted by tronayne View Post
Did you run mysql_install_db with the --user=mysql option? If you didn't, that's going to be a problem.

Also, look to see what's in /var/lib/mysql; the owner and group are mysql, set by mysql_install_db --user=mysql.
 
  


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
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock welery Linux - Software 19 03-06-2014 08:19 AM
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) Pode Slackware 12 11-26-2008 09:21 AM
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' mohadesz Linux - Server 3 03-15-2008 06:06 AM
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' mathimca05 Linux - Newbie 2 10-17-2007 03:04 AM
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) sunlinux Linux - Software 1 11-07-2006 01:08 AM


All times are GMT -5. The time now is 06:17 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration