MySQL on Tinysofa

tommytomato · 05-17-2004, 11:32 PM

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

tommytomato · 05-18-2004, 12:35 AM

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

j-ray · 05-18-2004, 04:04 AM

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.

tommytomato · 05-18-2004, 04:08 AM

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

tommytomato · 05-18-2004, 04:19 AM

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

tommytomato · 05-18-2004, 10:52 AM

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.