LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Puppy (https://www.linuxquestions.org/questions/puppy-71/)
-   -   Can't connect to local MySQL server (https://www.linuxquestions.org/questions/puppy-71/cant-connect-to-local-mysql-server-849711/)

tommytomato 12-11-2010 10:31 PM
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 )

AlucardZero 12-11-2010 10:39 PM
Is MySQL running?

tommytomato 12-11-2010 11:09 PM
I dont know, how do I tell if its running..

TT ( karl )

tommytomato 12-11-2010 11:13 PM
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 )

tommytomato 12-11-2010 11:16 PM
The site I have been using is http://puppylinux.org/wikka/HiawathaServerMySQL

TT ( karl )

tommytomato 12-11-2010 11:25 PM
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 )

paulsm4 12-11-2010 11:39 PM
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

tommytomato 12-12-2010 07:18 PM
thanks for all the help

I found a better one webserver puppy

TT ( karl )


All times are GMT -5. The time now is 05:15 AM.