Welcome to AC Web.
Results 1 to 11 of 11
  1. #1

    [Win10] Trying to let a friend access mySQL Database


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    As the title suggests, I'm trying to allow my friend access to the mySQL server/databases for my compiled TrinityCore server.
    I've made his user and granted all the permissions to his account for the server but when he's trying to connect he gets an error:


    Covered part is his IP


    I've made sure that my port is being forwarded on 3306, but for some reason he's unable to get connected at all. The mySQL server is being hosted locally from my pc.
    Any suggestions or help?





    ~Thanks in advance

  2. #2
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,468
    When you create the account change the access to % which means access from everywhere.
    Since you said you have opened ports than all good because if you're using router than opening ports can't be via firewalls.
    Also make sure from the caps in the password or username.
    That's all.

  3. #3


    Join Date
    Feb 2013
    Location
    Right Behind You
    Posts
    311
    here :
    GRANT ALL PRIVILEGES ON *.* TO 'USER'@'localhost' WITH GRANT OPTION;

    GRANT ALL PRIVILEGES ON *.* TO 'USER'@'%' WITH GRANT OPTION;


    change USER to that user u created for ur friend

  4. #4
    I've already given him global access, should I be giving it for % and localhost?

  5. #5
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,468
    Quote Originally Posted by rekka911 View Post
    I've already given him global access, should I be giving it for % and localhost?
    Simply use HeidiSQL to create the USER it'll be much easier here is some pictures :





    Download HeidiSQL online free

  6. #6
    I've done all that. Still the same error coming up.

    (also) I'm using Heidi already

  7. #7
    Quote Originally Posted by rekka911 View Post
    I've done all that. Still the same error coming up.

    (also) I'm using Heidi already
    If you are sure that the port forward on the router is working properly, i would check the Windows firewall to check if its allow incoming connection on that port. Have had this issue with other things before.

  8. #8
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,468
    Quote Originally Posted by leifus View Post
    If you are sure that the port forward on the router is working properly, i would check the Windows firewall to check if its allow incoming connection on that port. Have had this issue with other things before.
    True, make sure you added output port 3306

  9. #9
    Added it to my firewall now he's running into the error of
    "Can't connect to MySQL server on 'IP.xxx.xx.xxx'
    (10060)

  10. #10
    Follow the first part of this tutorial. The portforward was working correctly since your first post.

    In other words; you need to modify the configuration file (mysql.cnf) of your MySQL installation and make sure that the field bind-address is set to 0.0.0.0

  11. #11

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    That tutorial is for Linux not Windows, call me dumb but I am not finding any cnf file what so ever.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •