<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/4.6.6">
</HEAD>
<BODY>
<BR>
Hi Geoff!<BR>
<BR>
Follow-up to where I left off with the previous reply. Hope I'm following your instructions. <BR>
Basically copied what was in Terminal to a thumbdrive file and pasted here with some comments inserted. Looks like MySQL just wants to be extremely antisocial. (Sorry - have to make jokes because I'm frustrated- seems like sooooo close!)<BR>
<BR>
<BR>
<BR>
Following Geoff's suggestion (his #2):<BR>
<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chmod 777 /var/log > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/mkdir /var/log/mysql > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chmod -v 0777 /var/log/mysql > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chpwn -v mysql:mysql /var/log/mysql > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chown -v mysql:mysql /var/log/mysql > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/touch /var/log/mysql/mysql.log > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chown -v mysql:mysql /var/log/mysql/mysql.log > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chmod 777 /var/log/mysql/mysql.log > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ systemctl restart mysql.service<BR>
<BR>
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<BR>
<BR>
OK, so I'm not a touch-typist! (Error in line 4.) ...Reviewing this post. OK, the redirect end is for the batch file, script, whatever it should properly be called. I did type in as above originally and got these notes. What happens if I can see the output? Put that at the end. (Notes for the redo start at "REDO".)<BR>
<BR>
<BR>
<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ systemctl status mysql.service<BR>
● mysql.service - MySQL Community Server<BR>
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)<BR>
Active: activating (start-post) (Result: exit-code) since Wed 2016-07-13 16:48:53 CDT; 27s ago<BR>
Process: 27033 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)<BR>
Process: 27029 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)<BR>
Main PID: 27033 (code=exited, status=1/FAILURE); : 27034 (mysql-systemd-s)<BR>
CGroup: /system.slice/mysql.service<BR>
└─control<BR>
├─27034 /bin/bash /usr/share/mysql/mysql-systemd-start post<BR>
└─27116 sleep 1<BR>
<BR>
Jul 13 16:48:53 MythBE1 systemd[1]: Starting MySQL Community Server...<BR>
Jul 13 16:48:55 MythBE1 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<BR>
<BR>
<BR>
<BR>
<BR>
journalctl -xe -- last bunch of lines seemed o make soem sense to start at this point:<BR>
<BR>
-- Unit mysql.service has finished shutting down.<BR>
Jul 13 16:49:24 MythBE1 systemd[1]: Starting MySQL Community Server...<BR>
-- Subject: Unit mysql.service has begun start-up<BR>
-- Defined-By: systemd<BR>
-- Support: <A HREF="http://lists.freedesktop.org/mailman/listinfo/systemd-devel">http://lists.freedesktop.org/mailman/listinfo/systemd-devel</A><BR>
-- <BR>
-- Unit mysql.service has begun starting up.<BR>
Jul 13 16:49:26 MythBE1 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE<BR>
Jul 13 16:49:47 MythBE1 systemd[1]: Started CUPS Scheduler.<BR>
-- Subject: Unit cups.service has finished start-up<BR>
-- Defined-By: systemd<BR>
-- Support: <A HREF="http://lists.freedesktop.org/mailman/listinfo/systemd-devel">http://lists.freedesktop.org/mailman/listinfo/systemd-devel</A><BR>
-- <BR>
-- Unit cups.service has finished starting up.<BR>
-- <BR>
-- The start-up result is done.<BR>
Jul 13 16:49:54 MythBE1 systemd[1]: Failed to start MySQL Community Server.<BR>
-- Subject: Unit mysql.service has failed<BR>
-- Defined-By: systemd<BR>
-- Support: <A HREF="http://lists.freedesktop.org/mailman/listinfo/systemd-devel">http://lists.freedesktop.org/mailman/listinfo/systemd-devel</A><BR>
-- <BR>
-- Unit mysql.service has failed.<BR>
-- <BR>
-- The result is failed.<BR>
Jul 13 16:49:54 MythBE1 systemd[1]: mysql.service: Unit entered failed state.<BR>
Jul 13 16:49:54 MythBE1 systemd[1]: mysql.service: Failed with result 'exit-code'.<BR>
Jul 13 16:49:54 MythBE1 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.<BR>
Jul 13 16:49:54 MythBE1 systemd[1]: Stopped MySQL Community Server.<BR>
-- Subject: Unit mysql.service has finished shutting down<BR>
-- Defined-By: systemd<BR>
-- Support: <A HREF="http://lists.freedesktop.org/mailman/listinfo/systemd-devel">http://lists.freedesktop.org/mailman/listinfo/systemd-devel</A><BR>
-- <BR>
-- Unit mysql.service has finished shutting down.<BR>
Jul 13 16:49:54 MythBE1 systemd[1]: Starting MySQL Community Server...<BR>
-- Subject: Unit mysql.service has begun start-up<BR>
-- Defined-By: systemd<BR>
-- Support: <A HREF="http://lists.freedesktop.org/mailman/listinfo/systemd-devel">http://lists.freedesktop.org/mailman/listinfo/systemd-devel</A><BR>
-- <BR>
-- Unit mysql.service has begun starting up.<BR>
Jul 13 16:49:56 MythBE1 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE<BR>
<BR>
<BR>
<BR>
<BR>
----<BR>
<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ ExecStart=/usr/sbin/mysqld<BR>
<BR>
No response --> goes to next command line. <BR>
<BR>
Tried start with sudo and got the brief help screen for sudo. Guess is OK.<BR>
<BR>
<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ ExecStartPre=/usr/share/mysql/mysql-systemd-start pre<BR>
No command 'pre' found, did you mean: [etc.]<BR>
<BR>
<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ ExecStartPre=/usr/share/mysql/mysql-systemd-start<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ sudo mysql -umythtv -pmythtv mythconverg<BR>
[sudo] password for barry: <BR>
mysql: [Warning] Using a password on the command line interface can be insecure.<BR>
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<BR>
<Grrr!><BR>
<BR>
<BR>
-- -- -- --<BR>
<BR>
"REDO Section"<BR>
<BR>
OK, here is where I got my great idea to see what the hidden output was for this section:<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chmod 777 /var/log > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/mkdir /var/log/mysql > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chmod -v 0777 /var/log/mysql > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chpwn -v mysql:mysql /var/log/mysql > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chown -v mysql:mysql /var/log/mysql > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/touch /var/log/mysql/mysql.log > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chown -v mysql:mysql /var/log/mysql/mysql.log > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chmod 777 /var/log/mysql/mysql.log > /dev/null 2>&1<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ systemctl restart mysql.service<BR>
<BR>
<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ /usr/bin/chmod 777 /var/log<BR>
bash: /usr/bin/chmod: No such file or directory<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ sudo /usr/bin/chmod 777 /var/log<BR>
sudo: /usr/bin/chmod: command not found<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ chmod 777 /var/log<BR>
chmod: changing permissions of '/var/log': Operation not permitted<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ sudo chmod 777 /var/log<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ mkdir /var/log/mysql<BR>
mkdir: cannot create directory ‘/var/log/mysql’: File exists<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ sudo chmod -v 777 /var/log/mysql<BR>
mode of '/var/log/mysql' changed from 0750 (rwxr-x---) to 0777 (rwxrwxrwx)<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ sudo chown -v mysql:mysql /var/log/mysql<BR>
changed ownership of '/var/log/mysql' from mysql:adm to mysql:mysql<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ sudo touch /var/log/mysql/mysql.log<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ sudo chown -v mysql:mysql /var/log/mysql/mysql.log<BR>
changed ownership of '/var/log/mysql/mysql.log' from root:root to mysql:mysql<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ sudo chmod 777 /var/log/mysql/mysql.log<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ systemctl restart mysql.service<BR>
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.<BR>
<A HREF="mailto:barry@MythBE1">barry@MythBE1</A>:~$ <BR>
<BR>
Ah poo...<BR>
<BR>
<BR>
<BR>
</BODY>
</HTML>