LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Puppy
User Name
Password
Puppy This forum is for the discussion of Puppy Linux.

Notices

Reply
 
Search this Thread
Old 12-11-2010, 10:31 PM   #1
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 935

Rep: Reputation: 32
Can't connect to local MySQL server


hi all

Did a fresh install of PuPPY v5.1

downloaded the pet lamp

error i get is

Code:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
http://localhost/phpMyAdmin/index.php loads OK but cant not access it

any ideas please.

TT ( karl )
 
Old 12-11-2010, 10:39 PM   #2
AlucardZero
Senior Member
 
Registered: May 2006
Location: USA
Distribution: Debian
Posts: 4,610

Rep: Reputation: 518Reputation: 518Reputation: 518Reputation: 518Reputation: 518Reputation: 518
Is MySQL running?
 
Old 12-11-2010, 11:09 PM   #3
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 935

Original Poster
Rep: Reputation: 32
I dont know, how do I tell if its running..

TT ( karl )
 
Old 12-11-2010, 11:13 PM   #4
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 935

Original Poster
Rep: Reputation: 32
Quote:
# /etc/init.d/rc.mysqld start
# 101212 13:10:58 mysqld_safe Logging to '/usr/local/var/puppypc.err'.
101212 13:10:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/var
101212 13:10:58 mysqld_safe mysqld from pid file /usr/local/var/mysql.pid ended
Then it hangs

TT ( karl )
 
Old 12-11-2010, 11:16 PM   #5
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 935

Original Poster
Rep: Reputation: 32
The site I have been using is http://puppylinux.org/wikka/HiawathaServerMySQL

TT ( karl )
 
Old 12-11-2010, 11:25 PM   #6
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 935

Original Poster
Rep: Reputation: 32
hiawatha web server is up

php.info gives me

Code:
mysql

MySQL Support	enabled
Active Persistent Links 	0 
Active Links 	0 
Client API version 	5.1.35 
MYSQL_MODULE_TYPE 	external 
MYSQL_SOCKET 	/tmp 
MYSQL_INCLUDE 	-I/usr/local/include/mysql 
MYSQL_LIBS 	-L/usr/local/lib/mysql -lmysqlclient 

Directive	Local Value	Master Value
mysql.allow_persistent	On	On
mysql.connect_timeout	60	60
mysql.default_host	no value	no value
mysql.default_password	no value	no value
mysql.default_port	no value	no value
mysql.default_socket	/tmp/mysql.sock	/tmp/mysql.sock
mysql.default_user	nobody	nobody
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off
Directory tmp/mysql.sock is not there ???

TT ( karl )
 
Old 12-11-2010, 11:39 PM   #7
paulsm4
Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

1. Look at these two links:

http://www.murga-linux.com/puppy/viewtopic.php?t=5801

http://www.tech-recipes.com/rx/762/s...-tmpmysqlsock/

2. See if you have a file "/etc/my.conf"
If so, see if changing it to "socket=/var/lib/mysql/mysql.sock" works:
/etc/my.conf =>
Code:
EXAMPLE:
[mysqld]
datadir=/usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock
...
Hiawatha's a web server. MySQL's a database server. Hiawatha (and it's PHP module) use MySQL, but I suspect they're out of synch with your actual MySQL configuration.

'Hope that helps
 
Old 12-12-2010, 07:18 PM   #8
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 935

Original Poster
Rep: Reputation: 32
thanks for all the help

I found a better one webserver puppy

TT ( karl )
 
  


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
Frustration: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0 nidala Linux - Newbie 1 09-27-2008 11:20 PM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Software 3 06-28-2007 11:46 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM


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

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