LinuxQuestions.org - MySQL on Tinysofa

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - MySQL on Tinysofa (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-on-tinysofa-182729/)

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

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 :newbie: :study:

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.

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

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

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

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 :study:

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.