Skip to main content
Question

OSX Mavericks upgrade to 10.9.3 caused MYSQL to stop working

  • May 31, 2014
  • 3 replies
  • 29 views
K
Forum|alt.badge.img+12

We upgraded Mavericks from 10.9.2 to 10.9.3 and upgraded OSX Server to 3.1.2, after the upgrade the MYSQL stopped running. The SQL Server Startup Status error is "The MySQL server installation was not found. Please make sure the /usr/local/mysql/bin/mysqladmin file is present. The MYSQL Server Instance is not running". cant login using command mysql -u root -p, it gives error "Error 2002 (HY000): Can't connect to local MYSQL server through socket '/tmp/mysql.sock' (2). We couldnt find any my.cnf file inside our sql installation folder. Any suggestions.

    3 replies

    K
    Forum|alt.badge.img+12
    • khurram
    • Author
    • Valued Contributor
    • June 2, 2014

    Our MYSQL was quite old, we had to upgrade the MYSQL from 5.5.92 to 5.6.17.

    1. after the upgrade we placed the jss folder in /mysql/data/ and renamed mysql folder

    2. gave full access to mysql on data folder and root to all mysql installation folder as follows.
      sudo chown -RL root:mysql /usr/local/mysql
      sudo chown -RL mysql:mysql /usr/local/mysql/data
      sudo /usr/local/mysql/support-files/mysql.server start

    3. login in to jss database using old users because we copied old jss folder so it has old users and their credentials or using root.

    4. created the 'jss' user again inside jss database, if doesnt exist already, check if this user is hidden.

    5. GRANT ALL on jss.* to 'jss'@'localhost';

    6. Re-run the jds installer it will pickup the database settings, just make sure jss credentials.

    7. test jss from your domain/8443

    this is what worked for us.

    R
    Forum|alt.badge.img+14
    • rlandgraf
    • Contributor
    • September 21, 2014

    I am getting the same error and really struggling today to get it back up and running. I am wondering what jus folder you are referring to in #1. I don't have a JSS folder anywhere aside from in the /Library folder and I am sure this isn't the folder you are referring too.
    Thanks for any help

    K
    Forum|alt.badge.img+12
    • khurram
    • Author
    • Valued Contributor
    • September 21, 2014

    @rlandgraf
    It took us a while to find out where the last admin (before me) had installed the jss folder. We didnt find it at its usual place. I think the best way would be to run some find commands via terminal (include hidden folders). May be something like this http://www.mac-forums.com/forums/os-x-development-darwin/150910-finding-file-terminal.html
    Or this
    http://www.macissues.com/2014/04/29/commands-for-finding-files-in-the-os-x-terminal/

    Terms & ConditionsCookie settingsAccessibility statement