View Full Version : [SOLVED] Having Problems giving out Database Acces

10-27-2013, 12:54 PM
Greetings EmuDevs Community!

I'm trying to hand out database acces to a friend of mine ( None Hamachi - We using .servegame.org )

( I have port 3306 open )

Basically what i do is : Open up HeidiSQL / Navicat -> Manage user authentication and privileges

User Name : Test1
From Host : " XXXXXXXXX.servegame.org "
Password : Test2
Repeat Password : Test2

When he enters the information, it says he is NOT allowed to enter.

10-27-2013, 01:00 PM
Have you got remote access set in your config files.

10-27-2013, 01:04 PM
Make sure the From Host is his actual IP.
You could first use % to wildcard just to test if it's working, but using a wildcard increases exposure though.

will look like this for heidi :

10-27-2013, 01:30 PM

10-27-2013, 01:37 PM
Thank you.

What i did i was : Added their in-game .pinfo IP after that i added their CMD IP, and last i added a % to their name.

May i ask, how is it risky using %?

10-27-2013, 03:04 PM
Using % means that every computer can connect to your database as long as they know the username and the password of the user.
If you actually set a specific IP for the user, it means that even though someone has your username and password they can't connect to your database ( unless they're on the specific computer ofcourse)