Help configuring mySQL

    • OMV 2.x

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Help configuring mySQL

      Hi all,

      I'm trying to use the guide here to configure mySQL -- after that I want to get Greyhole up and running. I have no prior experience with mySQL and so am not 100% confident that I'm interpreting the Guide correctly.

      The Guide refers to using SQL Buddy to change some root passwords. As a reply to that post says, SQL Buddy doesn't appear to be the management console that is in use on the latest version of OMV. When I carry out steps 5-6 my server gives me MyWebSQL version 3.6 - screenshot attached.

      What I'm not sure about is how to translate the instructions given in the Guide into the different interface offered by MyWebSQL. The instructions refer to 'putting a checkmark' next to three different users and then setting their passwords. I can find the 'User Manager' tool under the Tools menu at upper left, and I can see the three users referred to in step 6 of the Guide. However, I'm not sure what the checkmark referred to in step 6 refers to when translated across to the MyWebSQL interface, as opposed to the SQL Buddy one. I'd prefer not to change any settings without being sure what I should be doing, since I don't want to break anything.

      Can anyone point me in the right direction, please?

      Thank you!
      Images
      • Untitled.png

        67.77 kB, 1,920×1,200, viewed 140 times
    • Hi,

      I am going through MySQL setup again, this time on an RPi OMV setup that I'm making for a friend.

      Was following instructions here and above in this thread to set up MySQL as a precursor to setting up Greyhole. While setting MySQL admin passwords as per step 6 of the guide (modified as per earlier posts in this thread which responded to my question), MyWebSQL logged out and went back to its login window, and wouldn't log back in again. Now if I try to get back into the management site, I get an error message (see screenshot) and can't log in as root, either using the blank password or the one I had set for two out of the four users by the time of the problem.

      Any ideas how I can get back in to finish editing the root passwords?

      Thanks!
      Images
      • Untitled.png

        20.91 kB, 522×420, viewed 97 times