mysql question: how to grant remote access..

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mrthumbs
    salad tossing sig guy
    • Apr 2002
    • 11702

    #1

    mysql question: how to grant remote access..

    i tried a
    GRANT ALL PRIVILEGES ON *.* TO '%'@'%' IDENTIFIED BY 'passwd';
    with a flush

    and ive tried it with setting a username and host address..

    All access denied when i connect remote..

    Is there some config file i have to change?
  • mrthumbs
    salad tossing sig guy
    • Apr 2002
    • 11702

    #2
    ports are open because mysql responds with a "access denied"..

    Comment

    • Juicy D. Links
      So Fucking Banned
      • Apr 2001
      • 122992

      #3
      GRANT ALL PRIVILEGES TO JUICY ON *.* TO '%'@'%' IDENTIFIED BY MEOW 'passwd';
      with a flush of the colon. MEOWWWW WOOFF MYSQL

      That should work

      Comment

      • mrthumbs
        salad tossing sig guy
        • Apr 2002
        • 11702

        #4
        Originally posted by Juicy D. Links
        GRANT ALL PRIVILEGES TO JUICY ON *.* TO '%'@'%' IDENTIFIED BY MEOW 'passwd';
        with a flush of the colon. MEOWWWW WOOFF MYSQL

        That should work

        hahahahaha.. man that shit is build in by default!

        Comment

        • Juicy D. Links
          So Fucking Banned
          • Apr 2001
          • 122992

          #5
          Originally posted by mrthumbs
          hahahahaha.. man that shit is build in by default!
          :costumed- :costumed- :costumed- :costumed- :costumed-

          Comment

          • ServerGenius
            Confirmed User
            • Feb 2002
            • 9377

            #6
            GRANT ALL PRIVILEGES ON *.* TO '%'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

            You don't need to flush privileges if you use grant, flush you only need if you
            use insert or update to edit permissions.
            | http://www.sinnerscash.com/ | ICQ: 370820 | Skype: SinnersCash | AdultWhosWho |

            Comment

            Working...