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 05-18-2004, 12:32 AM   #1
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Rep: Reputation: 32
Question MySQL on Tinysofa


Any one know why this is happening


root@localhost /bin# mysqladmin -u root password 'new_passsword'
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!
root@localhost /bin#


root@localhost ~# /etc/init.d/mysql status
No MySQL daemon pid file found. Looked for /var/lib/mysql/localhost.localdomain.pid.

root@localhost ~# /etc/init.d/mysql start
Starting MySQL daemon: [ OK ]
root@localhost ~#

I'm unsure what is happening do i need to reinstall mysql and how do i go about it please.

I followed what i did on my PC, but this PC i'm working on is 270km away from me..

TT
 
Old 05-18-2004, 01:35 AM   #2
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
Hi

I read most of the post about this error and i still get this error
I opened uo the port because this PC is 270km away from me.

root@localhost /bin# mysqladmin -u root password 'XXXXXXXX'
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql
.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' ex
ists!

root@localhost /var/run/mysql# ls
mysql.sock=

Code:
root@localhost /var/run/mysql# cd /usr/sbin/
root@localhost /usr/sbin# ls
ab*                    htmlinfo_update.sh*  postmap*       update-alternatives@
accton@                htpasswd*            postqueue*     updfstab*
adduser@               httpd*               postsuper*     useradd*
alternatives*          iconvconfig*         proftpd*       userdel*
apachectl*             in.proftpd@          pwck*          usermod*
authconfig*            kudzu*               pwconv*        vidmode@
checkgid*              locales-gen*         pwunconv*      vigr@
chpasswd*              logresolve*          ramsize@       vipw*
chroot*                logrotate*           rarpd*         xfs_admin*
clockdiff*             makewhatis*          rdev*          xfs_bmap*
create-cracklib-dict*  mkdict*              rdisc*         xfs_check*
dhcpd*                 module_upgrade*      readprofile*   xfs_copy*
dhcrelay*              mysqld*              rootflags@     xfs_db*
dump-acct*             netconfig*           rotatelogs*    xfs_freeze*
dump-utmp*             newaliases@          routef*        xfs_growfs*
envvars                newusers*            routel*        xfs_info*
envvars-std            packer*              rpcinfo*       xfs_io*
fcron*                 ping6*               rtacct*        xfs_logprint*
ftpshut*               pmap_dump*           sa*            xfs_mkfile*
glibc_post_upgrade*    pmap_set*            saslauthd*     xfs_ncheck*
groupadd*              postalias*           sendmail*      xfs_rtcp*
groupdel*              postcat*             sshd*          yppoll*
groupmod*              postconf*            suexec*        ypset*
grpck*                 postdrop*            sys-unconfig*  yptest*
grpconv*               postfix*             tmpwatch*      zdump*
grpunconv*             postkick*            tracepath*     zic*
htdbm*                 postlock*            tracepath6*
htdigest*              postlog*             tunelp*
root@localhost /usr/sbin# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)
root@localhost /usr/sbin# mysqld
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
040519  0:02:28  Aborting

040519  0:02:28  mysqld: Shutdown Complete

root@localhost /usr/sbin# chkconfig mysqld on
error reading information on service mysqld: No such file or directory
root@localhost /usr/sbin# /etc/init.d/mysqld start
-bash: /etc/init.d/mysqld: No such file or directory
root@localhost /usr/sbin#
I tried what the other post have said and i'm getting no where..


TT

Last edited by tommytomato; 05-18-2004 at 01:50 AM.
 
Old 05-18-2004, 05:04 AM   #3
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu
Posts: 1,532

Rep: Reputation: 132Reputation: 132
how did u start mysqld? it's not running at all it seems. check out
'locate safe_mysqld' or 'locate mysqld_safe' to find the wrapper that starts mysqld and try to start it with it.

Last edited by j-ray; 05-18-2004 at 05:07 AM.
 
Old 05-18-2004, 05:08 AM   #4
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
this is what i get now, i'm still trying to work it out, as i've been at this most of the day..

Code:
root@localhost ~# /etc/init.d/mysql restart
No MySQL daemon pid file found. Looked for /var/lib/mysql/localhost.localdomain.
pid.                                                       [FAILED]
Starting MySQL daemon:                                     [  OK  ]
root@localhost ~# /etc/init.d/mysql restart
No MySQL daemon pid file found. Looked for /var/lib/mysql/localhost.localdomain.
and when i went looking for localhost.localdomain.
pid. it's not there..

TT
 
Old 05-18-2004, 05:19 AM   #5
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
I even did this to see if i could understand whats going

Code:
root@localhost ~# ./mysqld --basedir=/usr/local --verbose --help
-bash: ./mysqld: No such file or directory
root@localhost ~# mysqladmin variables
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql
.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' ex
ists!
root@localhost ~# mysqladmin -h host_name variables
mysqladmin: connect to server at 'host_name' failed
error: 'Unknown MySQL Server Host 'host_name' (2)'
Check that mysqld is running on host_name and that the port is 3306.
You can check this by doing 'telnet host_name 3306'
So tried the telnet thing and got the following error.

Could not open connection to host, on port 3306

I know its there i added the IP and port to the dsl unit..

but as you can see i'm trying, and yer its hard

TT

Last edited by tommytomato; 05-18-2004 at 05:23 AM.
 
Old 05-18-2004, 11:52 AM   #6
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
Hi we still have this problem

We rebooted the OS and the install went find, how ever i was able to connect to mysql and change its root pass etc.

We restarted the pc and now we cant connect.

this is what we see ..I'm at a real lost to this. TT

Code:
root@localhost ~# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/m
ysql.sock' (111)
root@localhost ~# /etc/init.d/mysql status
Usage: /etc/init.d/mysql {start|stop|restart|status}
root@localhost ~# /etc/init.d/mysql status
No MySQL daemon pid file found. Looked for /var/lib/mysql/localhost.localdomain.
pid.

Last edited by tommytomato; 05-18-2004 at 11:55 AM.
 
  


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
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
Tinysofa apt-get IchBin Linux - Newbie 2 12-19-2004 03:26 PM
AWstats setup on tinysofa tommytomato Linux - Newbie 4 10-24-2004 01:45 PM
htaccess on TinySofa tommytomato Linux - Security 5 10-21-2004 09:07 AM
setup question tinysofa tommytomato Linux - General 0 05-15-2004 06:21 AM


All times are GMT -5. The time now is 02:51 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