[aprssig] MySQL dramas

[Andrew Rich]

Curious

Seems to be a conflict between dircetories, upgrade scripts and my.cnf

I rolled back all MySQl instances and modules.

I manually deleted a MySQL directory structure and got it to re-create

Seems a messy upgrade is causing me the dramas.

Andrew
  ----- Original Message ----- 
  From: Andrew Rich 
  To: Andrew Rich ; TAPR APRS Mailing List 
  Sent: Sunday, October 04, 2009 12:49 PM
  Subject: Re: [aprssig] MySQL dramas


  interesting

  From DVD the installed version was 

  5.0.67-12:11

  The online update installed

  5.0.67-12:16.1 when the probs started

    ----- Original Message ----- 
    From: Andrew Rich 
    To: TAPR APRS Mailing List 
    Sent: Sunday, October 04, 2009 4:26 AM
    Subject: [aprssig] MySQL dramas


    Hello

    I built a LINUX box for satellite tracking and APRS type stuff

    All was going well, until the box did an update

    Seems now I have no entry in the mysql.user table.

    I get the error "Access denied for user 'root'@'localhost' using PASSWORD: NO

    I managed to jump in without using grant options, and was able to see a blank user table.

    Can anyone suggest how to fix ? I tried uninstall and re-install same problem.

    The only way I fixed it before was to re-build from scratch, not real fun.

    I think what I need to do is get the root user back into the system

    Andrew VK4TEC


----------------------------------------------------------------------------


    _______________________________________________
    aprssig mailing list
    aprssig at tapr.org
    https://www.tapr.org/cgi-bin/mailman/listinfo/aprssig



----------------------------------------------------------------------------



    No virus found in this incoming message.
    Checked by AVG - www.avg.com 
    Version: 8.5.409 / Virus Database: 270.14.3/2411 - Release Date: 10/03/09 06:20:00



------------------------------------------------------------------------------



  No virus found in this incoming message.
  Checked by AVG - www.avg.com 
  Version: 8.5.420 / Virus Database: 270.14.3/2412 - Release Date: 10/03/09 18:34:00
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.tapr.org/pipermail/aprssig_lists.tapr.org/attachments/20091004/8bf07a70/attachment.html>