<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span><br></span></div><div><br><blockquote style="border-left-width: 2px; border-left-style: solid; border-left-color: rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px; "> <div style="font-family: 'times new roman', 'new york', times, serif; "> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Steve Hodge <stevehodge@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> MythTV in NZ <mythtvnz@lists.linuxnut.co.nz> <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, 1 June 2012 9:36 PM<br> <b><span style="font-weight:
bold;">Subject:</span></b> Re: [mythtvnz] I killed MYSQL now what?<br> </font> </div> <br><div id="yiv1634262176"><div class="yiv1634262176gmail_quote">On Fri, Jun 1, 2012 at 9:10 PM, criggie <span dir="ltr"><<a rel="nofollow" ymailto="mailto:criggie@criggie.org.nz" target="_blank" href="mailto:criggie@criggie.org.nz">criggie@criggie.org.nz</a>></span> wrote:<br><blockquote class="yiv1634262176gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="yiv1634262176im">On 01/06/12 21:00, Steve V wrote:<br>
<blockquote class="yiv1634262176gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1<br>
</blockquote></div>
Something tried to change the table called user by adding a column called Show_view_priv but something's wrong with the command.<div class="yiv1634262176im"><br>
<br>
<br>
<blockquote class="yiv1634262176gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
ERROR: 1050 Table 'plugin' already exists<br>
</blockquote></div>
Something's trying to create a table in the database called plugin, and it already exists.</blockquote><br>Both "user" and "plugin" are mysql system tables. It looks like something is trying to upgrade the mysql core schema and failing. The Show_view_priv column was added in 5.0.1. The plugin table was added in 5.1. What version do you have installed?<br>
<br>What is interesting is that from the log it looks like it's gone through a couple of shutdown/startup cycles. And the second time it failed at a different point in the upgrade script. Do you still get the same error now?<br>
<br>Cheers,<br>Steve<br></div>
</div><br>>> I tried reinstalling again.</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; " class="yui_3_2_0_19_133854651864463"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; " class="yui_3_2_0_19_133854651864463">error log is now as before.</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; " class="yui_3_2_0_19_133854651864463"><br></div><div class="yui_3_2_0_19_133854651864463"><font size="3">interesting in the details while mysql was installing I saw </font> "Unknown job: mysql"</div><div class="yui_3_2_0_19_133854651864463"><br></div><div class="yui_3_2_0_19_133854651864463">if I run </div><div class="yui_3_2_0_19_133854651864463">sudo service mysql restart</div><div><br></div><div>I get</div><div><div>Rather than invoking init scripts through /etc/init.d, use the service(8)</div><div>utility,
e.g. service mysql restart</div><div><br></div><div>Since the script you are attempting to invoke has been converted to an</div><div>Upstart job, you may also use the stop(8) and then start(8) utilities,</div><div>e.g. stop mysql ; start mysql. The restart(8) utility is also available.</div><div>start: Unknown job: mysql</div><div><br></div><div>Is there a clue in the above?</div><div><br></div><div>sudo start mysql </div><div>gives</div><div><div>start: Unknown job: mysql</div><div><br></div></div><div><br></div></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span style="font-size: 12pt; "><br></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; " class="yui_3_2_0_19_133854651864463"><br><br> </div> </div> </blockquote></div> </div></body></html>