Re: What happened to my /tmp/mysql.sock ?!!??!

On Sat, May 27, 2023 at 8:04 PM Aryeh Friedman <aryeh.friedman@gmail.com>
wrote:

> On Sat, May 27, 2023 at 12:59 PM Odhiambo Washington <odhiambo@gmail.com>
> wrote:
> >
> >
> >
> > On Sat, May 27, 2023 at 7:44 PM Aryeh Friedman <aryeh.friedman@gmail.com>
> wrote:
> >>
> >> On Sat, May 27, 2023 at 12:22 PM Odhiambo Washington <
> odhiambo@gmail.com> wrote:
> >> >
> >> >
> >> >
> >> > On Sat, May 27, 2023 at 6:51 PM Aryeh Friedman <
> aryeh.friedman@gmail.com> wrote:
> >> >>
> >> >> I accidentally erased the above file and now no matter what I try
> >> >> (even a complete fresh install of the OS!?!?!) I can not get it
> made..
> >> >> It appears it comes prebroken actually due to manually attempt to
> >> >> start the service
> >> >>
> >> >> So the question is how on earth do I make this file... spent a while
> >> >> searching the web and fighting with chatGPT to no avail.
> >> >
> >> >
> >> > That file is created automatically when MySQL is started. It is a
> Unix socket.
> >> > You do not need a complete reinstall of the OS to solve this problem.
> >> > Just find out what is stopping MySQL service from starting.
> >> > You do not even need to reinstall MySQL!
> >>
> >> root@sarek1024:~ # ls /tmp/m*
> >> ls: No match.
> >> root@sarek1024:~ # service mysql-server onestart
> >> // modified rc.d file to echo command as well as do it
> >> /usr/local/bin/mysqld_safe --initialize
> >> --defaults-extra-file=/usr/local/etc/mysql/my.cnf --basedir=/usr/local
> >> --datadir=/var/db/mysql --mysqld-file=/usr/local/libexec/mysqld
> >> --user=mysql
> >> Starting mysql.
> >> root@sarek1024:~ # !ls
> >> ls /tmp/m*
> >> ls: No match.
> >> root@sarek1024:~ # mysql
> >> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> >> '/tmp/mysql.sock' (2)
> >> root@sarek1024:~ # tail -20 /var/log/messages
> >> May 27 05:32:01 sarek1024 pkg-static[82552]: libXScrnSaver-1.2.4
> installed
> >> May 27 05:32:09 sarek1024 pkg-static[88080]: tk86-8.6.13 installed
> >> May 27 05:34:47 sarek1024 pkg-static[99500]: shc-4.0.3 installed
> >> May 27 05:34:48 sarek1024 pkg-static[99839]: tk-wrapper-1.1_3 installed
> >> May 27 05:34:48 sarek1024 pkg-static[99963]: tkdiff-5.0 installed
> >> May 27 05:34:48 sarek1024 pkg-static[160]: aegis-4.25_14 installed
> >> May 27 05:35:00 sarek1024 pkg-static[5372]: gsed-4.9 installed
> >> May 27 05:35:59 sarek1024 pkg-static[81263]: lsof-4.97.0,8 installed
> >> May 27 05:36:00 sarek1024 pkg-static[81390]: libexplain-1.3.D012_6
> installed
> >> May 27 05:36:04 sarek1024 pkg-static[83063]: fhist-1.21_6 installed
> >> May 27 05:36:23 sarek1024 pkg-static[86662]: cook-2.30_3 installed
> >> May 27 05:36:24 sarek1024 pkg-static[87421]: log4j-1.2.17 installed
> >> May 27 05:36:24 sarek1024 pkg-static[87556]:
> >> mysql-connector-java51-5.1.49 installed
> >> May 27 07:18:39 sarek1024 su[87745]: aryeh to root on /dev/pts/0
> >> May 27 07:20:44 sarek1024 aryeh[88442]:
> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for
> >> mysql
> >> May 27 07:22:38 sarek1024 aryeh[88484]:
> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for
> >> mysql
> >> May 27 07:27:13 sarek1024 aryeh[88574]:
> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for
> >> mysql
> >> May 27 07:33:42 sarek1024 aryeh[89279]:
> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for
> >> mysql
> >> May 27 07:34:42 sarek1024 aryeh[89290]:
> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for
> >> mysql
> >> May 27 07:35:28 sarek1024 aryeh[89303]:
> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for
> >>
> >> mysql
> >
> >
> > cd  /var/db/mysql/
> >
> > less FQDN.err (FQDN = Fully Qualified Domain Name)
> > That file will tell you why msql is not able to start.
>
> No errors I can see
>

Really??????

[snip]

<quote>
2023-05-27T12:40:12.835631Z 0 [ERROR] Fatal error: Can't open and
lock privilege tables: Table 'mysql.user' doesn't exist
2023-05-27T12:40:12.835637Z 0 [ERROR] Fatal error: Failed to initialize
ACL/grant/time zones structures or failed to remove temporary table files.
2023-05-27T12:40:12.835752Z 0 [ERROR] Aborting
</quote>

Please completely uninstall Mysql and reinstall afresh and it will start.

Even better, install MariaDB :-)




-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
[How to ask smart questions:
http://www.catb.org/~esr/faqs/smart-questions.html]