[aprssig] MySQL dramas

[Andrew Rich]

I fixed it

ASUS eeePC 1008HA

+ re-install openSUSE 11.1 
+ disable online repos and updates
+ install mysql
+ install apache2
+ install PHP
+ install kernel-source
+ install gcc and make
+ changed PHP to short tags 
+ turned on PHP globals
+ installed LAN drivers
+ configure LAN, IP DNS ROUTE DEFAULT GW
+ connected to net
+ turned on mysql and apache2 and saved run-levels
+ add crontab jobs
+ installed XASTIR and PREDICT
+ added imagemagick etc for XASTIR
+ modify defaul apache2 setup
+ add samba
+ copied back web pages and scripts
+ added no-ip.org binary
+ added ssh service
+ install perl DBD
+ install PHP mysql
+ restart apache2

Andrew VK4TEC
  ----- 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/943a9c58/attachment.html>